The onrestorept utility

You can use the onrestorept utility to restore the database server back to the state that it was in just before the start of the failed upgrade.

The utility depends on these configuration parameters being set correctly before you attempt to upgrade the database server:

  • The CONVERSION_GUARD configuration parameter must be set to 1 or 2 (the default value) for data to be stored during an upgrade. If the conversion guard operations fail (for example, because the server has insufficient space to store the data that is captured during the upgrade), you cannot use the onrestorept utility.
  • The RESTORE_POINT_DIR configuration parameter must specify a directory where the conversion guard utility can store data files during the upgrade. Those files are needed to restore the database server to a consistent state after a failed upgrade. This directory must be empty before the upgrade starts. After a successful upgrade, the contents of the directory are automatically removed.
Important: Informix® must be offline when you run the onrestorept utility. Do not start the server until the utility finishes running. Executing the onrestorept utility when the server is online, or starting the server before the utility finishes running, can damage the database and requires you to restore the database server from a backup copy.

To start Enterprise Replication after the onrestorept utility restores the database server to a consistent state, you must use the cdr cleanstart command.