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.
The Remote Journaling panel of SQDR Control Center is used to instruct SQDR Plus where to pick up journal updates for a particular journal on the primary system.
Incremental replications are configured with Data Replicator Manager (tier 3).
The baseline is transferred directly from the source system to the tier 3 SQDR system.
Updates are written to the local journal receiver and then transferred by the i System to the remote journal receiver.
SQDR Plus retrieves updates from the remote journal receiver.
SQDR (tier 3) retrieves the updates from the SQDR Plus (tier 2) staging database.
Configure and activate remote journaling on the Db2 for i source.
In SQDR Control Center, select the desired database (the agent for the primary system) in the left panel and open the Remote Journals panel.
Click the Plus symbol icon at the top to add an entry.
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.
If you have configured broadcast distribution, there will be multiple entries available in the drop-down field for remote journal; select the desired entry.
Click OK.
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.
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:
User: a user with sufficient authority (e.g. SECOFR authority) to create a user, create a collection, restore a library from a SAVF, and issue various grants and ownership changes. This user is used to perform setup operations, and is the owner of the RJRNLAPI service program and the CADLTRCV exit program.
Password: password for the user.
Agent Schema: the name of a collection ( e.g. SQDR) to create and populate on the remote system; this collection is the location for user spaces, control tables the RJRNLAPI service program and the CADLTRCV exit programs. A user by the same name as the collection will be created. This collection and user should not already be in use on the remote system; if you are also using the remote system as a primary source of another SQDR Plus Agent, we recommend entering a different name e.g. SQDRRMT.
Use the Undo icon near the top of the window if you wish to undo any changes.
Click the Save icon near the top of the window. Note that the password field now displays an encrypted value.
In SQDR Control Center, select the desired database in the left panel and open the Remote Journals panel
Select the checkbox for the mapping that you wish to delete.
Click on the Minus sign icon near the top of the window.
Click the Save icon near the top of the window.
Running Update Host Components to your primary source system will also update host components on the secondary system.
Assuming that you used the name SQDR for the schema on the secondary i system, do the following:
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:
Enter WRKREGINF at a command line.
Page down to a Journal Receiver exit point:
QIBM_QJO_DLT_JRNRCV DRCV0100
Enter 8 in the Opt field to the left of the exit point entry and press Enter.
At the Work with Exit Program display, identify the exit program entry for “CADLTRCV” in library “SQDR” and enter a 4 (Remove).
Press Enter.
DLTLIB SQDR
DLTUSRPRF SQDR