Database Replication Services for DB2 LUW

Objective: Implement Data Replication with DB2 for Linux, UNIX, and Window.

The DB2 Universal Database Data Replication Services engagement is designed to provide your organization with customized assistance and skills transfer with implementing data replication solutions with DB2 for Linux, Unix, and Windows.

This service engagement involves providing assistance with implementing data replication with DB2 for LUW.

Background Information

Data Replication is a process of maintaining a defined set of data in more than one location. It involves copying changes from one database (a source) to another database (a target), and synchronizing the data in both locations. Data Replication is a component of DB2 since v5 which allows you to publish replication sources and define replication subscriptions. These subscriptions are defined and managed using DB2's graphical user interface administration tool known as the DB2 Control Center. The actual subscription information is stored in Replication Control Tables which are automatically created by the DB2 Control Center the first time a replication source or target is defined.

A replication source is a table or view that you want data copied from. Before you can replicate data, you must define a replication source to describe the information that the change-capture mechanisms will use. When you define a replication source you must specify which columns you want to replicate. After the replication source is defined changes to the replication source table are captured via a component of DB2 Data Replication. This component is a process that runs on the database server and is appropriately called the capture component.

A replication target is a table or view that you want data copied to. Before you can replicate data from a replication source, you must define a subscription set that contains the replication target table. The component of DB2 Data Replication that replicates the data from the source table to the target table is called the Apply component. One type of replication subscription is called a Replica. A Replica, sometimes referred to as update anywhere replication, is designed to keep multiple data sources synchronized regardless of which of the two data sources is modified.


Copyright © 1998 - 2016 Ten Digit Consulting, LLC | All rights Reserved.