IBM Db2 for i (iSeries/AS400) 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 for 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 for i using mirroring or synchronization, three transactional modes are available: Log Reader, Log Server Agent and Log Reader API. The Log Reader API is required when replicating tables with LOB values. Note that the Log Reader API option is available for Db2 for i V6R1 and above.

For all three modes, you first need to set up a library on your Db2 system. This step sets up the library by transferring a savf file to the Db2 server and creating the DBMOTOLIB library (or a library name of your choosing). You can also perform this procedure manually for more complete control over operations or in case the automatic process does not work.

Library Name

The library name, DBMOTOLIB, is supplied. This field can be modified to supply a different library name. This is the name of the library that will be created on the Db2 system. It can be useful to change the default library name when, for example, you have two Syniti DR installations using the same database server, and you wish to keep separate libraries for each installation.

Savf File

The location of the savf file in the installation directory. This file is run to create a stored procedure on the Db2 system, and the version of the file should match the operating system that you are using. Modify this path to point to a different file version if needed, or if you move the savf file to a different location. If you are using operating system V5R4 or above, and choose either the DBMLIB54.SAVF file or the DBMLIBAPI61.SAVF file, a checkbox is displayed to allow you to install the procedure JRNSQMAPI. The box should be checked if you are planning to create more than 30 replications from a Db2 for i source database.

Verify (appears only in the Transactional Log Settings dialog)

Click Verify first to see if the library that Syniti Data Replicationwill use (specified in Library Name) is already installed on the server. Depending on the results of this operation, the Install button will become active.  Click Install to create the library on the Db2 system. To later remove the library from the server, use the Disable Transactional Replication wizard available from available from the Transactional Setup > Disable option on the connection in the Metadata Explorer. .

FTP Status

This area reports progress after you have entered all the information above and clicked Install.

Errors during Installation

The FTP status area may report errors when attempting to restore the DBMOTOLIB library. Errors usually involve:

  • A user ID with read-only permissions on the Db2 server or no QSECOFR privileges. This can be addressed by running the process again with a login that has write permissions and QSECOFR privileges.

  • Library or Savefile are already present on the Db2 server, and can not be overwritten or deleted. This can usually be addressed by using a login that has privileges to delete/overwrite existing files.

 In general, if errors occur during the process of automatically restoring the savf file, you can restore the DBMOTOLIB library manually.

Log Server Agent Settings