Setting up the datastore for shadow tables with IBM InfoSphere CDC Management Console

Setting up the datastore for shadow tables with the IBM InfoSphere CDC Management Console consists of creating one datastore for the replication with InfoSphere CDC and configuring a datastore connection. This datastore represents the data files that are required for data replication. The datastore connection provides access to the InfoSphere CDC instance from the access server for its configuration, monitoring, and operational control.

Before you begin

Procedure

To set up one datastore for shadow tables:

  1. Log in to the InfoSphere CDC Management Console as access-server-user in the access-server-host.
  2. Create the datastore:
    1. Click Access Manager > User Management.
    2. Click File > Access Server > New Datastore.
    3. Enter access-server-datastore-name in the Name box.
    4. Enter a description in the Description box.
    5. Enter the host name or the full IP address of the cdc-server-host where you installed InfoSphere CDC in the Host Name box.
    6. Enter cdc-port of the server in the Port box.
    7. Ping cdc-server-host. If successful, the datastore properties dialog box is displayed.
    8. Click OK.
  3. Configure a datastore connection:
    1. Click Access Manager > Connection Management.
    2. Select access-server-datastore-name that you created in 2.
    3. Right-click the datastore and select Assign user.
    4. In the Select Users window, select access-server-user and click OK.
    5. In the Connection Parameters section, enter the information for the following fields:
      • For DB login, enter db2-cdc-user.
      • DB Password and Confirm Password, enter the password for db2-cdc-user.
    6. Complete the Connection/Retry Options section as follows:
      • Ensure that the Always show connection dialog box is cleared.
      • Select the Show parameter values box.
      • Ensure that the Write-protect parameters box is cleared.
      • Select the Allow connection parameters saving box.
    7. Click OK.