onstat -g rqm

Home | Previous Page | Next Page Appendix C. onstat Command Reference > onstat -g Command Summary > 4 4 4

onstat -g rqm

The onstat -g rqm command prints statistics and contents of the low-level queues (send 4queue, receive queue, ack send queue, sync send queue, and control send queue) 4managed by the Reliable Queue Manager (RQM). The RQM manages the insertion 4and removal of items to and from the various queues. The RQM also manages 4spooling of the in-memory portions of the queue to and from disk. The -g rqm option displays the contents of the queue, size of 4the transactions in the queue, how much of the queue is in memory and on disk, 4the location of various handles to the queue, and the contents of the various 4progress tables. You can choose to print information for all queues or for 4just one queue by using one of the modifiers described below.

If a queue is empty, no information is printed for that queue.

The onstat -g rqm command has the following formats: 4

onstat -g rqm
4onstat -g rqm modifier

The following table describes the values for modifier.

4 4444444444444444444444444444444444444444

Modifier	Action
ACKQ	Prints the ack send queue
CNTRLQ	Prints the control send queue
RECVQ	Prints the receive queue
SENDQ	Prints the send queue
SYNCQ	Prints the sync send queue
FULL	Prints full information about every in-memory transaction 4for every queue
BRIEF	Prints a brief summary of the number of transactions in 4each of the queues and the replication servers for which the data is queued 4 4Use this modifier to quickly identify sites where a problem exists. 4If large amounts of data are queued for a single server, then that server 4is probably down or off the network.
VERBOSE	Prints all the buffer headers in memory

When you specify a modifier to select a specific queue, the command prints 4all the statistics for that queue and information about the first and last 4in-memory transactions for that queue.

The other 4modifiers of the onstat -g rqm command are used primarily 4as a debugging tool and by Technical Support.

The output for the SENDQ modifier contains the following sections:

RQM Statistics for Queue—a summary of current and historical information 4for the queue. This includes the number of transactions in the queue, how 4many are spooled, how many bytes they are using, some maximum statistics, 4and the high water marks that will trigger stably storing transactions in 4the syscdr tables.

First Txn—information about the first transaction in the queue. 4To check if the queue is draining, you can run onstat -g 4rqm several times and see if the first transaction's RQM key is changing. 4The RQM key has the following format: Server_ID/Commit_unique_logID/Commit_log_position/Sequence. If it is not draining, the target 4server may be offline or some other problem is occurring. The NeedAck field 4shows from which server the transaction is waiting for an acknowledgement. 4You can use this bitmap mask with the output from the onstat 4-g cat command to determine the name of the server which server Enterprise 4Replication is waiting on for an acknowledgement.

Last Txn—information about the last transaction in the queue

Traverse handle—lists the handles used for threads

Progress table—provides information about the progress of each replicate 4under the headers: Server, Group, Bytes Queued, Acked, and Sent. The Group 4field shows the replicate ID. The Acked field shows what has been acknowledged. 4The Sent field shows which entries are now in transit. Both the Acked and 4the Sent field show the RQM key, which has the following format: Server_ID/Commit_unique_logID/Commit_log_position/Sequence.

The following example shows output for the onstat -g rqm 4SENDQ command.

RQM Statistics for Queue (0x0D3DF018) trg_send

 Transaction Spool Name: trg_send_stxn

 Insert Stamp: 35/0

 Flags: SEND_Q, SPOOLED, PROGRESS_TABLE, NEED_ACK

 Txns in queue:             35

 Log Events in queue:       0

 Txns in memory:            35

 Txns in spool only:        0

 Txns spooled:              0

 Unspooled bytes:           176206

 Size of Data in queue:     176206 Bytes

 Real memory in use:        176206 Bytes

 Pending Txn Buffers:       0

 Pending Txn Data:          0 Bytes

 Max Real memory data used: 176206 (2457600) Bytes

 Max Real memory hdrs used  65988 (2457600) Bytes

 Total data queued:         176206 Bytes

 Total Txns queued:         35

 Total Txns spooled:        0

 Total Txns restored:       0

 Total Txns recovered:      0

 Spool Rows read:           0

 Total Txns deleted:        0

 Total Txns duplicated:     0

 Total Txn Lookups:         363

