admin sqm_readers

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.

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.