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