Replicating data in partitioned tables

CDC Replication supports Db2® tables that are partitioned by range. These tables are sometimes known as range-partitioned tables.

If only target tables (no source tables) are partitioned by range, then CDC Replication has no specific requirements that apply to these tables.

The system parameter range_partitioned_table_support must be set to true before you start replication for the table. If this parameter is not set, CDC Replication does not replicate changes from any partition.

Note: Data in attached and detached partitions cannot be replicated. So if an attached or detached partition contains data (is not empty), you must refresh the entire table, or just the partition data by using range refresh.