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.
Table 1 describes the control tables at the Q Capture server.
Table name | Description |
---|---|
IBMQREP_ADMINMSG table | An internal table that contains administrative messages received by a Q Capture program. |
IBMQREP_CAPENQ table | Ensures that only one Q Capture program with a given schema is running per Q Capture server. |
IBMQREP_CAPENVINFO table | Stores environment variables and other information that replication tools use to access remote programs. |
IBMQREP_CAPMON table | Contains statistics about the performance of a Q Capture program. |
IBMQREP_CAPPARMS table | Contains parameters that you can specify to control the operations of a Q Capture program. |
IBMQREP_CAPQMON table | Contains statistics about the performance of a Q Capture program for each send queue. |
IBMQREP_CAPTRACE table | Contains informational, warning, and error messages from a Q Capture program. |
IBMQREP_COLVERSION table | Enables the Q Capture and Capture programs to keep track of different versions of a source table. |
IBMQREP_EOLFLUSH table | An internal table that forces a flush of the log read buffer for Oracle sources. |
IBMQREP_EXCLSCHEMA table | Contains information about tables that are excluded from schema-level subscriptions. |
IBMQREP_IGNTRAN table | Can be used to inform the Q Capture program about transactions that you do not want to be captured from the DB2 recovery log or Oracle redo log. |
IBMQREP_IGNTRANTRC table | Records information about transactions that were specified to be ignored. |
IBMQREP_PART_HIST table (Linux, UNIX, Windows) | Maintains a history of changes to partitioned source tables on Linux, UNIX, and Windows systems. This table is used by Q Replication and SQL replication. |
IBMQREP_SCHEMASUBS table | Contains information about schema-level subscriptions, including the replication queue map that they use, the saved profile if one is used, and the state. |
IBMQREP_SENDQUEUES table | Contains information about the WebSphere MQ queues that a Q Capture program uses to send transaction, row operation, large object, or informational messages. |
IBMQREP_SIGNAL table | Contains signals that are used to prompt a Q Capture program. These signals are inserted by a user or subscribing application, or by a Q Capture program after it receives a control message from the Q Apply program or a subscribing application. |
IBMQREP_SRC_COLS table | Identifies columns in the source table that are replicated or published for a Q subscription or publication. |
IBMQREP_SRCH_COND table | An internal table that a Q Capture program uses to evaluate the search condition that you specified for a Q subscription or publication. |
IBMQREP_SUBS table | Contains information about Q subscriptions and publications, including subscription type, source tables, search conditions, data sending options, target loading options, and states. |
IBMQREP_SUBS_PROF table | Stores the default values for automatically creating table-level Q subscriptions when tables are added to databases with schema-level subscriptions. |
IBMQREP_TABVERSION table | Enables the Q Capture and Capture programs to keep track of different versions of a source table. |