The onstat -g rqm command prints statistics and contents of the low-level queues (send queue, receive queue, ack send queue, sync send queue, and control send queue) managed by the Reliable Queue Manager (RQM) in Enterprise Replication. The RQM manages the insertion and removal of items to and from the various queues. The RQM also manages spooling of the in-memory portions of the queue to and from disk. The -g rqm option displays the contents of the queue, size of the transactions in the queue, how much of the queue is in memory and on disk, the location of various handles to the queue, and the contents of the various progress tables. You can choose to print information for all queues or for just 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:
onstat -g rqm onstat -g rqm modifier
The following table describes the values for modifier.
| 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 for every queue |
| BRIEF | Prints a brief summary of the number of transactions in
each of the queues and the replication servers for which the data is queued
Use this modifier to quickly identify sites where a problem exists. If large amounts of data are queued for a single server, then that server is 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 all the statistics for that queue and information about the first and last in-memory transactions for that queue.
The other modifiers of the onstat -g rqm command are used primarily as a debugging tool and by Technical Support.
The output for the SENDQ modifier contains the following sections:
The following example shows output for the onstat -g rqm SENDQ 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 (0x0D93A098) End_of_Q,Flags: None
Traverse handle (0x0D08E018) for thread CDRNsA4 at txn (0x0D93A098) End_of_Q,Flags: None
Traverse handle (0x0D523018) for thread CDRNsA5 at txn (0x0D93A098) End_of_Q,Flags: None
Traverse handle (0x0D0D9018) for thread CDRNsA6 at txn (0x0D93A098) End_of_Q,Flags: None
Traverse handle (0x0D4041D8) for thread CDRNsA2 at Head_of_Q,Flags: None
Traverse handle (0x0D3F01D8) for thread CDRNrA2 at Head_of_Q, Flags: None
Traverse handle (0x0D045018) for thread CDRNsA3 at txn (0x0D93A098) End_of_Q,Flags: None
Traverse handle (0x0D31C018) for thread CDRNrA3 at Head_of_Q, Flags: None
Traverse handle (0x0D08E018) for thread CDRNsA4 at txn (0x0D93A098) End_of_Q,Flags: None
Traverse handle (0x0D4C8018) for thread CDRNrA4 at Head_of_Q, Flags: None
Traverse handle (0x0D523018) for thread CDRNsA5 at txn (0x0D93A098) End_of_Q,Flags: None
Traverse handle (0x0D57F018) for thread CDRNrA5 at Head_of_Q, Flags: None
Traverse handle (0x0D0D9018) for thread CDRNsA6 at 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 - 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 – 1/9/12d8f8/0