Show TOC

sysadmin sqm_unzap_commandLocate this document in the navigation structure

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.