Making DDL changes to existing tables

You can make data description language (DDL) changes to existing tables.

StepsTo make DDL changes to a table marked for replication

  1. Ensure delivery of any in-flight transactions for the table.

  2. Turn replication off for the table.

  3. Make DDL changes to the table.

  4. Use the DB2 COPY utility to make an image copy of the table.

  5. Run the DB2 REORG utility on the table.

  6. Use the DB2 COPY utility to make an image copy of the table.

  7. Reconcile the replication definition and replicate tables.

  8. If the value of the Use_repdef configuration parameter is set to Y, stop and restart Replication Agent.

  9. Turn replication on for the table.