Creating a Checkpoint Table
Replicat maintains its checkpoints in a checkpoint table in the Db2 for i target database. Each checkpoint is written to the checkpoint table, that must be journaled, within the Replicat transaction. Because a checkpoint either succeeds or fails with the transaction, Replicat ensures that a transaction is only applied once, even if there is a failure of the process or the database.
A common method of create the checkpoint table with journaling is as follows:
For more information about creating a checkpoint table, see Add a Checkpoint Table.