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:

1. On the target system, create the Replicat checkpoint file.

   Set the name of the journal that is intended to be used for the checkpoint file. The default will be <GGSCHEMA>/OGGJRN. You can change it by setting the default using the DEFAULTJOURNAL command. The syntax of the DEFAULTJOURNAL command is:

   DEFAULTJOURNAL library_name/journal_name
   

   Where: library_name is the name of the library and journal_name is the name of the journal to be used for subsequent operations that may optionally have a journal specified..

2. Add the checkpoint table.

   ADD CHECKPOINTTABLE library_name.chkptab 
   
   Successfully created checkpoint table kgr.chkptab 
   

3. Add journaling to the checkpoint table.

   ADD TRANDATA library_name.CHKPTAB
   

For more information about creating a checkpoint table, see Add a Checkpoint Table.