Using Remote Journals (Db2 for i Source)

Remote journaling, a core component of the IBM i operating system, efficiently replicates the contents of a journal receiver to a remote system. SQDR Plus can be configured to obtain updates from the remote journal to reduce the impact on the primary system or to reduce network traffic.

You can use either type 1 or type 2 journal receivers and either synchronous or asynchronous mode. Both broadcast or cascading distributions are supported for multiple remote targets, though the configuration will differ.


To configure Remote Journaling:

  1. Configure and activate remote journaling on the Db2 for i source.

  2. In SQDR Control Center, select the desired database (the agent for the primary system) in the left panel and open the Remote Journals panel.

  3. Click the Plus symbol icon at the top to add an entry.

  4. In the Add Remote Journal Mapping dialog, select a schema and a (local) journal. The Remote Journal drop-down field will be populated with the configured remote journal(s).  It will have the form of <remotelib>/<remotejrn>@remotesys e.g. RMTLIB/QSQJRN@RMTSYS. If nothing appears in the Remote Journal drop-down field, check that the agent schema user (e.g SQDR) on the source system has sufficient authority to the journal and to the library containing the journal.

  1. If you have configured broadcast distribution, there will be multiple entries available in the drop-down field for remote journal; select the desired entry.

  2. Click OK.

  3. If you are using cascading distribution and wish to use a different remote journal than any of those known to the primary system, modify the Host, Library and Journal fields by clicking on the displayed data and changing the text. The Host may be specified as a hostname or an IP address.

  4. You will also need to enter data for User, Password, and Agent Schema for the remote system by clicking on each field and adding text. These values are used to access the secondary i system:

  1. Use the Undo icon near the top of the window if you wish to undo any changes.

  2. Click the Save icon near the top of the window.  Note that the password field now displays an encrypted value.

To remove Remote Journaling configuration:

  1. In SQDR Control Center, select the desired database in the left panel and open the Remote Journals panel

  2. Select the checkbox for the mapping that you wish to delete.

  3. Click on the Minus sign icon near the top of the window.

  4. Remove the host components from the secondary system.

  5. Click the Save icon near the top of the window.

The journal receivers on the primary system will be used for future updates.


Updating host components:

Running Update Host Components to your primary source system will also update host components on the secondary system.

Removing host components from the secondary system:

Assuming that you used the name SQDR for the schema on the secondary i system, do the following:

  1.  Delete the registration for the SQDR/CADLTRCV exit program by either using the command CALL PGM(SQDR/CALOGMGMT) PARM('U' 'SQDR') OR using the WRKREGINF command as follows:

  1. Enter WRKREGINF at a command line.

  2. Page down to a Journal Receiver exit point:


  4. Enter 8 in the Opt field to the left of the exit point entry and press Enter.

  5. At the Work with Exit Program display, identify the exit program entry for “CADLTRCV” in library “SQDR” and enter a 4 (Remove).

  6. Press Enter.