Home | Previous Page | Next Page   Appendix J. Conversion and Reversion Scripts for HPL Database Migration >

Upgrading the High-Performance Loader onpload Database

Starting with Version 9.40.xC3, Dynamic Server has a new version of the onpload database with longer column lengths. The onpload database now requires slightly more disk space than it did in previous versions. The following table shows the relationship between the database server version and the onpload database schema version.

Database Server Version onpload Database Version
Pre 7.3 0 or not available
7.31 1
9.2, 9.3, 9.40.xC1, 9.40.xC2 2
9.40.xC3 and later 3

When you upgrade to a new version of Dynamic Server, you must also upgrade the onpload database.

If are upgrading from a version of Dynamic Server that is prior to Version 9.40, you must run a Dynamic conversion script. For instructions for running this script, see your IBM Informix: Migration Guide.

You can use the IFX_ONPLOAD_AUTO_UPGRADE environment variable with the ipload or onpladm utilities to automatically upgrade the onpload database the first time you invoke an HPL utility using the ipload or onpladm command after you migrate to a new database server version. You cannot use the IFX_ONPLOAD_AUTO_UPGRADE environment variable with the onpload utility. For more information on this environment variable, also see your IBM Informix: Migration Guide.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]