Use the sysadmin purge_all_open command to purge all open transactions from a Replication Server inbound queue. Use sysadmin purge_first_open to purge only the first open transaction from a Replication Server inbound queue.
Replication Server needs sufficient storage to execute the sysadmin purge commands. If you do not have enough storage, the following error message may appear:
This RS is out of Disk Space. Use another session to add disk space for this command to proceed.
If this occurs, start another isql session and add stable storage to the Replication Server. sysadmin purge commands cannot proceed until sufficient storage is available.
If you want to review the contents of the transactions being dropped, then execute the sysadmin sqt_dump_queue command prior to using the sysadmin purge_all_open or sysadmin purge_first_open command.
The syntax for the sysadmin purge_all_open command is:
sysadmin purge_all_open, q_number, q_type
where q_number, q_type identifies the stable queue to purge. These values can be found by using the admin who command, the admin who, sqm command, and the admin who, sqt command. Only inbound queues can be purged.
The syntax for the sysadmin purge_first_open command is:
sysadmin purge_first_open, q_number, q_type
where q_number, q_type identifies the stable queue to purge. These values can be found by using the admin who command, the admin who, sqm command, and the admin who, sqt command. Only inbound queues can be purged.
The next set of examples describes the use of sysadmin purge_first_open and sysadmin purge_all_open.
The following command purges the first open transaction from the specified queue:
sysadmin purge_first_open, 103, 1
This command purges all open transactions from the specified queue:
sysadmin purge_all_open, 103, 1
