DB2 plan activity record (RCT - Type C9)
Offset HEX/DEC | Field name | Length (DEC) - Type | Field description |
|---|---|---|---|
1C (28) | RCTPLID | 08 - C | Plan Name |
24 (36) | RCTTXID | 04 - C | Transaction ID |
28 (40) | RCTUSECT | 04 - B | Plan/Transaction Use Count |
2C (44) | RCTTHWTS | 04 - B | Plan/Transaction Thread Waits |
30 (48) | RCTAUTHS | 04 - B | Plan/Transaction Authorizations |
34 (52) | RCTTHRDM | 02 - B | Maximum Number of Threads |
36 (54) | RCTTHRDA | 02 - B | Number of Active Threads |
38 (56) | RCTTHRDS | 02 - B | Number of Dedicated Threads |
3A (58) | RCTTHWM | 02 - B | Thread High-Water Mark |
3C (60) | RCTSQ#RQ | 04 - B | Total SQL Requests |
40 (64) | RCTSQTIM | 04 - K | Total SQL Elapsed Time |
44 (68) | RCTSQ#SE | 04 - B | Number of SELECT Requests |
48 (72) | RCTSQTSE | 04 - K | Elapsed Time for SELECT Requests |
4C (76) | RCTSQ#OP | 04 - B | Number of OPEN CURSOR Requests |
50 (80) | RCTSQTOP | 04 - K | Elapsed Time for OPEN CURSOR Requests |
54 (84) | RCTSQ#CL | 04 - B | Number of CLOSE CURSOR Requests |
58 (88) | RCTSQTCL | 04 - K | Elapsed Time for CLOSE CURSOR Requests |
5C (92) | RCTSQ#IN | 04 - B | Number of INSERT Requests |
60 (96) | RCTSQTIN | 04 - K | Elapsed Time for INSERT Requests |
64 (100) | RCTSQ#DE | 04 - B | Number of DELETE Requests |
68 (104) | RCTSQTDE | 04 - K | Elapsed Time for DELETE Requests |
6C (108) | RCTSQ#UP | 04 - B | Number of UPDATE Requests |
70 (112) | RCTSQTUP | 04 - K | Elapsed Time for UPDATE Requests |
74 (116) | RCTSQ#FE | 04 - B | Number of FETCH Requests |
78 (120) | RCTSQTFE | 04 - K | Elapsed Time for FETCH Requests |
7C (124) | RCTSQ#CO | 04 - B | Number of COMMIT Requests |
80 (128) | RCTSQTCO | 04 - K | Elapsed Time for COMMIT Requests |
84 (132) | RCTSQ#OT | 04 - B | Number of OTHER Requests |
88 (136) | RCTSQTOT | 04 - K | Elapsed Time for OTHER Requests |
8C (140) | 12 | Reserved for Future Use |