Below command can be used to dump the contents of a Replication Server stable queue.

Syntax

sysadmin dump_queue, q_number, q_type,
 seg, blk, cnt [, RSSD | client]

Example:

1> sysadmin dump_queue,108,1, -1, 1, -2,"/tmp/dumpqueue.log"
2> go

where,

108 : Queue number – we can get this value from admin who,sqm output (check for info column of required connection)

1 : inbound queue ( use 0 for outbound queue )

-1: Active portion of queue (-2 is for both active/inactive portion of queue)

1: start with block 1 of the stable queue

-2: uptill end of the queue

/tmp/dumpqueue.log: queue dump location