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.
Procedure
To replicate data continuously:
- Log in to the access-server-host as cdc-user.
- Start the CHCCLP command-line interface for InfoSphere CDC by
issuing the following command:
$ /access-server-installation-dir/bin/chcclp
- 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;
- 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;
- Indicate the subscription that is the
context for subsequent commands by issuing the select subscription
command as follows:
select subscription name subscription-name;
- Populate data into the shadow tables by issuing the start
mirroring command as follows:
start mirroring method continuous;
- 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.
What to do next
Continue to monitor your subscription to check replication
activity and analyze replication performance. For more information,
see Monitoring InfoSphere CDC subscriptions.
After you started replicating
data, enable query routing to shadow tables. For more information,
see Enablement of query routing to shadow tables.