IBM Db2 for i Journal Information

Create Replication wizard and Create Multiple Replications wizard Source Log Info screen

Journal

This field displays the journal that has been set for the source table on the IBM Db2 for i (iSeries/AS400) system. Typically, you do not need to edit this field.  

Any journal specified in this field should usually have the IMAGES parameter set to *BOTH. This option saves the record's image before and after the transaction and makes available the primary key information needed by Syniti Data Replication. However, it is possible to set the IMAGES parameter to *AFTER, but you will need to modify the target table by adding a Relative Record Number (RRN) field and mapping it to the source table !RecordID field. For more information, see IBM i System Journals and Receivers.

This information is available and can be changed in the Table Properties dialog after the wizard is completed.

Receiver

This field displays the receiver that has been set for the source table on the Db2 system. Typically, you do not need to edit this field. However, if you know that you want to begin replication from a specific receiver and transaction ID, you can enter values in this field and the Transaction ID field.

Transaction ID

Enter the sequence number, retrieved from the receiver, from which you want to start monitoring database transactions for replication. If you do not know the sequence number, click Read to open the Journal Read Point dialog. In this dialog, you can either retrieve the current sequence number or the sequence number for a specified date and time. If you enter a date and time, Syniti DR retrieves the first sequence number after the time entered. This information is available and can be changed in the Replication Properties dialog after the wizard is completed.

Transaction Timestamp

This field is automatically filled in and reports the timestamp for the sequence identified in the Transaction ID field.

Read Interval (sec)

The frequency (in seconds) with which you want to check the journal during replication. For example, if the setting is 90 seconds, Syniti DR will check the journal every 90 seconds to see if any transactions have occurred that need to be replicated to the target table. This information is available and can be changed in the Replication Properties dialog after the wizard is completed.