Show TOC

admin sqm_readersLocate this document in the navigation structure

Displays the read and delete points of the threads that are reading a stable queue.

Syntax
admin sqm_readers, <q_number>, <q_type>
Parameters
q_number

The ID number that Replication Server assigns to the queue. The number can be found in the output of the admin who, sqm command.

q_type

The type of the queue. Inbound queues have a type of 1. Outbound queues have a type of 0.

Examples
Example 1
admin sqm_readers, 103, 1
RdrSpid     RdrType     Reader                        Index 
-------     -------     ------                        ----- 
46          SQT         103:1 DIST LDS.pubs               0
57          SQT         103:1 DSI 107 SYDNEY_DS.pubs2     1

First Seg.Block  Next Read  Last Seg.Block  Delete  WriteWait
---------------  ---------  --------------  ------  ---------
14.43            14.44      14.43                1          1
14.43            14.44      14.43                1          0
Usage
  • admin sqm_readers reports the read point and the delete point for each Replication Server thread that is reading an inbound queue. You can use this information to help identify the cause when Replication Server fails to delete messages from queues.

  • Replication Server cannot delete points beyond the minimum delete point of all threads that are reading the queue. The deletion point is the first segment block.

  • Use the admin who, sqm command to find the <q_number>.

  • Column descriptions for admin sqm_readers output table describes the output columns for the admin sqm_readers command.

Table 1: Column Descriptions for admin sqm_readers Output

Column

Description

<RdrSpid>

Unique identifier for this reader.

<RdrType>

The type of thread that is reading the queue.

<Reader>

Information about the reader. For a complete description of this information, see Name and Info column for admin who output table.

<Index>

The index for this reader.

<First Seg.Block>

The first undeleted segment and block number in the queue. This information is useful when dumping queues.

<Next Read>

The next segment, block, and row to be read from the queue.

<Last Seg.Block>

The last segment and block written to the queue. This information is useful when dumping queues.

<Delete>

Whether or not the reader is allowed a delete. A value of “1” indicates that the reader is allowed a delete.

<WriteWait>

Whether or not the reader is waiting for a write. A value of “1” indicates that the reader is waiting for a write.

Permissions

Any user may execute this command.