Db2 manager data records
Use this topic as a reference to the format of the Db2® manager data records.
The format of the Db2 manager statistics record is described in the following table and in assembler macro thlqual.SCSQMACS(CSQDQ5ST) and C header file thlqual.SCSQC370(CSQDSMFC). The field names in C are all in lowercase, for example q5st, q5stid.
If the queue manager was not started as a member of a queue-sharing group, no data is recorded in this record.
Offset: Dec | Offset: Hex | Type | Len | Name | Description |
---|---|---|---|---|---|
0 | 0 | Structure | 668 | Q5ST | Db2 manager statistics |
0 | 0 | Bitstring | 2 | Q5STID | Control block identifier |
2 | 2 | Integer | 2 | Q5STLL | Control block length |
4 | 4 | Character | 4 | Q5STEYEC | Control block eye catcher |
8 | 8 | Character | 660 | Q5STZERO | QMST part cleared on occasion |
8 | 8 | Integer | 4 | NUMTASK | Number of server tasks |
12 | C | Integer | 4 | ACTTASK | Number of active server tasks |
16 | 10 | Integer | 4 | CONNCNT | Number of connect requests |
20 | 14 | Integer | 4 | DISCCNT | Number of disconnect requests |
24 | 18 | Integer | 4 | DHIGMAX | Max. request queue depth |
28 | 1C | Integer | 4 | ABNDCNT | Number of Db2SRV task abends |
32 | 20 | Integer | 4 | REQUCNT | Number of requests requeued |
36 | 24 | Integer | 4 | DEADCNT | Number of deadlock timeouts |
40 | 28 | Integer | 4 | DELECNT | Number of delete requests |
44 | 2C | Integer | 4 | LISTCNT | Number of list requests |
48 | 30 | Integer | 4 | READCNT | Number of read requests |
52 | 34 | Integer | 4 | UPDTCNT | Number of update requests |
56 | 38 | Integer | 4 | WRITCNT | Number of write requests |
60 | 3C | Integer | 4 | SCSSEL | SCST (shared-channel-status) selects |
64 | 40 | Integer | 4 | SCSINS | SCST inserts |
68 | 44 | Integer | 4 | SCSUPD | SCST updates |
72 | 48 | Integer | 4 | SCSDEL | SCST deletes |
76 | 4C | Integer | 4 | SSKSEL | SSKT (shared-sync-key) selects |
80 | 50 | Integer | 4 | SSKINS | SSKT inserts |
84 | 54 | Integer | 4 | SSKDEL | SSKT deletes |
88 | 58 | Integer | 4 | SCSBFTS | SCST number of times buffer too small |
92 | 5C | Integer | 4 | SCSMAXR | SCST maximum rows on query |
96 | 60 | Integer | 4 | * (2) | Reserved |
104 | 68 | Character | 8 | DELETCUW | Cumulative STCK difference - Thread delete |
112 | 70 | Character | 8 | DELETMXW | Maximum STCK difference - Thread delete |
120 | 78 | Character | 8 | DELESCUW | Cumulative STCK difference - SQL delete |
128 | 80 | Character | 8 | DELESMXW | Maximum STCK difference - SQL delete |
136 | 88 | Character | 8 | LISTTCUW | Cumulative STCK difference - Thread list |
144 | 90 | Character | 8 | LISTTMXW | Maximum STCK difference - Thread list |
152 | 98 | Character | 8 | LISTSCUW | Cumulative STCK difference - SQL list |
160 | A0 | Character | 8 | LISTSMXW | Maximum STCK difference - SQL list |
168 | A8 | Character | 8 | READTCUW | Cumulative STCK difference - Thread read |
17 6 | B0 | Character | 8 | READTMXW | Maximum STCK difference - Thread read |
184 | B8 | Character | 8 | READSCUW | Cumulative STCK difference - SQL read |
192 | C0 | Character | 8 | READSMXW | Maximum STCK difference - SQL read |
200 | C8 | Character | 8 | UPDTTCUW | Cumulative STCK difference - Thread update |
208 | D0 | Character | 8 | UPDTTMXW | Maximum STCK difference - Thread update |
216 | D8 | Character | 8 | UPDTSCUW | Cumulative STCK difference - SQL update |
224 | E0 | Character | 8 | UPDTSMXW | Maximum STCK difference - SQL update |
232 | E8 | Character | 8 | WRITTCUW | Cumulative STCK difference - Thread write |
240 | F0 | Character | 8 | WRITTMXW | Maximum STCK difference - Thread write |
248 | F8 | Character | 8 | WRITSCUW | Cumulative STCK difference - SQL write |
256 | 100 | Character | 8 | WRITSMXW | Maximum STCK difference - SQL write |
264 | 108 | Character | 8 | SCSSTCUW | Cumulative STCK difference - Thread select |
272 | 110 | Character | 8 | SCSSTMXW | Maximum STCK difference - Thread select |
280 | 118 | Character | 8 | SCSSSCUW | Cumulative STCK difference - SQL select |
288 | 120 | Character | 8 | SCSSSMXW | Maximum STCK difference - SQL select |
296 | 128 | Character | 8 | SCSITCUW | Cumulative STCK difference - Thread insert |
304 | 130 | Character | 8 | SCSITMXW | Maximum STCK difference - Thread insert |
312 | 138 | Character | 8 | SCSISCUW | Cumulative STCK difference - SQL insert |
320 | 140 | Character | 8 | SCSISMXW | Maximum STCK difference - SQL insert |
328 | 148 | Character | 8 | SCSUTCUW | Cumulative STCK difference - Thread update |
336 | 150 | Character | 8 | SCSUTMXW | Maximum STCK difference - Thread update |
344 | 158 | Character | 8 | SCSUSCUW | Cumulative STCK difference - SQL update |
352 | 160 | Character | 8 | SCSUSMXW | Maximum STCK difference - SQL update |
360 | 168 | Character | 8 | SCSDTCUW | Cumulative STCK difference - Thread delete |
368 | 170 | Character | 8 | SCSDTMXW | Maximum STCK difference - Thread delete |
376 | 178 | Character | 8 | SCSDSCUW | Cumulative STCK difference - SQL delete |
384 | 180 | Character | 8 | SCSDSMXW | Maximum STCK difference - SQL delete |
392 | 188 | Character | 8 | SSKSTCUW | Cumulative STCK difference - Thread select |
400 | 190 | Character | 8 | SSKSTMXW | Maximum STCK difference - Thread select |
408 | 198 | Character | 8 | SSKSSCUW | Cumulative STCK difference - SQL select |
416 | 1A0 | Character | 8 | SSKSSMXW | Maximum STCK difference - SQL select |
424 | 1A8 | Character | 8 | SSKITCUW | Cumulative STCK difference - Thread insert |
432 | 1B0 | Character | 8 | SSKITMXW | Maximum STCK difference - Thread insert |
440 | 1B8 | Character | 8 | SSKISCUW | Cumulative STCK difference - SQL insert |
448 | 1C0 | Character | 8 | SSKISMXW | Maximum STCK difference - SQL insert |
456 | 1C8 | Character | 8 | SSKDTCUW | Cumulative STCK difference - Thread delete |
464 | 1D0 | Character | 8 | SSKDTMXW | Maximum STCK difference - Thread delete |
472 | 1D8 | Character | 8 | SSKDSCUW | Cumulative STCK difference - SQL delete |
480 | 1E0 | Character | 8 | SSKDSMXW | Maximum STCK difference - SQL delete |
488 | 1E8 | Integer | 4 | LMSSEL | Number of Db2 BLOB read requests |
492 | 1EC | Integer | 4 | LMSINS | Number of Db2 BLOB insert requests |
496 | 1F0 | Integer | 4 | LMSUPD | Number of Db2 BLOB update requests |
500 | 1F4 | Integer | 4 | LMSDEL | Number of Db2 BLOB delete requests |
504 | 1F8 | Integer | 4 | LMSLIS | Number of Db2 BLOB list requests |
508 | IFC | 64 bit integer | 8 | LMSSTCUW | Total elapsed time for all thread read BLOB requests |
516 | 204 | 64 bit integer | 8 | LMSSTMXW | Maximum elapsed time for a thread read BLOB request |
524 | 20C | 64 bit integer | 8 | LMSSSCUW | Total elapsed time for all SQL read BLOB requests |
532 | 214 | 64 bit integer | 8 | LMSSSMXW | Maximum elapsed time for an SQL read BLOB request |
540 | 21C | 64 bit integer | 8 | LMSITCUW | Total elapsed time for all thread insert BLOB requests |
548 | 224 | 64 bit integer | 8 | LMSITMXW | Maximum elapsed time for a thread insert BLOB request |
556 | 22C | 64 bit integer | 8 | LMSISCUW | Total elapsed time for all SQL insert BLOB requests |
564 | 234 | 64 bit integer | 8 | LMSISMXW | Maximum elapsed time for an SQL insert BLOB request |
572 | 23C | 64 bit integer | 8 | LMSUTCUW | Total elapsed time for all thread update BLOB requests |
580 | 244 | 64 bit integer | 8 | LMSUTMXW | Maximum elapsed time for a thread update BLOB request |
588 | 24C | 64 bit integer | 8 | LMSUSCUW | Total elapsed time for all SQL update BLOB requests |
596 | 254 | 64 bit integer | 8 | LMSUSMXW | Maximum elapsed time for an SQL update BLOB request |
604 | 25C | 64 bit integer | 8 | LMSDTCUW | Total elapsed time for all thread delete BLOB requests |
612 | 264 | 64 bit integer | 8 | LMSDTMXW | Maximum elapsed time for a thread delete BLOB request |
620 | 26C | 64 bit integer | 8 | LMSDSCUW | Total elapsed time for all SQL delete BLOB requests |
628 | 274 | 64 bit integer | 8 | LMSDSMXW | Maximum elapsed time for an SQL delete BLOB request |
636 | 27C | 64 bit integer | 8 | LMSLTCUW | Total elapsed time for all thread list BLOB requests |
644 | 284 | 64 bit integer | 8 | LMSLTMXW | Maximum elapsed time for a thread list BLOB request |
652 | 28C | 64 bit integer | 8 | LMSLSCUW | Total elapsed time for all SQL list BLOB requests |
660 | 294 | 64 bit integer | 8 | LMSLSMXW | Maximum elapsed time for an SQL list BLOB request |
- The time spent in the Db2 resource manager as a whole (called the thread time).
- The time that was spent performing the RRSAF and SQL parts of the request (a subset of the thread time called the SQL time).
- The number of server tasks attached.
- The maximum overall request depth against any of the server tasks.
- The number of times any of the server task requests terminated abnormally.
If the average thread time is significantly greater that the average SQL time, this might indicate that thread requests are spending an excessive amount of time waiting for a server task to process the SQL part of the request. If this is the case, examine the DHIGMAX field and, if the value is greater than one, consider increasing the number of Db2 server tasks specified in the QSGDATA parameter of the CSQ6SYSP system parameter macro.