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 lower case, 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.

Table 18. DB2 statistics record (Q5ST)
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 data contains counts for each request type that the DB2 resource manager supports. For these request types, maximum and cumulative elapse times are kept for the following:

Information is also provided for:

If the abnormal termination count is not zero, a requeue count is provided indicating the number of queued requests that were requeued to other server tasks as a result of the abnormal termination.

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.