Multiple Syniti Replicate instances with IBM Db2 for i

  • Published on Dec 2, 2025
  • 2 minute(s) read
  • AF
  • Alejandro Millalen
 Prev Next

Note

The information below applies only if you plan to perform Mirroring or Synchronization replications with IBM Db2 for i as a source database.

Overview

If your environment includes multiple Syniti Replicate installations running replications against the same IBM i (iSeries/AS/400) source system for mirroring or synchronization, you must configure a separate temporary library for each installation. Using distinct temporary libraries prevents conflicts that can occur when multiple installations attempt to use the same one during replication.

When you configure a mirroring or synchronization connection to IBM Db2 for i, Syniti Replicate creates a library on the IBM i system. By default, this library is named DBMOTOLIB. It contains the program required by Syniti Replicate and serves as the temporary workspace for its operations.

If another Syniti Replicate installation connects to the same IBM i system without modifying this value, it will also default to using DBMOTOLIB, which can lead to conflicts as both installations create and delete temporary files.

To avoid this conflict, configure a unique temporary library for the second and any additional Syniti Replicate installations:

During Connection Setup

If you have not yet created a connection for the IBM i system, you can modify the temporary library in the Source Connection wizard.

  1. In the Metadata Explorer, expand the metadata node to view the Sources and Targets nodes.

  2. Right-click the Sources node and select Add New Connection.

  3. In the Source Connection wizard, complete the following steps to add a connection string and test the connection to the database:

    1. In the Setup Info screen, select the Use Transactional Replication checkbox.

    2. In the Temporary Library Name field, the default value DBMOTOLIB is provided. Modify this value to specify a different library name. This value is the name of the library that will be created on the Db2 system. The setup process will install a program to be used by Syniti Replicate and provide a library to contain temporary Syniti Replicate files.

    3. Click Verify to check whether the library specified in Library Name is already installed on the server. (Syniti Replicate performs this verification automatically when using the Enable Transactional Replication wizard.)

      Based on the verification results, either the Install or Remove button will become active.

      • If the library does not exist, click Install to create it on the Db2 system.

      • If the library already exists and is being used by another Syniti Replicate installation, enter a different name in the Library Name field before proceeding.

  4. Complete the Enable Transactional Replication wizard/Source Connection wizard.

After Connection Setup

If you have already created a connection to the IBM i system, you can modify the temporary library in the Connection Properties.

  1. In the Metadata Explorer, expand the tree to show a source, target or Metadata connection.

  2. Right-click the connection and select Connection Properties.

  3. In the Connection Properties dialog, access the Transactional Support section.

  4. Update the Temporary Library Name field to specify a library that is not used by any other Syniti Replicate installation. This setup process will install a program to be used by Syniti Replicate and provide a library to contain temporary Syniti Replicate files.

  5. Click Verify to ensure that the specified library is not already in use.

  6. Click Install to set up the library on the IBM i system.

Both processes will create a library on the IBM i system to contain the program used by Syniti Replicate and any temporary files that Syniti Replicate needs.