Converting to Dynamic Server 10.0 with Enterprise Replication

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

To convert from an earlier database server, you need to convert to an intermediate database server first. For information on which intermediate database server to use, see Database Server Migration Paths. For information on how to convert to the intermediate database server, see the Migration Guide that is included in the IBM Informix documentation for that database server.

To prepare for conversion to Dynamic Server 10.0 with Enterprise Replication

If you have replicate groups, which Dynamic Server 10.0 does not support, remove all of them.
Stop applications that are performing replicable 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.
Replace old event class identifiers (IDs) used in the ALARMPROGRAM with the new event class IDs.
Shut down Enterprise Replication with the following command:
```
cdr stop
```

To convert to Dynamic Server 10.0 with Enterprise Replication

Perform the conversion tasks described in In This Chapter, including starting Dynamic Server 10.0.
If the CDR_QDATA_SBSPACE configuration parameter is not set, set it in the ONCONFIG file to the sbspaces for Enterprise Replication to use for storing spooled row data.
Back up the syscdr databases with the dbschema or the UNLOAD statement.
Make sure that no replicatable transactions occur before Enterprise Replication starts.
Run the conversion script, named concdr.sh, in the $INFORMIXDIR/etc/conv directory on UNIX, or concdr.bat, in the %INFORMIXDIR%\etc\conv directory on Windows:
```
% sh concdr.sh from_version 10.0
```
Valid from_version values are:
9.40, 9.30, 9.21, 9.20, and 7.31
Wait for one of the following messages:
```
'syscdr' conversion completed successfully.
'syscdr' conversion failed. 
```
For details about the conversion, see the following file:

$INFORMIXDIR/etc/concdr.out or %INFORMIXDIR%\etc\concdr.out
If conversion fails, resolve the problem reported in the concdr.out file, restore the syscdr database from a backup, and then attempt conversion again.
After successful conversion, start Enterprise Replication:
```
% cdr start
```

After you convert to Dynamic Server 10.0 with Enterprise Replication from Dynamic Server 9.30, 9.2x, or 7.31, do not drop the syscdr database. If syscdr is dropped, then you cannot revert from Dynamic Server 10.0 to the older database server with Enterprise Replication because the data required to carry out the reversion is stored in the syscdr database.