Warning! Purging messages from a stable queue can result in
data loss and should be used only with the advice of Sybase Technical
Support. Replication Server cannot send purged messages to the destination
database or Replication Server, and this causes inconsistencies
in the replication system. If a queue contains subscription marker
messages or route messages, using this command can have severe consequences.
Syntax
sysadmin sqm_purge_queue, q_number, q_type
Parameters
q_number, q_type – Identifies the stable queue to be purged. Find
these using admin who, admin who, sqm, or admin
who, sqt.
Examples
Example 1 – Purges all messages from inbound queue number 103:
sysadmin sqm_purge_queue, 103, 1
Usage
sysadmin
sqm_purge_queue removes messages destined
to another Replication Server from a stable queue. Use this command
when your queues are filled with messages.
sysadmin sqm_purge_queue can
only be executed when the Replication Server has been started in
standalone mode.