First Txn (0x0D60C018) Key:  1/9/0x000d4bb0/0x00000000

 Txn Stamp: 1/0, Reference Count: 0.

 Txn Flags: Notify

 Txn Commit Time: (1094670993) 2004/09/08 14:16:33

 Txn Size in Queue: 5908

 First Buf's (0x0D31C9E8) Queue Flags: Resident

 First Buf's Buffer Flags: TRG, Stream

 NeedAck: Waiting for Acks from <[0004]>

 No open handles on txn.

 Last Txn (0x0D93A098) Key:  1/9/0x00138ad8/0x00000000

 Txn Stamp: 35/0, Reference Count: 0.

 Txn Flags: Notify

 Txn Commit Time: (1094671237) 2004/09/08 14:20:37

 Txn Size in Queue: 6298

 First Buf's (0x0D92FFA0) Queue Flags: Resident

 First Buf's Buffer Flags: TRG, Stream

 NeedAck: Waiting for Acks from <[0004]>

 Traverse handle (0x0D045018) for thread CDRNsA3 at txn 
4    (0x0D93A098) End_of_Q,Flags: None

 Traverse handle (0x0D08E018) for thread CDRNsA4 at txn
4    (0x0D93A098) End_of_Q,Flags: None

 Traverse handle (0x0D523018) for thread CDRNsA5 at txn
4    (0x0D93A098) End_of_Q,Flags: None

 Traverse handle (0x0D0D9018) for thread CDRNsA6 at txn
4    (0x0D93A098) End_of_Q,Flags: None

 Traverse handle (0x0D4041D8) for thread CDRNsA2 at Head_of_Q,
4    Flags: None

 Traverse handle (0x0D3F01D8) for thread CDRNrA2 at
4    Head_of_Q,  Flags: None

 Traverse handle (0x0D045018) for thread CDRNsA3 at
4    txn (0x0D93A098) End_of_Q,Flags: None

 Traverse handle (0x0D31C018) for thread CDRNrA3 at
4    Head_of_Q,  Flags: None

 Traverse handle (0x0D08E018) for thread CDRNsA4 at
4    txn (0x0D93A098) End_of_Q,Flags: None

 Traverse handle (0x0D4C8018) for thread CDRNrA4 at
4    Head_of_Q,  Flags: None

 Traverse handle (0x0D523018) for thread CDRNsA5 at
4    txn (0x0D93A098) End_of_Q,Flags: None

 Traverse handle (0x0D57F018) for thread CDRNrA5 at
4    Head_of_Q,  Flags: None

 Traverse handle (0x0D0D9018) for thread CDRNsA6 at
4    txn (0x0D93A098) End_of_Q,Flags: None

Server    Group Bytes Queued      Acked    Sent

----------------------------------------------------------

    6  0x10009           0 1/9/138ad8/0   -    1/9/138ad8/0

    5  0x10009           0 1/9/138ad8/0   -    1/9/138ad8/0

    4  0x10009           0 1/9/138ad8/0   -    1/9/138ad8/0

    3  0x10009           0 1/9/138ad8/0   -    1/9/138ad8/0

    2  0x10009        4154 efffffff/efffffff/efffffff/efffffff 
4- 1//138ad8/0

    6  0x10006           0 1/9/12d8f8/0   -    1//12d8f8/0

    5  0x10006           0 1/9/12d8f8/0   -    1//12d8f8/0

    4  0x10006           0 1/9/12d8f8/0   -    1/9/12d8f8/0

    3  0x10006           0 1/9/12d8f8/0   -    1/9/12d8f8/0

    2  0x10006        31625 efffffff/efffffff/efffffff/efffffff 
4– 1/9/12d8f8/0