Replicating column-organized tables in Db2 Warehouse

Replication supports both column-organized tables and row-organized tables.

Changes to column-organized tables are logged by Db2 Warehouse into a separate file system when replication is enabled (DATA CAPTURE CHANGES attribute is set on a table). Transactions with changes to column-organized tables are applied at the target by using an external table LOAD operation, with transaction streaming and parallelism across all partitions of the target system.
Note: Changes to row-organized tables are replicated by replaying the insert/update/delete operation.

Replication for column-organized tables takes place independently of the Db2 Warehouse recovery log, and these additional logs are not archived and are not used for recovery. Additional disk space is required for keeping these logs.

You can view a step-by-step tutorial on how to replicate transactions that include changes to column-organized tables in a source Db2 Warehouse system. To learn how to set up replication in both directions between two systems that are configured with the Db2 Warehouse Database Partitioning Feature (DPF) and how to do a site switch, see Replicating Transactions on Db2® Columnar Tables with Db2 V11.5 .