Connecting InfoSphere Data Replication to a Db2 database

You can connect IBM® InfoSphere Data Replication Version 11.3.3.3-36 or later to a Db2 managed service target database. This capability applies to both SMP and MPP environments.

Before you begin

Before you can connect to your database, you must carry out the following steps:

  • Verify prerequisites, including installing driver packages, configuring your local environment, and downloading SSL certificates (if needed)

  • Collect connect information, including database details such as host name and port numbers, and connect credentials such as user ID and password

About this task

Ideally, when you connect IBM InfoSphere Data Replication to the Db2 managed service, IBM InfoSphere Data Replication is in the same IBM Cloud® Data Center as Db2 managed service or is colocated with Db2 managed service. IBM InfoSphere Data Replication connects from a local server to the remote Db2 managed service instance.

When you use Db2 managed service as a target, the performance of IBM InfoSphere Data Replication partly depends on the bandwidth of the network that separates its target engine from the Db2 managed service instance. Physical distance also affects performance: ideally, IBM InfoSphere Data Replication is as close as possible to the Db2 managed service instance. Network topology also affects performance. For example, ideally, the IBM InfoSphere Data Replication target engine runs on a VM in the same VPN (security domain) as the target instance. The fewer the network nodes (for example, firewalls or routers) to traverse, the better.

Procedure

  1. Launch the InfoSphere Data Replication configuration tool and perform the following steps. The values that are shown in the screen captures are examples.
    1. Add a source instance to point to your source database by using the Instance Configuration tab:
    2. Add a target instance to point to your target Db2 database by using the Instance Configuration tab. If you are not using IBM InfoSphere Data Replication 11.3.3.3-50 or later, do not select the Specify refresh loader path check box.

    3. Start each instance:
  2. Launch the InfoSphere Data Replication management console and use Access Manager to complete the following steps:
    1. Create a datastore to connect to your source instance by using the Datastore tab. Because a Db2 database is not supported as a source database, you must provide user and password information for the source database by clicking Connection Parameters.
    2. Create a datastore to connect to your target instance by using the Datastore tab. You must provide user and password information by clicking Connection Parameters.
    3. If the user (for example, admin) that will connect to the Access Server does not exist, create that user:
    4. Click the Access Manager tab.
    5. On the Datastore Management tab, assign the user to both the source and target datastores by right-clicking each datastore and then clicking Assign User. Ensure that the credentials for accessing each instance are correct.

What to do next

Define a subscription and perform data replication. For information, see Loading data from InfoSphere Data Replication.