Performing table operations on source tables that can interrupt InfoSphere CDC replication

To safely perform a table operation on a source table by using a data definition language (DDL) statement or the LOAD command, perform the appropriate actions to prevent replication interruptions.

To perform an operation on a source table that interrupts replication:

1. Log in to the InfoSphere CDC Management Console as access-server-user.
2. Stop replication:
   1. Click Configuration > Subscriptions.
   2. Right-click the subscription, and select End Replication.
   3. Select Normal and click OK.
3. Perform the operation:
   1. Run the DDL or load operation on the source table.
      In the following example, an ALTER TABLE command is completed on the source table DTW.TRADE.

      $ db2 alter table DTW.TRADE add column i3 integer

   2. For DDL operations, reorganize the source table.
      In the following example, a REORG operation is run on the source table DTW.TRADE.

      $ db2 reorg table DTW.TRADE

4. For DDL operations that change 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.
5. 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.
6. Start replication (mirroring):
   1. Click Configuration > Subscriptions.
   2. Right-click the subscription and select Start Mirroring.
   3. Select Continuous and click OK.