Data replication in the DB2 database (1)

This article will give you a detailed analysis of the data replication technology in the DB2 database for your reference. It should be noted that this article will mainly discuss data replication between DB2, without considering data replication that contains non-IBM databases.

-What is Data Replication?

Data replication is to copy the specified data in the source database to the target database to ensure the synchronization of the specified data in the source database and the target database is consistent ).

Basic Concepts

CD table: change data tables: used to temporarily store tables for changing data. It generally contains the columns to capture changes and some control columns.

For example, the user-specified column to capture changes

Create table department (DEPTNO ..., <-- DEPTNAME ..., <-- MGRNO ..., ADMRDEPT ..., LOCATION ...)
 
Source table

Create table CD20030805296530 (IBMSNAP_UOWID ..., IBMSNAP_INTENTSEQ ..., IBMSNAP_OPERATION ..., DEPTNO ..., <-- DEPTNAME ...) <--
 
CD table

DB2 Log Type:

Archive cyclic logs:

DB2 Data Replication Components

DB2 DataPropagator consists of three parts: Management Interface, change capture mechanism, and Application

Note: The application Apply program here is different from what we usually call an application. Unless otherwise stated in this article, "application" refers to the DB2 Data Replication component.