You can monitor general information on current Replication Server threads. Table 1-1 describes threads that apply to database connections and routes and the admin who command you use to monitor them.
Replication Server thread |
Command |
|---|---|
Distributor (DIST) – uses SQT and SQM to read transactions from the inbound queue. |
admin who, dist |
Data Server Interface (DSI) – submits transactions to data server. |
admin who, dsi |
REP AGENT USER – verifies that transactions from the data server are valid and writes them to the inbound queue. |
admin who
|
Replication Server Interface (RSI) – logs in to each destination Replication Server and transfers commands from the stable queue to the destination server. |
admin who, rsi |
Stable Queue Manager (SQM) – manages Replication Server stable queues. |
admin who, sqm |
Stable Queue Transaction interface (SQT) – reads transactions in a queue and passes them to the SQT reader. |
admin who, sqt |
Refer to Chapter 3, “Replication Server Commands,” in the Replication Server Reference Manual for details on the admin who command. Refer to the Replication Server Troubleshooting Guide to interpret the command output for troubleshooting purposes.
Use sp_who or sp_help_rep_agent to
display status of RepAgent thread at Adaptive Server.