Replicating data to shadow tables with CHCCLP

To replicate data to shadow tables on a continuous basis, use the CHCCLP command-line interface for IBM InfoSphere Change Data Capture to start mirroring the subscription that you created for shadow tables.

To replicate data continuously:

1. Log in to the access-server-host as cdc-user.
2. Start the CHCCLP command-line interface for InfoSphere CDC by issuing the following command:

   $ /access-server-installation-dir/bin/chcclp 

3. Connect to the access server by issuing the connect server command as follows:

   connect server hostname access-server-host port access-server-port
           username access-server-user password access-server-user-password;

4. Connect to the datastore that you configured in Setting up the datastore for shadow tables with commands for IBM InfoSphere CDC Access Server and indicate as a source and target for subsequent commands by issuing the connect datastore command as follows:

   connect datastore name access-server-datastore-name; 

5. Indicate the subscription that is the context for subsequent commands by issuing the select subscription command as follows:

   select subscription name subscription-name;

6. Populate data into the shadow tables by issuing the start mirroring command as follows:

   start mirroring method continuous;

7. Verify the replication state of the subscription by issuing the monitor replication command as follows:

   monitor replication filter
      subscription name subscription-name;
   

   The subscription-name must match the name that you set as context in step 5. After the initial refresh of all the table mappings is completed successfully, the subscription is in mirroring state.