Control tables for Q Replication and Event Publishing
Control tables are relational database tables that are used to
store information for the Q Replication and Event Publishing programs. These
control tables are stored at the Q Capture server, Q Apply server, and Monitor
control server.
Control tables at the Q Capture server
The control tables at the Q Capture server contain information
about data sources, options for Q subscriptions or publications, operating
parameters for the Q Capture program, Q Capture performance statistics,
and other metadata. These tables are built according to options that
you specify in the replication administration tools.
Control tables at the Q Apply server
The control tables at the Q Apply server contain Q Apply
operating parameters, Q subscription definitions, performance statistics,
and other metadata. These tables are built according to options that
you specify in the replication administration tools.
Detailed structure of version columns for peer-to-peer replication
Tables that participate in peer-to-peer replication require
two version columns, a timestamp column and a small integer column,
which are maintained by triggers. These two columns allow the Q Capture
and Q Apply programs to perform version-based conflict checking that
is required for peer-to-peer replication.