Home
Migrating and upgradingYou can upgrade to the 14.10 release of HCL Informix® or migrate from other database servers to Informix®. Upgrading is an in-place migration method that uses your existing hardware and operating system software. Some changes to the Informix® database server can affect upgrading from a previous release.
Migrating Informix® database systemsThe Informix® Migration Guide describes how to move data manually between databases, servers, and computers.
Migration to and reversion from 14.10
Reverting from Informix® Version 14.10You can revert to the version of the database server from which you migrated. When you run the reversion utility, you specify the target server for reversion and then Informix® checks your database. If necessary, Informix® might tell you to drop new objects, before automatically converting your data into the target server.
Preparing to revertIf you used Version 14.10, you must prepare your system for reversion to the pre-migration version of the database server.
Save system catalog informationIf your current database server instance uses secure-auditing masks or external spaces, and you want to preserve the associated catalog information, you must unload these system catalog tables before you revert.

Save system catalog information

If your current database server instance uses secure-auditing masks or external spaces, and you want to preserve the associated catalog information, you must unload these system catalog tables before you revert.

Run the following command to unload the system catalog tables:

$INFORMIXDIR/etc/smi_unld

When the smi_unld utility finishes unloading the information, the utility displays instructions for reloading the information. Save these instructions. After you complete the reversion and bring up your database server, you can reload the data that you preserved. Follow the instructions given with the smi_unld utility for reloading the information. Typically, you run the following command:

$INFORMIXDIR/etc/smi_load $INFORMIXDIR/etc/

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.