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.
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:
Table 1. 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 Information is also provided for:
- 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).
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.
- 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.