Reverting from Dynamic Server 10.0 with Enterprise Replication

You can only use the following procedures to revert from Dynamic Server 10.0 to Dynamic Server 9.40, 9.30, 9.2x, or 7.31 .

When you revert from Version 10.0 to an earlier version of Dynamic Server with Enterprise Replication:

The procedure for reverting to Dynamic Server 9.40 or 9.30 is slightly different than the procedure for reverting to Dynamic Server 9.2x or 7.31. To revert to Dynamic Server 7.31, the database server must be an Enterprise Replication root server (the uppermost level in a hierarchically organized set of database servers).

To revert to Dynamic Server 9.40 or 9.30 from Dynamic Server 10.0 with Enterprise Replication

Stop applications doing replicatable transactions.
You cannot revert if Enterprise Replication is in Alter mode, so make sure Enterprise Replication is not in Alter Mode. Use onstat -g cat repls to see if Enterprise Replication is in Alter mode. If it is in Alter mode, change the mode.
Delete shadow replicates.
Make sure that control and TRG send queues are empty:
- Run onstat -g grp to ensure that grouper does not have any pending transactions.
- Run onstat -g rqm to check for queued messages.
Shut down Enterprise Replication with the following command:
```
cdr stop
```
Back up the syscdr databases with dbschema or UNLOAD.
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:
```
% sh revcdr.sh 10.0 9.30
```
This script does a reversion test followed by the actual Enterprise Replication reversion.
If the reversion test or actual reversion fails, then check the file $INFORMIXDIR/etc/revtestcdr.out or revcdr.out, respectively. Attempt reversion after resolving problems reported.
Perform database server reversion tasks, as described in Reverting from Dynamic Server 10.0 to Versions 9.40, 9.30, 9.2x, 7.3x, or 7.24.
Run onmode -l and onmode -c. If you do not do this after reversion and before starting Enterprise Replication, the database server might fail when you start Enterprise Replication.
Start Enterprise Replication:
```
% cdr start
```

To revert to Dynamic Server 9.2x or 7.31 from Dynamic Server 10.0 with Enterprise Replication

Drop all replicate sets.
Drop any replicate that contains a smart large object or user-defined data type.
Stop applications doing replicatable transactions.
Make sure that control and TRG send queues are empty:
- Run onstat -g grp to ensure that grouper does not have any pending transactions.
- Run onstat -g rqm to check for queued messages.
Shut down Enterprise Replication with the following command:
```
cdr stop
```
Back up the syscdr databases with dbschema or UNLOAD.
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:
```
% sh revcdr.sh 10.0 to_version
```
Valid to_version values are:
```
9.21
9.20
7.31
```
This script does a reversion test followed by the actual Enterprise Replication reversion.
If the reversion test or actual reversion fails, then check the file $INFORMIXDIR/etc/revtestcdr.out or revcdr.out, respectively. Attempt reversion after resolving problems reported.
Drop the Enterprise Replication sbspaces.
Perform database server reversion tasks, as described in Reverting from Dynamic Server 10.0 to Versions 9.40, 9.30, 9.2x, 7.3x, or 7.24.
Run onmode -l and onmode -c. If you do not do this after reversion and before starting Enterprise Replication, the database server might fail when you start Enterprise Replication.
Start Enterprise Replication:
```
% cdr start
```