Connecting InfoSphere Data Replication to a Db2 database

You can connect IBM® InfoSphere Data Replication Version 11.3.3.3-50 or later to a Db2 Warehouse target database. This capability applies to both SMP and MPP environments. It does not apply to the trial version of Db2 Warehouse.

Before you begin

If you are using Db2 Warehouse, you have a choice of two deployment models:
  • Local deployment, where IBM InfoSphere Data Replication and Db2 Warehouse run inside the same Docker container
  • Remote deployment, where IBM InfoSphere Data Replication runs outside the Db2 Warehouse Docker container
The information in this "Before you begin" section applies only to the remote deployment model of Db2 Warehouse.
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

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.