admin sqm_readers

Description

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.

Table 3-6 describes the output columns for the admin sqm_readers command.

**Table 3-6: 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 Table 3-7.
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.