Reverting with Enterprise Replication

If you use Enterprise Replication, you must complete replication-related tasks when you revert from the new version of Informix®. If you are reverting from Informix 12.10.xC4 or later to a fix pack earlier than 12.10.xC4 in the same release, you also have to complete these tasks.

Prerequisites:

  • Perform all reversion operations as user informix.
  • Enterprise Replication must be running, or you must delete the replication server before you revert.
  • All servers in the Enterprise Replication domain must be available.
  • Replication queues must be nearly empty.

If you want to revert to a version earlier than when Enterprise Replication was defined on this server, you must remove Enterprise Replication from this server before reverting. After you remove Enterprise Replication, you can revert your server using the instructions at Reverting from Informix Version 12.10.

To revert from Version 12.10 with Enterprise Replication:

  1. Release or remove any grid statements that are deferred from propagation by running the ifx_grid_release() or ifx_grid_remove() function.
  2. Stop applications that are doing replicable transactions.
  3. Remove Enterprise Replication features from the current release that cannot be reverted. For more information, see Reversion requirements and limitations.
  4. Run the onstat -g cat repls command to check whether if Enterprise Replication is in alter mode. If so, run the cdr alter --off command.
  5. Delete shadow replicates.
  6. Back up the syscdr databases with dbschema or UNLOAD.
  7. Run the reversion script, named revcdr.sh, in the $INFORMIXDIR/etc/conv directory on UNIX, or revcdr.bat, in the %INFORMIXDIR%\etc\conv directory on Windows:
    To revert from 12.10.xC4 or later to an earlier version:
    • UNIX: % sh revcdr.sh 12.10.xC4 to_version
    • Windows: revcdr.bat 12.10.xC4 to_version

    Because version 12.10.xC4 is the latest fix pack with conversion, specify 12.10.xC4 even if you are reverting from a later fix pack version, such as 12.10.xC6.

    Valid to_version values are 12.10.xC3, 12.10.xC2, 12.10.xC1, 11.70, 11.50, 11.10, and 10.00. You do not have to specify a fix pack level except where noted.

    To revert from earlier 12.10 fix packs:
    • UNIX: % sh revcdr.sh 12.10 to_version
    • Windows: revcdr.bat 12.10 to_version
    Valid to_version values are 11.70, 11.50, 11.10, and 10.00.

    This script runs a reversion test followed by the actual Enterprise Replication reversion.

    Important: If the reversion test or actual reversion fails, check the file $INFORMIXDIR/etc/revtestcdr.out or revcdr.out. Resolve any problems before going to the next step.
  8. Perform database server reversion tasks, as described in Reverting from Informix Version 12.10.
  9. Run onmode -l and onmode -c to prevent the database server from failing when you start Enterprise Replication.
  10. Start Enterprise Replication by running the cdr start command.

Copyright© 2018 HCL Technologies Limited