Dumps the contents of a Replication Server stable queue.
sysadmin dump_queue, q_number, q_type, seg, blk, cnt [, RSSD | client]
Identifies the stable queue to dump. Find these values using admin who or admin who, sqm.
Identifies the starting segment.
Identifies the 16K block in the segment where the dump is to begin. Block numbering starts at 1 and ends at 64.
sysadmin dump_queue recognizes four special settings for seg and blk:
Setting seg to -1 starts with the first active segment in the queue.
Setting seg to -2 starts with the first segment in the queue, including any inactive segments retained by setting a save interval.
Setting seg to -1 and blk to -1 starts with the first undeleted block in the queue.
Setting seg to -1 and blk to -2 starts with the first unread block in the queue.
Specifies the number of blocks to dump. This number can span multiple segments. If cnt is set to -1, the end of the current segment is the last block dumped. If it is set to -2, the end of the queue is the last block dumped.
Optional flag that forces the output to system tables in the RSSD.
Optional flag that forces the output to the client that is issuing this command.
Acting on queue 103:1, dumps blocks 15–64 of segment 0 and blocks 1–15 of segment 1 into the Replication Server log:
sysadmin dump_queue, 103, 1, 0, 15, 65
Dumps all of queue 103:1 into the Replication Server log:
sysadmin dump_queue, 103, 1, -1, 1, -2
Dumps all of queue 103:1 into the RSSD:
sysadmin dump_queue, 103, 1, -1, 1, -2, RSSD
Dumps all of queue 103:1 to the client:
sysadmin dump_queue, 103, 1, -1, 1, -2, client
This series of commands dumps all of queue 103:1 into a file named SYDNEY_RS.log. The last sysadmin dump_file command closes the SYDNEY_RS.log file. Any subsequent dumps are directed to the Replication Server log:
sysadmin dump_file, SYDNEY_RS.log sysadmin dump_queue, 103, 1, -1, 1, -2 sysadmin dump_file
Use sysadmin dump_queue to dump the contents of a Replication Server stable queue.
Output from sysadmin dump_queue may go to one of the following:
Replication Server log
Alternate log file
RSSD
Client issuing the command
To dump queues into the RSSD or client, the last argument of sysadmin dump_queue must be RSSD or client.
If the RSSD or client option is not specified, output goes into the Replication Server log.
If an alternative log file for dumping queues is specified using the sysadmin dump_file command, the output goes into the alternative dump file.
Specify the maximum command length used by this command by setting the queue_dump_buffer_size configuration parameter.
If the RSSD option is used, the dump is written into two system tables in the RSSD, rs_queuemsg and rs_queuemsgtxt.
If the queue is dumped into the RSSD, the system tables are first cleared of the segments with the same q_number, q_type, seg, and blk as the blocks being dumped.
For information about the contents of the rs_queuemsg system table, see Chapter 8, “Replication Server System Tables.”
The rs_queuemsgtxt system table holds the text of commands dumped from the stable queue. If the text of a command exceeds 255 characters, it is stored in multiple rows numbered with the q_seq column.
If the client option is used, the dump is written to the client issuing the command, such as isql or Replication Server Manager.
sysadmin dump_queue requires “sa” permission.
