Show TOC

sysadmin sqm_unzap_commandLocate this document in the navigation structure

Undeletes a message in a stable queue.

sysadmin sqm_unzap_command, <q_number>, <q_type>, 
 <seg>, <blk>, <row>
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.


Identifies the segment in the stable queue that contains the message to be undeleted.


Identifies the 16K block in the segment. Block numbering starts at 1 and ends at 64.


The row number in the block of the command to be undeleted.

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


sysadmin sqm_unzap_command requires “sa” permission.