sysadmin sqm_purge_queue

Purges all messages from a stable queue.

Caution

Purging messages from a stable queue can result in data loss and should be used only with the advice of SAP 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.

Permissions

Requires “sa” permission.