IBM Db2 LUW Transactional Replication Settings
Enable Transactional Replication wizard or the Manage Transactional Log Settings dialog
The information below explains how to configure the transactional replication settings for IBM Db2 LUW i in the Enable Transactional Replication wizard or the Transactional Log Settings dialog available from the Transactional Setup > Manage option on the connection in the Metadata Explorer.
When replicating from IBM Db2 LUW using mirroring or synchronization, two transactional modes are available: Log Reader and Triggers.
Log Reader Settings
To define a mirroring or synchronization replication, you first need to set up stored procedures to access the log on your Db2 system. Before completing this screen, make sure that you have followed all the requirements for your Db2 connection described in IBM Db2 Connection Requirements.
Stored Procedures Schema Name
The default value provided is the ID of the
user specified in the Db2 connection. The value can be edited to reflect
whichever schema you want to use for the log reading stored procedures.
There are a total of three procedures created:
The library/dll has 3 stored procedures:
-
LOGVER03 is used to identify the version of the stored procedures/library so that a mismatched version is not used
-
CURLSN03 is used to find and retrieve the current LSN or Transaction ID in the Db2 log
-
LOGREC03 is used to read and retrieve changed records from the Db2 log
Log Reader Library Version
A read-only field that displays the version of the file you copied from the ServerFiles/Db2UDB folder to your Db2 Server function folder. See IBM Db2 Connection Requirements for information on the files to copy and additional setup requirements.
Verify (available only in the Manage Transactional Log Settings dlialog)
Click Verify to check that:
-
Log-based transactional replication is supported for the Db2 version that you are using
-
The stored procedures that Syniti DR will use are installed on the server.
READDB2UDB_LOGVER03
READDB2UDB_CURLSN03
READDB2UDB_LOGREC03
To later remove the stored procedures from the server, use the Disable Transactional Replication wizard available from the Transactional Setup > Disable option on the connection in the Metadata Explorer.
Triggers Settings
Related Topics
IBM Db2 Connection Requirements
Trigger-based Setup Info