Verifying Sent Messages to RepConnector

Verify that Replication Server has sent a message to RepConnector.

1. Enter:

   admin who,sqm

2. Check the output:

   • First Seg.Block

   • The physical address of the beginning of the queue

   • Last Seg.Block

   • The physical address of the end of the queue

   • Next Read

   • How far the Replication Server has read between the First Seg.Block and Last Seg.Block.

     The Next Read is usually one more than the Last Seg.Block if the Replication Server has read all of the information in that queue. The difference between the First Seg.Block and the Last Seg.Block is the amount of information in the queue in MB. Purging the queue sets the First Seg.Block and the Last Seg.Block to zero.

3. Determine the database ID and the queue type:

   1> admin who,sqm
   2> go

4. Put Replication Server into single-user mode:

   1> sysadmin hibernate_on
   2> go

5. If hibernate does not work, shut down Replication Server and restart it using the -M command (single-user).
6. Purge the queue:

   1> sysadmin sqm_purge_queue,106,0
   2> go
   1> admin who,sqm
   2> go

   In this example, the database ID is 106, and the outbound queue is always 0.

7. Turn hibernate off:

   1> sysadmin hibernate_off
   2> go