Display Replication System Thread Status

Display general information on the different types of current Replication Server threads with the relevant admin who command or a system procedure.

Monitoring Replication Server Threads

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

Note: Use sp_who or sp_help_rep_agent to display status of RepAgent thread at Adaptive Server.

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

See:
  • Replication Server Troubleshooting Guide to interpret the command output for troubleshooting purposes.
  • Replication Server Reference Manual > Replication Server Commands > admin who
  • Replication Server Reference Manual > Adaptive Server Commands and System Procedures > sp_help_rep_agent
  • Adaptive Server Enterprise > Reference Manual: Procedures > System Procedures > sp_who