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 syscdr_ats table contains the first ten lines of the transaction header for each ATS file.The syscdr_atsdir Table syscdr_atsdir table contains information about the contents of the ATS directory. The syscdr_ddr Table 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 syscdr_nif table contains information about network connections and the flow of data between Enterprise Replication servers.The syscdr_rcv Table syscdr_rcv table contains information about transactions being applied on target servers and acknowledgments being sent from target servers. The syscdr_ris Table syscdr_ris table contains the first ten lines of the transaction header for each RIS file.The syscdr_risdir Table syscdr_risdir table contains information about the contents of the RIS directory.The syscdr_rqm Table 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 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 syscdr_rqmstamp table contains information about which transaction is being added to each queue.The syscdr_state Table syscdr_state table contains status on Enterprise Replication, data capture, data apply, and the network between the servers.The syscdrack_buf Table syscdrack_buf table contains information about the buffers that form the acknowledgment queue. The syscdrack_txn Table syscdrack_txn table contains information about the acknowledgment queue. The syscdrctrl_buf Table 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 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 syscdrerror table contains information about errors that Enterprise Replication has encountered. The syscdrlatency Table syscdrlatency table contains statistics about Enterprise Replication latency (the time it takes to replicate transactions).The syscdrpart Table syscdrpart table contains participant information.The syscdrprog Table syscdrprog table lists the contents of the Enterprise Replication progress tables.The syscdrq Table syscdrq table contains information about Enterprise Replication queues. The syscdrqueued Table syscdrqueued table contains data-queued information.The syscdrrecv_buf Table syscdrrecv_buf table contains buffers that provide information about the data-receive queue. The syscdrrecv_stats Table 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 syscdrrecv_txn table contains information about the data receive queue. The receive queue resides in memory.The syscdrrepl Table syscdrrepl table contains replicate information.The syscdrreplset Table syscdrreplset table contains replicate set information.The syscdrs Table syscdrs table contains information about database servers in an Enterprise Replication domain. The syscdrsend_buf Table syscdrsend_buf table contains buffers that give information about the send queue. The syscdrsend_txn Table syscdrsend_txn table contains information about the send queue. The syscdrserver Table syscdrserver table contains information about database servers declared to Enterprise Replication .The syscdrsync_buf Table 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 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 syscdrtsapply table lists statistics about the time series elements that are applied on target servers.The syscdrtx Table syscdrtx table contains information about Enterprise Replication transactions. Enterprise Replication Queues Have feedback? Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.