Changes to sysadmin sqt_dump_queue

Enhancements to sysadmin sqt_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 dump all committed transactions and read transactions found in the SQT cache.

• 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.

The modified sysadmin sqt_dump_queue syntax is:

sysadmin sqt_dump_queue {, q_number | server [,database]}, 
        q_type, reader 
        [,{open | closed | read}] 
        [, num_cmds]
        [, {L0 | L1 | L2 | L3}]
         [, {RSSD | client | “log” | file_name}]