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:

In GGSCI 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 for the current GGSCI session 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..

Add the checkpoint table.

ADD CHECKPOINTTABLE library_name.chkptab 

Successfully created checkpoint table kgr.chkptab

Add journaling to the checkpoint table.
```
ADD TRANDATA library_name.CHKPTAB
```

For more information about creating a checkpoint table, see Administering Oracle GoldenGate.