When using the Log server Agent option to set up transactional replications from IBM Informix, a service runs automatically to manage the data replication from source to target. However, if the service is stopped for some reason, the Log Server Agent turns off the full row logging feature, which is then needed for subsequent replication. Syniti Data Replication 9.7.1.14 or later offers an option to keep the full row logging running. In the Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog, set the Extra Option:
TURN_OFF_FULLROWLOGGING=NO
IMPORTANT:
If this option is set, it has the following consequences:
- If a table is removed from replication, the logging must be turned off manually.
- The DBA cannot perform any maintenance action with an ALTER statement on any of the tables while full logging is on.
Options to turn off logging:
- Clear this setting in the Manage Transactional Log Settings dialog and restart the service.
- Manually execute a SQL statement to call the function cdc_set_fullrowlogging.
For example:
EXECUTE FUNCTION SYSCDCV1:informix.cdc_set_fullrowlogging('mydb:myschema.mytable',0)