Please enable JavaScript to view this site.

Navigation: Change Data Capture > Db2/LUW (UDB) > Operating Scenarios

UDB Active/Active Replication

Scroll

An overview of Active/Active Replication is provided in the Change Data Capture Guide. Implementing such a configuration for UDB is a two step process:

1.Create a single straight Replication Engine script that can be reused on each system.

2.Creation of Capture and Apply configurations on each of the systems.

add --active | --inactive --key=<TABLE_NAME>

--datastore=cdc:////<engine_agent_alias>

<cab_file_name>

 

Note: The UDB Log Reader Capture, by default excludes from capture all updates made by an SQData  Apply Engine running under the same plan name used by the capture to connect to the Db2 subsystem including SQData's default Db2 Plan, SQDDDB2D. The reason for this is to avoid circular replication.