Checking System Tables

Check the Replication Server System Database (RSSD) tables for error information.

  1. Identify any recoverable actions in the rs_recovery system table and perform the actions specified.
  2. Look for any detecting losses or rejecting messages after loss detected validation status messages in the rs_oqid system table. (You might have missed the message in the error log.)

    A detecting loss message signifies that data replication messages were lost after queues were rebuilt.

    See the Loss Status column in the output from admin health and admin who, sqm to check if there is the possibility of data loss in the queues.

Related reference
Detecting Loss for Database