Implementing such a configuration for UDB 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 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.