DB2 connection record (D2G - Type 66)
Offset HEX/DEC | Field name | Length (DEC) - Type | Field description |
|---|---|---|---|
1C (28) | D2GCONNM | 08 - C | Name of the DB2CONN |
24 (36) | D2GID | 04 - C | DB2 Sysid |
28 (40) | D2GRELEA | 04 - C | Release of DB2 |
2C (44) | D2GCONGT | 08 - M | Connect Time (GMT) |
34 (52) | D2GCONLT | 08 - M | Connect Time (Local) |
3C (60) | D2GDISGT | 08 - M | Disconnect Time (GMT) |
44 (68) | D2GDISLT | 08 - M | Disconnect Time (Local) |
4C (76) | D2GTCBLI | 04 - B | Maximum Number of TCBs |
50 (80) | D2GTCBCU | 04 - B | Current Number of TCBs |
54 (84) | D2GTCBHW | 04 - B | HWM of TCBs |
58 (88) | D2GTCBFR | 04 - B | Current Number of Free TCBs |
5C (92) | D2GTCBRQ | 04 - B | Number of Tasks on TCB Ready Queue |
60 (96) | D2GTCBRH | 04 - B | Peak Number of Tasks on TCB Ready Queue |
64 (100) | D2GRPID | 04 - C | DB2 Group ID |
68 (104) | D2RSYNCM | 01 - X | Flag to Resync UOWs |
6C (108) | D2RUSLIM | 04 - B | Thread Reuse Limit |
70 (112) | D2GTCBPC | 04 - B | TCBs for protected threads |
8C (140) | D2GPLANN | 08 - C | Pool Statistics |
94 (148) | D2GPLANX | 08 - C | PLANEXIT Name, if any |
9C (156) | D2GAUTH | 08 - C | Static Authorization ID, if any |
A4 (164) | D2GAUTHT | 01 - X | Pool Authorization Type, if any |
A5 (165) | D2GACCOU | 01 - X | ACCOUNTREC Setting |
A6 (166) | D2GTHRDW | 01 - X | THREADWAIT Setting |
A7 (167) | D2GPRIOR | 01 - X | Thread Priority |
A8 (168) | D2GCALLS | 04 - B | Number of Calls Using Pool |
AC (172) | D2GSIGNO | 04 - B | Number of Pool Sign Ons |
B0 (176) | D2GCOMMI | 04 - B | Number of Commits |
B4 (180) | D2GABORT | 04 - B | Number of Aborts |
B8 (184) | D2GSPHAS | 04 - B | Number of Single Phase Commits |
BC (188) | D2GTREUS | 04 - B | Number of Thread Reuses |
C0 (192) | D2GTTERM | 04 - B | Number of Pool Thread Terminates |
C4 (196) | D2GTWAIT | 04 - B | Number of Pool Thread Waits |
C8 (200) | D2GTLIMI | 04 - B | Maximum Number of Pool Threads |
CC (204) | D2GTCURR | 04 - B | Current Number of Pool Threads |
D0 (208) | D2GTHWM | 04 - B | Peak Number of Pool Threads |
D4 (212) | D2GTACUR | 04 - B | Current Number of Tasks |
D8 (216) | D2GTAHWM | 04 - B | Peak Number of Tasks |
DC (220) | D2GTATOT | 04 - B | Total Number of Tasks |
E0 (224) | D2GRCURR | 04 - B | Number of Tasks on Ready Queue |
E4 (228) | D2GRHWM | 04 - B | Peak Number of Tasks on Ready Queue |
E8 (232) | D2GPRSIN | 04 - B | Partial signons |
EC (236) | D2GPTHCR | 04 - B | Pool thread creates |
F0 (240) | D2GPRUSE | 04 - B | Number of Times Reuse Limit Hit |
104 (260) | D2GCAUTH | 08 - C | DSNC Command Statistics |
10C (268) | D2GCAUTT | 01 - X | Command Authorization Type, if any |
110 (272) | D2GCCALL | 04 - B | Number of DSNC Command Calls |
114 (276) | D2GCSIGN | 04 - B | Number of Command Signons |
118 (280) | D2GCTTER | 04 - B | Number of Command Thread Terminates |
11C (284) | D2GCTOVE | 04 - B | Number of Overflows to Pool |
120 (288) | D2GCTLIM | 04 - B | Maximum Number of Command Threads |
124 (292) | D2GCTCUR | 04 - B | Current Number of Command Threads |
128 (296) | D2GCTHWM | 04 - B | Peak Number of Command Threads |
12C (300) | D2GCMTHC | 04 - B | Command thread creates |
150 (336) | D2GDSRC | 08 - C | Definition source |
158 (344) | D2GCTIM | 08 - S | Change time |
160 (352) | D2GCUSE | 08 - C | Change user ID |
168 (360) | D2GCAGT | 02 - B | Change agent |
16A (362) | D2GIAGT | 02 - B | Install agent |
16C (364) | D2GITIM | 08 - S | Install time |
174 (372) | D2GIUSE | 08 - C | Install user ID |