Where do the control tables go
This section looks at where the Q replication control tables go for different source and target database types.
DB2 to DB2 replication
For DB2 to DB2 replication, the Q Capture control tables go on the server where Q Capture runs, and the Q Apply control tables go on the server where Q Apply runs. The placement of the Replication Alert Monitor tables is discussed in the Monitoring using the Replication Alert Monitor section of Chapter 7, Monitoring and Reporting.
DB2 to non-DB2 replication
In the scenario, where we are replicating from a DB2 source to a non-DB2 target (such as Oracle), the control tables are distributed as shown in the following figure:
Non-DB2 to DB2 replication
In the scenario, where we are replicating from a non-DB2 source (such as Oracle) to a DB2 target, the control tables are distributed as shown in the following figure: