The onstat -g rqm command displays the statistics for Reliable Queue Manager [RQM] queues.
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 onstat -g rqm
command 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 can take an optional modifier. The following table describes the values for the modifier.
Modifier | Action |
---|---|
ACKQ | Prints the ack send queue |
CNTRLQ | Prints the control send queue |
RECVQ | Prints the receive queue |
SBSPACES | Prints detailed statistical information about the sbspaces configured for CDR_QDATA_SBSPACE. |
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. When you select the SBSPACES modifier, the command prints information about the sbspaces being used for replication, including how full those sbspaces are.
The other modifiers of the onstat -g rqm command are used primarily as a debugging tool
The output for the SENDQ modifier contains the following sections:
onstat -g rqm sendq CDR Reliable Queue Manager (RQM) Statistics: RQM Statistics for Queue (0x3d914a028) trg_send Transaction Spool Name: trg_send_stxn Insert Stamp: 22293692 Flags: SEND_Q, SPOOLED, PROGRESS_TABLE, NEED_ACK Txns in queue: 0 Log Events in queue: 0 Txns in memory: 0 Txns in spool only: 0 Txns spooled: 0 Unspooled bytes: 0 Size of Data in queue: 0 Bytes Real memory in use: 0 Bytes Pending Txn Buffers: 0 Pending Txn Data: 0 Bytes Max Real memory data used: 4194248 (4194304) Bytes Max Real memory hdrs used 3005856 (3081680832) Bytes Total data queued: 14658380490 Bytes Total Txns queued: 22293692 Total Txns spooled: 2656 Total Txns restored: 682 Total Txns recovered: 0 Spool Rows read: 682 Total Txns deleted: 22293692 Total Txns duplicated: 0 Total Txn Lookups: 66810608 Progress Table: Progress Table is Stable On-disk table name............: spttrg_send Flush interval (time).........: 30 Time of last flush............: 1370363073 Flush interval (serial number): 1000 Serial number of last flush...: 109915 Current serial number.........: 109917 Server Group Bytes Queued Acked Sent ------------------------------------------------------------------------------ 1 0x2003b 0 2/3668/0x898a16c/0x0 - 2/3668/0x898a16c/0x0 1 0x20019 0 2/3610/0xccf0458/0x0 - 2/3610/0xccf0458/0x0 1 0x200cd 0 2/1394/0x136cb2f0/0x0 - No Content Yet 1 0x20035 0 2/2964/0x25e32220/0x0 - No Content Yet 1 0x2008e 0 2/887/0xedd11b8/0x0 - No Content Yet 1 0x2008d 0 2/990/0x1c5683a4/0x0 - No Content Yet 1 0x20091 0 2/1384/0x1ecab428/0x0 - No Content Yet 1 0x20092 0 2/1384/0x1ec6d7b0/0x0 - No Content Yet 1 0x20011 0 2/439/0xa10f3f4/0x0 - No Content Yet 1 0x20053 0 2/3503/0x5f55638/0x0 - 2/3503/0x5f55638/0x0 1 0x20052 0 2/1929/0x137a2d8/0x0 - No Content Yet 1 0x2005b 0 2/3665/0x300071b0/0x0 - 2/3665/0x300071b0/0x0 1 0x2000c 0 2/633/0x2e8b001c/0x0 - No Content Yet 1 0x2003c 0 2/3674/0x125065c8/0x0 - 2/3674/0x125065c8/0x0 1 0x2000f 0 2/647/0x1d691318/0x0 - No Content Yet 1 0x20013 0 2/647/0x1d832434/0x0 - No Content Yet 1 0x20016 0 2/647/0x1d76d708/0x0 - No Content Yet 1 0x20055 0 2/3674/0x1365e690/0x0 - 2/3674/0x1365e690/0x0 1 0x20054 0 2/3674/0x12e0b254/0x0 - 2/3674/0x12e0b254/0x0 1 0x2006c 0 2/3674/0x12e3a31c/0x0 - 2/3674/0x12e3a31c/0x0 1 0x2000a 0 2/347/0xbb67340/0x0 - No Content Yet 1 0x20057 0 2/3674/0x14d4d7c8/0x0 - 2/3674/0x14d4d7c8/0x0 1 0x20065 0 2/3674/0x14d6137c/0x0 - 2/3674/0x14d6137c/0x0 1 0x20038 0 2/3668/0x2f7bf1b0/0x0 - 2/3668/0x2f7bf1b0/0x0 1 0x2001b 0 2/3674/0x11cb4364/0x0 - 2/3674/0x11cb4364/0x0 1 0x20001 0 2/3674/0x12f0618c/0x0 - 2/3674/0x12f0618c/0x0 Traverse handle (0x3d9788028) for thread CDRNsT1 at Head_of_Q, Flags: None ....... Traverse handle (0x3d97c8028) for thread CDRNr1 at Head_of_Q, Flags: None onstat -g rqm recv CDR Reliable Queue Manager (RQM) Statistics: RQM Statistics for Queue (0x3d919f028) trg_receive Transaction Spool Name: trg_receive_stxn Insert Stamp: 367458171 Communal Stamp: 0 Flags: RECV_Q, SPOOLED, PROGRESS_TABLE Txns in queue: 6 Txns in memory: 6 Txns in spool only: 0 Txns spooled: 0 Unspooled bytes: 0 Size of Data in queue: 782281 Bytes Real memory in use: 782281 Bytes Pending Txn Buffers: 0 Pending Txn Data: 0 Bytes Max Real memory data used: 5999987 (4194304) Bytes Max Real memory hdrs used 6503584 (3081680832) Bytes Total data queued: 23884344839 Bytes Total Txns queued: 37092106 Total Txns spooled: 0 Total Txns restored: 0 Total Txns recovered: 0 Spool Rows read: 0 Total Txns deleted: 37092100 Total Txns duplicated: 0 Total Txn Lookups: 74184207 Progress Table: Progress Table is Stable On-disk table name............: spttrg_receive Not keeping dirty list. Server Group Bytes Queued Acked Sent ------------------------------------------------------------------------------ 1 0x2001b 0 1/268769/0xe2593cc/0x0 - No Content Yet 1 0x20054 0 1/268196/0xd1bf2b8/0x0 - No Content Yet 1 0x2006c 0 1/268196/0xe02d174/0x0 - No Content Yet 1 0x20055 0 1/268196/0xdb02258/0x0 - No Content Yet 1 0x2003c 0 1/271769/0x25716258/0x0 - 1/271769/0x25716258/0x0 1 0x2000c 0 1/271759/0x36241b0/0x0 - 1/271759/0x36241b0/0x0 1 0x2003b 0 1/271761/0x2fb351b0/0x0 - 1/271761/0x2fb351b0/0x0 1 0x20019 0 1/268757/0x18987220/0x0 - No Content Yet 1 0x20090 0 1/271708/0x2d9b1318/0x0 - 1/271708/0x2d9b1318/0x1 1 0x200cd 652211 1/271769/0x2710a138/0x0 -1/271769/0x275b4140/0x2a3 1 0x20011 0 1/267739/0x186a8314/0x0 - No Content Yet 1 0x20038 0 1/268761/0x1b97b1b0/0x0 - No Content Yet 1 0x20016 0 1/271769/0x245ca0f8/0x0 -1/271769/0x245ca0f8/0x137 1 0x2008e 0 1/271761/0x73c53cc/0x0 - 1/271761/0x73c53cc/0x0 1 0x20013 0 1/271769/0x24935580/0x0 -1/271769/0x24935580/0x137 1 0x20065 0 1/268769/0xff1b37c/0x0 - No Content Yet 1 0x20057 0 1/268769/0xff147c8/0x0 - No Content Yet 1 0x2000f 0 1/271769/0x248990e0/0x0 -1/271769/0x248990e0/0x130 1 0x2000a 0 1/269782/0x275512b0/0x0 - No Content Yet 1 0x20092 0 1/271769/0x27091718/0x0 -1/271769/0x27091718/0xe8 1 0x2008d 0 1/271731/0x4239220/0x0 - 1/271731/0x4239220/0x0 1 0x200aa 0 1/267744/0x6446118/0x0 - No Content Yet 1 0x2005b 0 1/268181/0x2010e1b0/0x0 - No Content Yet 1 0x20091 0 1/271769/0x270d4068/0x0 -1/271769/0x270d4068/0x55 1 0x20001 342 1/271769/0x2710b18c/0x0 - 1/271769/0x275b518c/0x0 First Txn (0x3e43277b0) Key: 1/271769/0x2746b074/0x00000000 Txn Stamp: 367458166, Reference Count: 1. Txn Flags: None Txn Commit Time: (1370363010) 2013/06/04 11:23:30 Txn Size in Queue: 619337 First Buf's (0x3d9a740d0) Queue Flags: Resident First Buf's Buffer Flags: TRG, Stream Traverse handle (0x3dd127218) for thread CDRD_8397 at txn (0x3e43277b0): 1/271769/0x2746b074/0x00000000 Flags: In_Transaction Last Txn (0x3dd5b0a78) Key: 1/271769/0x275b518c/0x00000000 Txn Stamp: 367458171, Reference Count: 0. Txn Flags: None Txn Commit Time: (1370363011) 2013/06/04 11:23:31 Txn Size in Queue: 146 First Buf's (0x3dd5b0c90) Queue Flags: Resident First Buf's Buffer Flags: TRG, Stream Traverse handle (0x3dd345028) for thread CDRD_8425 at txn (0x3dd5b0a78) End_of_Q, Flags: None Traverse handle (0x3d97c6028) for thread CDRNr1 at Head_of_Q, Flags: None Traverse handle (0x3dc80a028) for thread CDRD_8375 at Head_of_Q, Flags: None Traverse handle (0x3dd2a1028) for thread CDRD_8390 at Head_of_Q, Flags: None ...... Traverse handle (0x3dd127218) for thread CDRD_8397 at txn (0x3e43277b0): 1/271769/0x2746b074/0x00000000 Flags: In_Transaction Traverse handle (0x3dd1282c0) for thread CDRD_8397 at Head_of_Q, Flags: None ...... Traverse handle (0x3dd345028) for thread CDRD_8425 at txn (0x3dd5b0a78) End_of_Q, Flags: None ......
To discuss how Oninit ® can assist please call on +1-913-674-0360 or alternatively just send an email specifying your requirements.