PostgreSQL and SQL Server
Identify the name of the
Replicat checkpoint table by using the following parameter statement in the Extract
parameter file and ensure that the Replicat checkpoint table has been enabled for
supplemental logging with the ADD TRANDATA
command.
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 bi-directional configuration. FILTERTABLE
identifies the name of the checkpoint table, so that Extract ignores transactions that contain any operations on it.