If you have a requirement to modify any Informix table that is marked for replication, you must first shut down the iWay Informix CDC Agent application by using the InformixLEAShutdown.sh script. For more information, see Shutting Down the iWay Informix CDC Agent Application.

Once the iWay Informix CDC Agent application is shut down and all processes have stopped, you can modify your Informix table as required.

After your Informix table is modified, you must use the UPDATE command to update a dummy record into that table.

For example:

 UPDATE tablename SET fieldname=fieldname;

You can use the ONCHECK command that is provided by Informix to check the structure of the modified table.

For example:

Oncheck –pT databasename;tablename |more

Note: After you have used the UPDATE command to update the Informix table, the Version (oldest) should be set to 0.