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
Log in to the Replication Server and execute the admin who, sqm command.
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.
Execute the Replication Server admin who, sql command.
View the results to find open transactions.
For more information about the admin who command, see the Mirror Replication Agent Reference Manual.
