Restarting replication when table operations cause replication to end

If you attempted to perform an operation on a source table by using a data definition language (DDL) statement or the LOAD command that caused InfoSphere CDC replication to end, performing the appropriate actions allow you to quickly restart replication.

Before you begin

  • Ensure that you can log in to the InfoSphere CDC Management Console as access-server-user.
  • Ensure that you have access to the datastore for your shadow tables.

Procedure

To restart replication:

  1. Log in to the InfoSphere CDC Management Console as access-server-user.
  2. For DDL operations that changed the structure of the source table, update table definitions:
    1. Click Configuration > Datastores.
    2. Right-click the data store and select Replication Tables
    3. Select the source table and click Update.
    4. Click Update.
    5. Click Close.
  3. Instruct InfoSphere CDC to refresh the data for the shadow table:
    1. Click Configuration > Table Mappings
    2. Right-click the table mapping, and select Flag for Refresh.
    3. Select Standard Refresh and click OK.
  4. Start replication (mirroring):
    1. Click Configuration > Subscriptions.
    2. Right-click the subscription and select Start Mirroring.
    3. Select Continuous and click OK.