sysadmin sqm_unzap_command

Undeletes a message in a stable queue.

Syntax

sysadmin sqm_unzap_command, q_number, q_type, 
 seg, blk, row

Parameters

q_number, q_type – Identifies the stable queue with the message to be restored. Find these values using admin who, admin who, sqm, and admin who, sqt.
seg – Identifies the segment in the stable queue that contains the message to be undeleted.
blk – Identifies the 16K block in the segment. Block numbering starts at 1 and ends at 64.
row – The row number in the block of the command to be undeleted.

Usage

The Replication Server must be in standalone mode to use sysadmin sqm_unzap_command.
sysadmin sqm_unzap_command removes the delete mark from a message in a stable queue. Use this command to restore a message that you marked deleted using sysadmin sqm_zap_command.
Use sysadmin dump_queue to locate the message you want to restore.

Permissions

sysadmin sqm_unzap_command requires “sa” permission.

Related reference

sysadmin drop_queue

sysadmin sqm_zap_command

sysadmin dump_queue

Created December 12, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com