Implementing such a configuration for Db2 is a two step process:
- Create a single Straight Replication Engine script that can be reused on each system.
- Create 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 Db2/z Log Reader Capture, by default excludes from capture all updates made by an Apply Engine running under the same plan name used by the capture to connect to the Db2 subsystem including the default Db2 Plan, SQDDB2D. The reason for this is to avoid circular replication.