Source table commands

Use these commands to manage your source tables in a subscription.

ADDTBL - Add Tables
Use this command to add source tables to the catalog for possible replication.
CHGREPMTD - Change replication method
Use this command to change the replication method of a source table in a subscription.
DSLTGTTBL - Deselect source tables
Use this command to deselect a source table from a subscription.
READDTBL - Update definition of source tables
Use this command when you have changed the definition of a source table after the table has been added to the CDC Replication metadata tables.
RMVTBL - Remove tables
Use this command to remove source tables that were added to a catalog for possible replication.
STRDTAMIR - Describe source tables to target tables
Use this command when you have updated the definition of your source table.
SETMIRSTS - Set table status for mirroring
Use this command to change the status of a table that you have selected for mirroring.
SETRSHSTS - Set table status for refresh
Use this command to change the status of a selected table or group of tables that you want to refresh.
SLTTGTTBL - Select source tables for replication
Use this command to select a source table for replication to a subscription.
SETTSSYNC - Set synchronization point
Use this command to synchronize mirroring to start at the earliest backup point for all tables selected to the named subscription.
SETJRNPOS - Set journal position
Use this command to position CDC Replication to start mirroring at a specific journal entry.

Parent topic: Commands for the CDC Replication Engine for Db2 for i