Download Guide to IBM Informix Enterprise Replication
Transcript
syscdrack_buf SMI Tables for Enterprise Replication The following sections describe the individual tables of the sysmaster database that refer to Enterprise Replication. syscdrack_buf The syscdrack_buf table contains information about the buffers that form the acknowledgment queue. When the target database server applies transactions, it sends an acknowledgment to the source database server. When the source database server receives the acknowledgment, it can then delete those transactions from its send queue. For information on the columns of the syscdrack_buf table, refer to “Columns of the Buffer Tables” on page D-17. syscdrack_txn The syscdrack_txn table contains information about the acknowledgment queue. When the target database server applies transactions, it sends an acknowledgment to the source database server. When the source database server receives the acknowledgment, it can then delete those transactions from its send queue. The acknowledgment queue is an in-memory only queue. That is, it is a volatile queue that is lost if the database server is stopped. For information on the columns of the syscdrack_txn table, refer to “Columns of the Transaction Tables” on page D-16. syscdrctrl_buf The syscdrctrl_buf table contains buffers that provide information about the control queue. The control queue is a stable queue that contains control messages for the replication system. For information on the columns of the syscdrctrl_buf table, refer to “Columns of the Buffer Tables” on page D-17. SMI Table Reference D-3