Reversion requirements for an Informix warehouse server and Informix Warehouse Accelerator

Reversion of a database server that contains data marts that were created with Informix Warehouse Accelerator

Before you use the onmode -b command to revert the database server, you must drop all of the data marts that are associated with that database server.

If you do not drop the data marts and the reversion succeeds, the system databases might be rebuilt and the AQTs will disappear. As a result, the data marts that are associated with the reverted databases are orphaned and consume space and memory in the accelerator server.

Reversion of a database server where workload analysis was used to create data mart definitions

If you created data mart definitions by using workload analysis, before starting the reversion, drop the tables that were created by the probe2Mart() procedure.

• If you created a separate logging database to use with the probe2Mart() procedure, all of the data mart definition information will be in tables in that separate database. You can drop that database without impacting the other databases.
• If you used your warehouse database as the logging database with the probe2Mart() procedure, you must manually drop each of the permanent tables that were created by the probe2Mart() procedure.

If you do not drop the tables before you start reversion, the reversion will fail.