1618 - IBM i Settings for Transactional Replications

The following warning will occur in the Syniti DR/DBMoto log if you have not made the appropriate settings in the IBM i/iSeries/AS400 journal used for your mirroring or synchronization replication:

Warning Journal UP not preceded from UB. Set IMAGES(*BOTH) in journal options.

The IMAGES parameter can be set to either *BOTH or *AFTER. It is recommended to set the IMAGES parameter to *BOTH to save the record’s image in the log, before and after the update command in order to correctly manage the record’s primary key in Syniti DR/DBMoto. If you choose to set the IMAGES parameter to *AFTER, 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 as follows:

1. Create an Int field on the target table and make it the primary key.
2. Create source and target connections for the replication.
3. Define the replication.
4. When mapping source and target fields, right click on the target table field you want to map the RRN to, and choose Map to Expression...
5. In the upper pane of the Expression Editor, type [!RecordID].
6. Click OK to save the expression.
   
   Note: You should not set the IMAGES parameter to *AFTER if you are planning to perform synchronization (bi-directional mirroring). Also if the source table is reorganized, you need to run a refresh replication on the target table (to update RRN changes) before mirroring can proceed again.

This setting is not required if you're going to manage a refresh replication.

See knowledge base article 1556 on Journals and Receivers for more details.