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.

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:
   • Setting up the datastore for shadow tables with IBM InfoSphere CDC Management Console
   • Setting up the datastore for shadow tables with commands for IBM InfoSphere CDC Access Server