Verifying Stable Queues

Check the Replication Server stable queues to determine which transactions are being processed or ignored, and to determine whether transactions are open (not committed).

To display information about SQM and SQT threads:

  1. Log in to the primary Replication Server and execute the admin who, sqm command.
  2. View the results to determine the number of duplicate messages being detected and ignored, and the number of blocks being written in the Replication Server stable queues.
  3. In the primary Replication Server, execute the admin who, sql command.
  4. View the results to find open transactions.

See the Replication Server Reference Manual for more information about the admin who command.