DB2 10.5 for Linux, UNIX, and Windows

Configuring IBM InfoSphere Change Data Capture software for shadow tables

Configuring InfoSphere® CDC consists of creating and setting up InfoSphere CDC objects that are required to set up replication.

Before you begin

About this task

Replication for shadow tables needs the following InfoSphere CDC objects:

Procedure

To configure InfoSphere CDC software for shadow tables:

  1. Log in to the access-server-host as cdc-user.
  2. Create the access-server-user user with the following properties:
    • The role is SYSADMIN.
    • The user is a manager.
    • The password does not change at first login.
    • The password never expires.
    To create access-server-user, issue the dmcreateuser command as follows:
    cd access-server-installation-dir/bin
    ./dmcreateuser access-server-user
         access-server-user-fullname
         access-server-user-desc
         access-server-user-password
         SYSADMIN TRUE FALSE TRUE
    For more information about the parameters, see access-server-user
  3. Set up the InfoSphere CDC instance for shadow tables. For more information, see Setting up the InfoSphere CDC instance for shadow tables.
  4. Set up a datastore in one of the following ways:

What to do next

After successfully configuring the InfoSphere CDC that you installed, you can start creating shadow tables. For more information, see Creating shadow tables.