MySQL
Identify the name of the Replicat checkpoint table by using the following parameter statement in the Extract parameter file.
TRANLOGOPTIONS FILTERTABLE table_name
Replicat writes a checkpoint to the checkpoint table at the end of each of its transactions as part of its checkpoint procedure. (This is the table that is created with the ADD CHECKPOINTTABLE
command.) Because every Replicat transaction includes a write to this table, it can be used to identify Replicat transactions in a bidirectional configuration. FILTERTABLE
identifies the name of the checkpoint table, so that Extract ignores transactions that contain any operations on it.