Replicating Transactions on Db2 Columnar Tables

This whitepaper provides a step-by-step tutorial on how to use Db2 Q Replication technology to replicate transactions that include changes to Columnar Data Engine (CDE) tables in a source Db2 system. It demonstrates how to set up replication in both directions between two Db2 database systems that are configured with the Db2 Database Partitioning Feature (DPF) and how to do a site switch.

 The instructions provided can be easily adapted for any Db2 configuration, including row-organized tables and non-DPF databases.We explain the Q Replication design and expand on the considerations and operations that are specific to replicating database transactions that include changes on Db2 CDE tables.Users of integrated systems such as Db2 Warehouse and IBM Integrated Analytics System (IAS), where the Q Replication function is available via the system console, will also benefit from reading this paper, by understanding what's going on “under-the-hood”.

Executing the steps described in this paper should require about 60 minutes of your time, if you skip the optional tasks. More time will be required to fully read all explanations and considerations for different use-cases.