Enhancements to sysadmin dump_queue include:
an option to specify the server or database name instead of the queue number when identifying the stable queue to dump.
an option to specify the number of commands to dump.
filtering options such as dumping only the begin and end commands of a transaction and dumping everything in the queue as comments except SQL statements.
the option to direct the output to the Replication Server log or to a user-defined log file.
an option to start the data dump from where the previous sysadmin dump_queue command stopped for that particular queue and session.
The modified sysadmin dump_queue syntax is:
sysadmin dump_queue {, q_number | server [,database]},
{q_type,seg, blk, cnt
[, num_cmds]
[, {L0 | L1 | L2 | L3}]
[, {RSSD | client | “log” | file_name}] |
“next” [, num_cmds]}
