SMI Tables for Enterprise Replication Reference
The system-monitoring interface (SMI) tables in the sysmaster database provide information about the state of the database server. Enterprise Replication uses the following SMI tables.
- The syscdr_ats Table
The syscdr_ats table contains the first ten lines of the transaction header for each ATS file. - The syscdr_atsdir Table
The syscdr_atsdir table contains information about the contents of the ATS directory. - The syscdr_ddr Table
The syscdr_ddr table contains information about the status of log capture and the proximity or status of transaction blocking (DDRBLOCK) or transaction spooling. - The syscdr_nif Table
The syscdr_nif table contains information about network connections and the flow of data between Enterprise Replication servers. - The syscdr_rcv Table
The syscdr_rcv table contains information about transactions being applied on target servers and acknowledgments being sent from target servers. - The syscdr_ris Table
The syscdr_ris table contains the first ten lines of the transaction header for each RIS file. - The syscdr_risdir Table
The syscdr_risdir table contains information about the contents of the RIS directory. - The syscdr_rqm Table
The syscdr_rqm table contains statistics and contents of the low-level queues (send queue, receive queue, ack send queue, sync send queue, and control send queue) managed by the Reliable Queue Manager (RQM). - The syscdr_rqmhandle Table
The syscdr_rqmhandle table contains information about which transaction is being processed in each queue. The handle marks the position of the thread in the queue. - The syscdr_rqmstamp Table
The syscdr_rqmstamp table contains information about which transaction is being added to each queue. - The syscdr_state Table
The syscdr_state table contains status on Enterprise Replication, data capture, data apply, and the network between the servers. - The syscdrack_buf Table
The syscdrack_buf table contains information about the buffers that form the acknowledgment queue. - The syscdrack_txn Table
The syscdrack_txn table contains information about the acknowledgment queue. - The syscdrctrl_buf Table
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. - The syscdrctrl_txn Table
The syscdrctrl_txn table contains information about the control queue. The control queue is a stable queue that contains control messages for the replication system. - The syscdrerror Table
The syscdrerror table contains information about errors that Enterprise Replication has encountered. - The syscdrlatency Table
The syscdrlatency table contains statistics about Enterprise Replication latency (the time it takes to replicate transactions). - The syscdrpart Table
The syscdrpart table contains participant information. - The syscdrprog Table
The syscdrprog table lists the contents of the Enterprise Replication progress tables. - The syscdrq Table
The syscdrq table contains information about Enterprise Replication queues. - The syscdrqueued Table
The syscdrqueued table contains data-queued information. - The syscdrrecv_buf Table
The syscdrrecv_buf table contains buffers that provide information about the data-receive queue. - The syscdrrecv_stats Table
The syscdrrecv_stats table contains statistics about the receive manager. The receive manager is a set of service routines between the receive queues and data sync. - The syscdrrecv_txn Table
The syscdrrecv_txn table contains information about the data receive queue. The receive queue resides in memory. - The syscdrrepl Table
The syscdrrepl table contains replicate information. - The syscdrreplset Table
The syscdrreplset table contains replicate set information. - The syscdrs Table
The syscdrs table contains information about database servers in an Enterprise Replication domain. - The syscdrsend_buf Table
The syscdrsend_buf table contains buffers that give information about the send queue. - The syscdrsend_txn Table
The syscdrsend_txn table contains information about the send queue. - The syscdrserver Table
The syscdrserver table contains information about database servers declared to Enterprise Replication. - The syscdrsync_buf Table
The syscdrsync_buf table contains buffers that give information about the synchronization queue. Enterprise Replication uses this queue only when defining a replication server and synchronizing its global catalog with another replication server. - The syscdrsync_txn Table
The syscdrsync_txn table contains information about the synchronization queue. This queue is currently used only when defining a replication server and synchronizing its global catalog with another replication server. The synchronization queue is an in-memory-only queue. - The syscdrtsapply table
The syscdrtsapply table lists statistics about the time series elements that are applied on target servers. - The syscdrtx Table
The syscdrtx table contains information about Enterprise Replication transactions. - Enterprise Replication Queues
Parent topic: Appendixes
Related concepts: