SAP ABAP Data Element - Index D, page 8
Data Element - D
# Data Element Short Description Domain Data Type
1 DB2TGLOBTC Number of Global Locking Suspensions DB2INT4 INT4 
2 DB2TGLOBTE Number of global locking suspensions DB2NUMC10 NUMC 
3 DB2TGLOBTM Global locking suspension time DB2CHAR16 CHAR 
4 DB2TGSCCLS Number of lock requests propagated to MVS XES synchronously DB2NUMC10 NUMC 
5 DB2TGSCCPL Number of Change Requests for P-Locks DB2NUMC10 NUMC 
6 DB2TGSCCSL No. of Change Requests Propagated to MVS XES Synchronously DB2NUMC10 NUMC 
7 DB2TGSCDRT Incompatible retained lock DB2NUMC10 NUMC 
8 DB2TGSCFLS Number of suspends because of false contentions DB2NUMC10 NUMC 
9 DB2TGSCHNP P-Lock Change Request During P-Lock Negotiation DB2DEC10V DEC 
10 DB2TGSCIGL Number of suspends caused by IRLM global resource contention DB2NUMC10 NUMC 
11 DB2TGSCLPL Number of lock requests for P-locks DB2NUMC10 NUMC 
12 DB2TGSCLSL Number of lock requests propagated to MVS XES synchronously DB2NUMC10 NUMC 
13 DB2TGSCNTF Number of Notification Messages Sent to Other Members DB2NUMC10 NUMC 
14 DB2TGSCPLK Number of Change Requests for P-Locks DB2DEC10V DEC 
15 DB2TGSCSGL Suspends caused by MVS XES global resource contention DB2NUMC10 NUMC 
16 DB2TGSCSLM No. of Change Requests Propagated to MVS XES Synchronously DB2DEC10V DEC 
17 DB2TGSCUPL Number of unlock requests for P-locks DB2NUMC10 NUMC 
18 DB2TGSCUSL Number of IRLM unlock requests propagated to MVS XES synch. DB2NUMC10 NUMC 
19 DB2TGSDRTA Incompatible retained lock DB2DEC10V DEC 
20 DB2TGSFLMG False contention on z/OS image DB2DEC10V DEC 
21 DB2TGSFLSE Number of suspends because of false contentions DB2DEC10V DEC 
22 DB2TGSIGLO Number of suspends caused by IRLM global resource contention DB2DEC10V DEC 
23 DB2TGSKIDS Number of resources propagated by IRLM to MVS XES async. DB2DEC10V DEC 
24 DB2TGSLPLK Number of lock requests for P-locks DB2DEC10V DEC 
25 DB2TGSLSLM Number of lock requests propagated to MVS XES synchronously DB2DEC10V DEC 
26 DB2TGSNTFR Number of Notification Messages Received from Other Members DB2DEC10V DEC 
27 DB2TGSNTFY Number of Notification Messages Sent to Other Members DB2DEC10V DEC 
28 DB2TGSOTPE Other P-Lock Negotiation DB2DEC10V DEC 
29 DB2TGSPEMX Maximum Engines for P-Lock/Notify Exits DB2DEC10V DEC 
30 DB2TGSPEQW Engines Unavailable for P-Lock/Notify Exits DB2DEC10V DEC 
31 DB2TGSPGPE Page P-Lock Negotiation DB2DEC10V DEC 
32 DB2TGSPPPE Page Set/Partition P-Lock Negotiation DB2DEC10V DEC 
33 DB2TGSSGLO Suspends caused by MVS XES global resource contention DB2DEC10V DEC 
34 DB2TGSUPLK Number of unlock requests for P-locks DB2DEC10V DEC 
35 DB2TGSUSLM Number of IRLM unlock requests propagated to MVS XES synch. DB2DEC10V DEC 
36 DB2THCTIM DB2 Thread times   NUMC 
37 DB2THDACT1 DB2INT4 INT4 
38 DB2THDACT2 DB2INT4 INT4 
39 DB2THDCELT Time elapsed since DB2 thread was started DB2NUMC10 NUMC 
40 DB2THDCJOB The job name of the thread. DB2CHAR08 CHAR 
41 DB2THDCLOC The total number of currently hold locks. DB2NUMC10 NUMC 
42 DB2THDCSQL The total number of executed SQL statements DB2NUMC10 NUMC 
43 DB2THDCTAC Activity time (Class 1 elapsed time) [hh:mm:ss.ms] DB2CHAR16 CHAR 
44 DB2THDELT Time elapsed since DB2 thread was started DB2INT4 INT4 
45 DB2THDJOB The job name of the thread. DB2CHAR8 CHAR 
46 DB2THDLOCK The total number of currently hold locks. DB2INT4 INT4 
47 DB2THDSQL The total number of executed SQL statements DB2INT4 INT4 
48 DB2THDTACC Activity time (Class 1 elapsed time) [hh:mm:ss.ms] DB2DEC16 DEC 
49 DB2THDTACT Activity time (Class 1 elapsed time) DB2CHAR16 CHAR 
50 DB2THDTSTT DB2SINT INT2 
51 DB2THEVENT Events NUMC10 NUMC 
52 DB2THTIM DB2 thread times DB2NUMC10 NUMC 
53 DB2TIFIA Average IFI entry/exit duration DB2CHAR16 CHAR 
54 DB2TIFICPU Accumulated CPU time spent processing IFI calls DB2CHAR16 CHAR 
55 DB2TIFIE Accumulated elapsed time spent processing IFI calls DB2CHAR16 CHAR 
56 DB2TIFIELT IFI entry/exit duration elapsed time DB2CHAR10 CHAR 
57 DB2TIFIPRT IFI entry/exit duration processing (CPU) DB2CHAR10 CHAR 
58 DB2TIMCPU CPU time   CHAR 
59 DB2TIMDELTA time delta   DEC 
60 DB2TIME Field type time, HHMMSS DB2TIME TIMS 
61 DB2TIMESTAMP DB2-z/OS: General purpose timestamp in DB2 hex format   NUMC 
62 DB2TIMESTAMP19 date and time concatenation - like timestamps   CHAR 
63 DB2TIMESTRING Character Representation of DB2 Timestamp   CHAR 
64 DB2TIMEUSW Wait time for EU switch   CHAR 
65 DB2TIMGLLO Wait time for global lock   CHAR 
66 DB2TIMLOLA Wait time for lock/latch   CHAR 
67 DB2TIMOTHE Other wait time   CHAR 
68 DB2TIMREAD Wait time for other read   CHAR 
69 DB2TIMSYIO Wait time for synchronous I/O   CHAR 
70 DB2TIMWAIT Wait time   CHAR 
71 DB2TIMWRIT Wait time for other write   CHAR 
72 DB2TINDB2 Accumulated elapsed time in DB2 DB2CHAR16 CHAR 
73 DB2TINDB2A Average interval between DB2 entry and exit events DB2CHAR16 CHAR 
74 DB2TINDB2C Accumulated Elapsed Time in DB2 DB2DEC16 DEC 
75 DB2TIO I/O suspension time DB2CHAR16 CHAR 
76 DB2TIOA Average duration of I/O suspension DB2CHAR10 CHAR 
77 DB2TIOC I/O suspension time DB2DEC16 DEC 
78 DB2TIOE Number of I/O suspensions NUMC10 NUMC 
79 DB2TIOEC Number of I/O suspensions DB2INT4 INT4 
80 DB2TIOP Percent of time in DB2 for synchronous reads and writes DB2CHAR10 CHAR 
81 DB2TLKLA Lock/latch supension time DB2CHAR16 CHAR 
82 DB2TLKLAA Average duration of lock/latch supensions DB2CHAR10 CHAR 
83 DB2TLKLAC Lock / Latch Supension Time DB2DEC16 DEC 
84 DB2TLKLAE Number of Lock / Latch Suspensions NUMC10 NUMC 
85 DB2TLKLAEC Number of Lock / Latch Suspensions DB2INT4 INT4 
86 DB2TLOPRAT Locking optimization rate DB2CHAR10 CHAR 
87 DB2TMAXDS Max. no. of datasets open concurrently DB2INT4U INT4 
88 DB2TMAXPB Page sets available to drain since last statistics interval DB2INT4U INT4 
89 DB2TNAINDB Not attributed time in DB2 DB2CHAR16 CHAR 
90 DB2TNAINDC Not attributed time in DB2 DB2DEC16 DEC 
91 DB2TNOTM Notify messages suspension time DB2CHAR16 CHAR 
92 DB2TNOTMA Average duration of notify messages suspensions DB2CHAR10 CHAR 
93 DB2TNOTMC Notify messages suspension time DB2DEC16 DEC 
94 DB2TNOTME Number of notify messages suspensions DB2NUMC10 NUMC 
95 DB2TNOTMEC Number of Notify Messages Suspensions DB2INT4 INT4 
96 DB2TOCST Wait time for open/close service task (incl. HSM recall) DB2CHAR16 CHAR 
97 DB2TOCSTA Average waiting time for open/close service task DB2CHAR10 CHAR 
98 DB2TOCSTC Wait time for open/close service task (incl. HSM recall) DB2DEC16 DEC 
99 DB2TOCSTE Number of waits for open/close service task DB2NUMC10 NUMC 
100 DB2TOCSTEC Number of waits for open/close service task DB2INT4 INT4 
101 DB2TOTDSBP Total data space buffer pools size (MB) DB2NUMC10 NUMC 
102 DB2TOTHINE Time spent for other waits in DB2 DB2CHAR16 CHAR 
103 DB2TOTHP Total hiperpools size (MB) DB2NUMC10 NUMC 
104 DB2TOTHR Other read suspensions time DB2CHAR16 CHAR 
105 DB2TOTHRA Average duration of other read suspensions DB2CHAR10 CHAR 
106 DB2TOTHRC Other read suspensions time DB2DEC16 DEC 
107 DB2TOTHRCC Wait time for other service tasks DB2DEC16 DEC 
108 DB2TOTHRE Number of other read suspensions NUMC10 NUMC 
109 DB2TOTHREC Number of other read suspensions DB2INT4 INT4 
110 DB2TOTHRSA Average waiting time for other service tasks DB2CHAR10 CHAR 
111 DB2TOTHRSC Number of waits for other service tasks DB2INT4 INT4 
112 DB2TOTHRSE Number of waits for other service tasks DB2NUMC10 NUMC 
113 DB2TOTHRST Wait time for other service tasks DB2CHAR16 CHAR 
114 DB2TOTHW Other write suspensions time DB2CHAR16 CHAR 
115 DB2TOTHWA Average duration of other write suspensions DB2CHAR10 CHAR 
116 DB2TOTHWC Other write suspensions time DB2DEC16 DEC 
117 DB2TOTHWE Number of other write suspensions DB2NUMC10 NUMC 
118 DB2TOTHWEC Number of other write suspensions DB2INT4 INT4 
119 DB2TOTPBP Total primary buffer pools size (MB) DB2NUMC10 NUMC 
120 DB2TPCCT No. of infrequently updated datasets conv. from R/W to R/O DB2INT4U INT4 
121 DB2TPGLA Page latch suspension time DB2CHAR16 CHAR 
122 DB2TPGLAA Average duration of page latch suspensions DB2CHAR10 CHAR 
123 DB2TPGLAC Page latch suspension time DB2DEC16 DEC 
124 DB2TPGLAE Number of page latch suspensions DB2NUMC10 NUMC 
125 DB2TPGLAEC Number of Page Latch Suspensions DB2INT4 INT4 
126 DB2TRACAUT Number of successful authorization checks DB2INT4 INT4 
127 DB2TRCLVL DB2SINT INT2 
128 DB2TREET Accumulated elapsed time used for executing triggers DB2CHAR16 CHAR 
129 DB2TREOPN Number of times a previously unused dataset was used DB2INT4 INT4 
130 DB2TRETT Accumulated elapsed time used while executing DB2CHAR16 CHAR 
131 DB2TROWS Number of records in a table DEC15 DEC 
132 DB2TRTET Accumulated TCB time used for executing triggers DB2CHAR16 CHAR 
133 DB2TRTTT Accumulated TCB time used while executing DB2CHAR16 CHAR 
134 DB2TSFREE Free size of a tablespace in KB (allocated minus used stor.) DEC11 DEC 
135 DB2TSFREEP Free size of partition of a tablespace in KB DEC11 DEC 
136 DB2TSFREET Total free size of all R/3 tablespaces in KB DEC13 DEC 
137 DB2TSIXNM Tablespace/indexspace name DB2CHAR08 CHAR 
138 DB2TSLST Wait time for SYSLGRNG recording service task DB2CHAR16 CHAR 
139 DB2TSLSTA Average waiting time for SYSLGRNG recording service task DB2CHAR10 CHAR 
140 DB2TSLSTC Wait time for SYSLGRNG recording service task DB2DEC16 DEC 
141 DB2TSLSTE Number of waits for SYSLGRNG recording service task DB2NUMC10 NUMC 
142 DB2TSLSTEC Number of waits for SYSLGRNG recording service task DB2INT4 INT4 
143 DB2TSLWDD Datasets not used, but not closed due to deferred close DB2INT4U INT4 
144 DB2TSNAM1 Name of tablespace DB2TSNAME CHAR 
145 DB2TSNAME Name of the tablespace CHAR8 CHAR 
146 DB2TSNAML DB2 TS Name   CHAR 
147 DB2TSNUM Number of tablespaces in the R/3 system DEC08 DEC 
148 DB2TSOUSER z/OS TSO User   CHAR 
149 DB2TSPCPT Accumulated TCB time spent DB2CHAR16 CHAR 
150 DB2TSPCPU CPU time for SQL statements in the stored procedures AS DB2CHAR16 CHAR 
151 DB2TSPCTT Percentage of free size to allocated size of all tablespaces NUMC03 NUMC 
152 DB2TSPCTU Percentage of used size to allocated size of a tablespace DEC3 DEC 
153 DB2TSPCTUP Percentage of used to alloc. size of a partition of a TS DEC3 DEC 
154 DB2TSPCTUT Percentage of used size to allocated size of all tablespaces DEC3 DEC 
155 DB2TSPE Total elapsed time spent executing SQL in stored procedures DB2TIMEP CHAR 
156 DB2TSPEAT Total elapsed time spent in stored procedures DB2CHAR16 CHAR 
157 DB2TSPET Total elapsed time spent executing SQL in stored procedures DB2CHAR16 CHAR 
158 DB2TSPP Accumulated TCB time spend in DB2 by stored procedures DB2TIMEP CHAR 
159 DB2TSPPT Accumulated TCB time spend in DB2 by stored procedures DB2CHAR16 CHAR 
160 DB2TSRVT Wait time for DB2 commit phase II processing DB2CHAR16 CHAR 
161 DB2TSRVTA Average waiting time for commit phase II or abort DB2CHAR10 CHAR 
162 DB2TSRVTC Number of waits for commit phase II or abort DB2DEC16 DEC 
163 DB2TSRVTE Number of waits for commit phase II or abort DB2NUMC10 NUMC 
164 DB2TSRVTEC Number of waits for commit phase II or abort DB2INT4 INT4 
165 DB2TSSIZ Total size of a tablespace (allocated storage in KB) DEC11 DEC 
166 DB2TSSIZP Allocated storage of a partition of a tablespace in KB DEC11 DEC 
167 DB2TSSIZT Total size of all R/3 tablespaces (allocated storage in kB) DEC13 DEC 
168 DB2TSSPINC CPU processing time for SQL statements in stored procedures DB2CHAR16 CHAR 
169 DB2TSSTAT Availability status of the tablespace DB2TSSTAT CHAR 
170 DB2TSTYPE TS: Type of object   CHAR 
171 DB2TSUSPIC Time spent suspended in DB2 DB2DEC16 DEC 
172 DB2TSUSPIN Time spent suspended in DB2 DB2CHAR16 CHAR 
173 DB2TTLCOPR Transaction Locking Optimization Rate DB2CHAR10 CHAR 
174 DB2TTLOPRA Transaction locking optimization rate DB2CHAR10 CHAR 
175 DB2TTRGCBE Accumulated TCB time used before the enclave is created DB2CHAR16 CHAR 
176 DB2TTRGCEN TCB time used for executing triggers under an enclave DB2CHAR16 CHAR 
177 DB2TTRGCPU TCB time used while executing under the control of triggers DB2CHAR16 CHAR 
178 DB2TTRGE Time used while executing under the control of triggers DB2CHAR16 CHAR 
179 DB2TTRGENC Elapsed time used for executing triggers under an enclave DB2CHAR16 CHAR 
180 DB2TTRGICB CPU time for processing SQL stmts. before enclave is created DB2CHAR16 CHAR 
181 DB2TUDCPT Accumulated TCB time for user-defined function DB2CHAR16 CHAR 
182 DB2TUDEAT Total elapsed time spent in user-defined functions DB2CHAR16 CHAR 
183 DB2TUDEBT Total elapsed time spent for user-defined function DB2CHAR16 CHAR 
184 DB2TUDEP Elapsed time in percent for user-defined function DB2TIMEP CHAR 
185 DB2TUDFCPU CPU time for user defined functions DB2CHAR16 CHAR 
186 DB2TUDFELA Total elapsed time spent in user-defined functions DB2CHAR16 CHAR 
187 DB2TUDFICA Average CPU time for SQL statements issued by UDFs DB2CHAR16 CHAR 
188 DB2TUDFINA User defined function entry/exit duration DB2CHAR16 CHAR 
189 DB2TUDFINC CPU time for processing SQL statements issued by UDFs DB2CHAR16 CHAR 
190 DB2TUDFINE Total elapsed time spent for user def. func. to execute SQL DB2CHAR16 CHAR 
191 DB2TUDPP Processing (CPU) for user-defined function DB2TIMEP CHAR 
192 DB2TUDTTT Accumulated TCB time in DB2 issued by user-defined functions DB2CHAR16 CHAR 
193 DB2TXACHG Number of change requests DB2INT4 INT4 
194 DB2TXACHUS Highest amt CPU 16 microsec used in successful DB2 call DB2INT4 INT4 
195 DB2TXACLMT Limit in CPU 16 microseconds DB2INT4 INT4 
196 DB2TXACLNO Number of claim requests DB2INT4 INT4 
197 DB2TXACLUN Number of claim requests that were unsuccessful DB2INT4 INT4 
198 DB2TXADEA Number of deadlocks DB2INT4 INT4 
199 DB2TXADRNO Number of drain requests DB2INT4 INT4 
200 DB2TXADRUN Number of drain requests that were unsuccessful DB2INT4 INT4 
201 DB2TXAIRLM Number of other requests DB2INT4 INT4 
202 DB2TXALES Number of lock escalations (shared) DB2INT4 INT4 
203 DB2TXALEX Number of lock escalations (exclusive) DB2INT4 INT4 
204 DB2TXALOCK Number of lock requests DB2INT4 INT4 
205 DB2TXALOCKD Number of lock requests DB2DEC10V DEC 
206 DB2TXANLP Maximum page or row locks held DB2INT4 INT4 
207 DB2TXAPREC Precedence How Limit determined DB2INT4 INT4 
208 DB2TXAQRY Number of query requests DB2INT4 INT4 
209 DB2TXASLAT Number of latch suspensions DB2INT4 INT4 
210 DB2TXASLMT Limit in SU's - ASUTIME Column DB2INT4 INT4 
211 DB2TXASLOC Number of lock suspensions DB2INT4 INT4 
212 DB2TXASOTH Number of other suspensions DB2INT4 INT4 
213 DB2TXATIM Number of timeouts DB2INT4 INT4 
214 DB2TXAUNLK Number of unlock requests DB2INT4 INT4 
215 DB2TXAUNLKD Number of unlock requests DB2DEC10V DEC 
216 DB2TXNAME transaction / thread name   CHAR 
217 DB2TYPE Tablespace type DB2TYPE CHAR 
218 DB2UCNT DB2/390: Unique counter   INT4 
219 DB2UDFDEB UDF entry/exit duration elapsed time DB2CHAR10 CHAR 
220 DB2UDFDTT UDF entry/exit duration processing (CPU) DB2CHAR10 CHAR 
221 DB2UDSTE Number of user defined function DB2NUMC10 NUMC 
222 DB2UDSTP Percent of time spent in DB2 for user defined functions DB2CHAR10 CHAR 
223 DB2UNIQUE Whether the index is unique DB2UNIQUE CHAR 
224 DB2UNIQUERULE unique rule   CHAR 
225 DB2UPDATE RUNSTATS parameter UPDATE DB2UPDATE CHAR 
226 DB2UPDCNT DB2 for OS/390: Number of database updates DB2NUMC10 NUMC 
227 DB2UPPPWRI Buffer update per pages written DB2DEC19V2 DEC 
228 DB2USDEFF User defined functions DB2CHAR10 CHAR 
229 DB2USERID DB2SINT INT2 
230 DB2UTILID Unique identifier for a utility in DB2 CHAR16 CHAR 
231 DB2UTILNAM Utility specification DB2UTILNAM CHAR 
232 DB2UTILRC Return code of the utility   INT4 
233 DB2VALUE128 DB2 z/OS: Value of a certain key in random format   CHAR 
234 DB2VCAT Name of the integrated catalog facility catalog CHAR8 CHAR 
235 DB2VCATL VCAT   CHAR 
236 DB2VLSLC Statistics record latch manager: total values DB2CHAR10 CHAR 
237 DB2VLSLC01 Statistics record latch manager: latch level 1   INT4 
238 DB2VLSLC02 Statistics record latch manager: latch level 2 DB2INT4 INT4 
239 DB2VLSLC03 Statistics record latch manager: latch level 3 DB2INT4 INT4 
240 DB2VLSLC04 Statistics record latch manager: latch level 4 DB2INT4 INT4 
241 DB2VLSLC05 Statistics record latch manager: latch level 5 DB2INT4 INT4 
242 DB2VLSLC06 Statistics record latch manager: latch level 6 DB2INT4 INT4 
243 DB2VLSLC07 Statistics record latch manager: latch level 7 DB2INT4 INT4 
244 DB2VLSLC08 Statistics record latch manager: latch level 8 DB2INT4 INT4 
245 DB2VLSLC09 Statistics record latch manager: latch level 9 DB2INT4 INT4 
246 DB2VLSLC10 Statistics record latch manager: latch level 10 DB2INT4 INT4 
247 DB2VLSLC11 Statistics record latch manager: latch level 11 DB2INT4 INT4 
248 DB2VLSLC12 Statistics record latch manager: latch level 12 DB2INT4 INT4 
249 DB2VLSLC13 Statistics record latch manager: latch level 13 DB2INT4 INT4 
250 DB2VLSLC14 Statistics record latch manager: latch level 14 DB2INT4 INT4 
251 DB2VLSLC15 Statistics record latch manager: latch level 15 DB2INT4 INT4 
252 DB2VLSLC16 Statistics record latch manager: latch level 16 DB2INT4 INT4 
253 DB2VLSLC17 Statistics record latch manager: latch level 17 DB2INT4 INT4 
254 DB2VLSLC18 Statistics record latch manager: latch level 18 DB2INT4 INT4 
255 DB2VLSLC19 Number of internal log latch contentions per second DB2NUMC10 NUMC 
256 DB2VLSLC20 Statistics record latch manager: latch level 20   INT4 
257 DB2VLSLC21 Statistics record latch manager: latch level 21 DB2NUMC10 NUMC 
258 DB2VLSLC22 Statistics record latch manager: latch level 22 DB2NUMC10 NUMC 
259 DB2VLSLC23 Statistics record latch manager: latch level 23 DB2NUMC10 NUMC 
260 DB2VLSLC24 Statistics record latch manager: latch level 24 DB2NUMC10 NUMC 
261 DB2VLSLC25 Statistics record latch manager: latch level 25 DB2NUMC10 NUMC 
262 DB2VLSLC26 Statistics record latch manager: latch level 26 DB2NUMC10 NUMC 
263 DB2VLSLC27 Statistics record latch manager: latch level 27 DB2NUMC10 NUMC 
264 DB2VLSLC28 Statistics record latch manager: latch level 28 DB2NUMC10 NUMC 
265 DB2VLSLC29 Statistics record latch manager: latch level 29 DB2NUMC10 NUMC 
266 DB2VLSLC30 Statistics record latch manager: latch level 30 DB2NUMC10 NUMC 
267 DB2VLSLC31 Statistics record latch manager: latch level 31 DB2NUMC10 NUMC 
268 DB2VLSLC32 Statistics record latch manager: latch level 32 DB2NUMC10 NUMC 
269 DB2VLSLC99 Statistics record latch manager: latch level 19 DB2INT4 INT4 
270 DB2VLSLCS Statistics record latch manager: values per second DB2CHAR10 CHAR 
271 DB2VLSSC Suspension class DB2CHAR10 CHAR 
272 DB2VOLID Serial number of the volume CHAR6 CHAR 
273 DB2VPSHORT Number of Virtual Pool Shortages DB2DEC20V DEC 
274 DB2W013ID DB2/390: Unit of recovery ID DB2CHAR12 CHAR 
275 DB2W0148AI The status of the thread DB2CHAR16 CHAR 
276 DB2W0148CA The status of the thread DB2CHAR16 CHAR 
277 DB2W0148CR Number of Requests Sent to DB2 DB2NUMC05 NUMC 
278 DB2W0148RC Number of Requests Sent to DB2 DB2INT4 INT4 
279 DB2W0148RQ Number of Requests Sent to DB2 DB2INT4 INT4 
280 DB2W0148ST Indicates the status of the conversation or socket   CHAR 
281 DB2W0172IT DB2/390: Deadlock interval counter DB2NUMC10 NUMC 
282 DB2W0172NR Number of resources DB2NUMC10 NUMC 
283 DB2W0196CC Timeout intervals that can occur before agent is timed out DB2NUMC05 NUMC 
284 DB2W0196HW H=Holder, W = Waiter, and R = Retained DB2CHAR01 CHAR 
285 DB2W0196TC Timeout intervals that can occur before agent is timed out DB2INT4 INT4 
286 DB2W02542C Secondary group buffer pool: Changed pages DB2NUMC10 NUMC 
287 DB2W02542D Secondary group buffer pool: Directory entries allocated DB2NUMC10 NUMC 
288 DB2W02542F Secondary group buffer pool: Write-miss cache-full DB2NUMC10 NUMC 
289 DB2W02542T Secondary group buffer pool: Data entries allocated DB2NUMC10 NUMC 
290 DB2W02542W Secondary group buffer pool: Changed page write-hit DB2NUMC10 NUMC 
291 DB2W0254CC The number of castout operations performed. DB2NUMC10 NUMC 
292 DB2W0254CI Explicit cross invalidations DB2NUMC10 NUMC 
293 DB2W0254DE The number of allocated directory entries (not cumulative). DB2NUMC10 NUMC 
294 DB2W0254DR Directory entry reclaims DB2NUMC10 NUMC 
295 DB2W0254GC Group buffer pool name DB2CHAR08 CHAR 
296 DB2W0254GN The name of the group buffer pool DB2NUMC10 NUMC 
297 DB2W0254RD Read-miss directory-hit counter DB2NUMC10 NUMC 
298 DB2W0254RF Read-miss cache-full DB2NUMC10 NUMC 
299 DB2W0254RH Read hit DB2NUMC10 NUMC 
300 DB2W0254RN Read-miss name-assigned DB2NUMC10 NUMC 
301 DB2W0254RS Read-miss assignment-suppressed DB2NUMC10 NUMC 
302 DB2W0254TC Changed pages DB2NUMC10 NUMC 
303 DB2W0254TE # of allocated data entries (snapshot, not cumulative) DB2NUMC10 NUMC 
304 DB2W0254TR Data entry reclaims DB2NUMC10 NUMC 
305 DB2W0254WC Clean page write-hit DB2NUMC10 NUMC 
306 DB2W0254WF Write-miss cache-full DB2NUMC10 NUMC 
307 DB2W0254WH Changed page write-hit DB2NUMC10 NUMC 
308 DB2W0254XR Directory entry reclaims with XI DB2NUMC10 NUMC 
309 DB2W0317ID SQL STATEMENT IDENTIFIER   INT4 
310 DB2W0317LN THE LENGTH OF THE SQL STMT   INT4 
311 DB2W0317NM SQL STATEMENT NAM CHAR16 CHAR 
312 DB2W0317TX SQL statement text DB2C30K LCHR 
313 DB2W1TOBW Average duration of a synchronous I/O   CHAR 
314 DB2W225AL TOTAL AGENT LOCAL POOL STORAGE DB2INT4 INT4 
315 DB2W225ALG Total agent local storage (64-bit shared variable pools) DB2DEC19V DEC 
316 DB2W225AS TOTAL AGENT SYSTEM STORAGE DB2INT4 INT4 
317 DB2W225ASG Total system agent storage (64-bit shared variable pools) DB2DEC19V DEC 
318 DB2W225AT NUMBER OF ACTIVE ALLIED THREADS DB2INT4 INT4 
319 DB2W225AV AMOUNT OF AVAILABLE STORAGE DB2INT4 INT4 
320 DB2W225AX Number of auxiliary slots (4k) in use DB2DEC19V DEC 
321 DB2W225BB Total buffer manager storage blocks (31-bit DBM1) DB2DEC19V DEC 
322 DB2W225CD TOTAL STORAGE FOR COMPRESSION DICTIONARY DB2DEC19V DEC 
323 DB2W225CE NUMBER OF CASTOUT ENGINES DB2INT4 INT4 
324 DB2W225COMSTG_AUX # of real 4K aux slots in use for 64- bit common storage DB2DEC19V DEC 
325 DB2W225COMSTG_REAL # of real 4K frames in use for 64- bit common storage DB2DEC19V DEC 
326 DB2W225CR TOTAL STORAGE RESERVED FOR MUST-COMPLETE OPERATIONS DB2INT4 INT4 
327 DB2W225DW NUMBER OF DEFERRED WRITE ENGINES DB2INT4 INT4 
328 DB2W225FA private fixed pool storage DB2DEC19V DEC 
329 DB2W225FCG Total 64-bit common fixed pool storage DB2DEC19V DEC 
330 DB2W225FX TOTAL FIXED STORAGE DB2INT4 INT4 
331 DB2W225GA private getmained storage DB2DEC19V DEC 
332 DB2W225GCG Total 64-bit common getmained storage DB2DEC19V DEC 
333 DB2W225GM TOTAL GETMAINED STORAGE DB2INT4 INT4 
334 DB2W225GS TOTAL GETMAINED STACK STORAGE DB2INT4 INT4 
335 DB2W225GSG Total 64-bit shared non-system agent stack DB2DEC19V DEC 
336 DB2W225GSG_SYS Total 64-bit shared system agent stack DB2DEC19V DEC 
337 DB2W225GW NUMBER OF GBP WRITE ENGINES DB2INT4 INT4 
338 DB2W225H2 High water mark for alloc. stmt cache storage in 64-bit pool DB2DEC19V DEC 
339 DB2W225HVG_AUX_SLOTS High water mark for 4K aux. slots in use for 64-bit private DB2DEC19V DEC 
340 DB2W225HVG_PAGES_IN_REAL High water mark for # of real 4K frames in use for 64-bit DB2DEC19V DEC 
341 DB2W225HV_AUX_SLOTS Number of 4K auxiliary slots in use for 64-bit private DB2DEC19V DEC 
342 DB2W225HV_PAGES_IN_REAL Number of real 4K frames in use for 64-bit private DB2DEC19V DEC 
343 DB2W225L2 Allocated statement cache storage in 64-bit agent local pool DB2DEC19V DEC 
344 DB2W225MV TOTAL AMOUNT OF STORAGE FOR MVS USE DB2INT4 INT4 
345 DB2W225PF NUMBER OF PREFETCH ENGINES DB2INT4 INT4 
346 DB2W225PL NUMBER OF P-LOCK/NOTIFY EXIT ENGINES DB2INT4 INT4 
347 DB2W225PM TOTAL STORAGE FOR PIPE MANAGER SUBPOOL DB2INT4 INT4 
348 DB2W225PRISTG_AUX # of real 4 K aux slots in use for 64-bit priv. storage DB2DEC19V DEC 
349 DB2W225PRISTG_REAL # of real 4 K frames in use for 64-bit priv. storage DB2DEC19V DEC 
350 DB2W225RL Number of real frames (4K) in use DB2DEC19V DEC 
351 DB2W225RO TOTAL STORAGE FOR RDS OP POOL DB2INT4 INT4 
352 DB2W225RP TOTAL STORAGE FOR RID POOL DB2DEC19V DEC 
353 DB2W225S2 Total 64-bit STMT CACHE BLOCKS 2G storage DB2DEC19V DEC 
354 DB2W225SB TOTAL STORAGE FOR STATEMENT CACHE BLOCK DB2INT4 INT4 
355 DB2W225SC TOTAL STORAGE FOR THREAD COPIES OF CACHED SQL STATEMENTS DB2INT4 INT4 
356 DB2W225SF Total fixed shared 64-bit storage DB2DEC19V DEC 
357 DB2W225SG Total GETMAINed shared 64-bit storage DB2DEC19V DEC 
358 DB2W225SHRAUXSLOTS Number of auxiliary slots used for 64-bit shared storage DB2DEC19V DEC 
359 DB2W225SHRGBYTES High water mark for # of 64-bit shared bytes for this MVS L. DB2DEC19V DEC 
360 DB2W225SHRINREAL # of 64-bit shared pages backed in real storage (4K pages) DB2DEC19V DEC 
361 DB2W225SHRPAGEINS Number of 64-bit shared pages paged in from aux. storage DB2DEC19V DEC 
362 DB2W225SHRPAGEOUTS Number of 64-bit shared pages paged out to auxiliary storage DB2DEC19V DEC 
363 DB2W225SHRPAGES # of 64-bit shared memory pages alloc. for this MVS LPAR DB2DEC19V DEC 
364 DB2W225SHRSTG_AUX # of real 4 K aux slots in use for 64- bit shared storage DB2DEC19V DEC 
365 DB2W225SHRSTG_REAL # of real 4K frames in use for 64- bit shared storage DB2DEC19V DEC 
366 DB2W225SHRSTKSTG_AUX # of real 4K aux slots in use f 64- bit shared stack storage DB2DEC19V DEC 
367 DB2W225SHRSTKSTG_REAL # of real 4K frames in use for 64- bit shared stack storage DB2DEC19V DEC 
368 DB2W225SM Total 64-bit private storage f. stor. manager control struct DB2DEC19V DEC 
369 DB2W225SMC Total 64-bit common storage f.storage manager control struct DB2DEC19V DEC 
370 DB2W225SO STORAGE CUSHION WARNING TO CONTRACT DB2INT4 INT4 
371 DB2W225SU Total 31-bit stack storage in use DB2DEC19V DEC 
372 DB2W225SUG Total 64-bit shared non-system agent stack in use DB2DEC19V DEC 
373 DB2W225SUG_SYS Total 64-bit shared system agent stack in use DB2DEC19V DEC 
374 DB2W225SV Total variable shared 64-bit storage DB2DEC19V DEC 
375 DB2W225TT TOT. STOR. BUFFER MANAGER OR DATA MANAGER INT. TRACE TABLE DB2INT4 INT4 
376 DB2W225VA private variable pool storage DB2DEC19V DEC 
377 DB2W225VCG Total 64-bit common variable pool storage DB2DEC19V DEC 
378 DB2W225VR TOTAL VARIABLE STORAGE DB2INT4 INT4 
379 DB2W316TSD Date when statistics collection began DB2DATE DATS 
380 DB2W316TST Time when statistics collection began DB2TIME TIMS 
381 DB2WABRT Aborted transactions DB2INT4 INT4 
382 DB2WACABRT Total number of rollback requests DB2INT4 INT4 
383 DB2WACAJST The accumulated home CPU time a thread spent in DB2 DB2INT4 INT4 
384 DB2WACCABR Total number of rollback requests DB2NUMC10 NUMC 
385 DB2WACCAJS The accumulated home CPU time a thread spent in DB2 DB2NUMC10 NUMC 
386 DB2WACCCOM The number of successful phase 2 or single-phase commits DB2NUMC10 NUMC 
387 DB2WACCOMM The number of successful phase 2 or single-phase commits DB2INT4 INT4 
388 DB2WACLRAB Total number bytes of log records written DB2CHAR10 CHAR 
389 DB2WACLRN Number of log records written DB2NUMC10 NUMC 
390 DB2WBPAGID ASCII GBCS CCSID DB2NUMC10 NUMC 
391 DB2WCOMP Completed transactions DB2INT4 INT4 
392 DB2WDATE Start or end date DB2DATE DATS 
393 DB2WDELY Delay samples DB2INT4 INT4 
394 DB2WDURA Duration DB2INT4 INT4 
395 DB2WELAP Elapsed time DB2CHAR16 CHAR 
396 DB2WEXEC Execution time DB2CHAR16 CHAR 
397 DB2WFNPDMP Average Work Files Not Given per Degraded Merge Pass DB2DEC19V DEC 
398 DB2WFPMRGP Average Work Files per Merge Pass DB2DEC19V DEC 
399 DB2WFUNC Function name DB2CHAR08 CHAR 
400 DB2WGPER Goal percentile DB2CHAR10 CHAR 
401 DB2WGTYP Goal type DB2CHAR14 CHAR 
402 DB2WGVAL Goal value DB2INT4 INT4 
403 DB2WHCAID The authorization ID under which the transaction is running CHAR128 CHAR 
404 DB2WHCCAID The authorization ID under which the transaction is running DB2CHAR08 CHAR 
405 DB2WHCCCN The connection ID of the thread DB2CHAR08 CHAR 
406 DB2WHCCCV The correlation ID of the thread (IP address) DB2CHAR16 CHAR 
407 DB2WHCCN The connection ID of the thread DB2CHAR08 CHAR 
408 DB2WHCCPLA DB2 plan name DB2CHAR08 CHAR 
409 DB2WHCCV The correlation ID of the thread (IP address) DB2CHAR16 CHAR 
410 DB2WHCEUID The end user's work station user ID CHAR128 CHAR 
411 DB2WHCEUTX Transaction or application the end user is running CHAR32 CHAR 
412 DB2WHCEUWN The end user's workstation name CHAR18 CHAR 
413 DB2WHCPLAN DB2 plan name CHAR128 CHAR 
414 DB2WHICHPM Indicates which DB performance monitor is used DB2WHICHPM NUMC 
415 DB2WIMPT Importance INT2 INT2 
416 DB2WINTD Reporting interval duration DB2NUMC10 NUMC 
417 DB2WK1DEVT Device on which the SYSUT1 dataset resides DB2DEVT CHAR 
418 DB2WK1DSN Dataset allocated to the SYSUT1 DDNAME DB2DDN CHAR 
419 DB2WK1SPC Primary space allocation for the SYSUT1 dataset (cyl.) DB2DDPQTYC INT2 
420 DB2WK2DEVT Device on which the SORTOUT dataset resides DB2DEVT CHAR 
421 DB2WK2DSN Dataset allocated to the SORTOUT DDNAME DB2DDN CHAR 
422 DB2WK2SPC Primary space allocation for the SORTOUT dataset (cyl.) DB2DDPQTYC INT2 
423 DB2WMAPB Response time distribution bucket mapping DB2CHAR08 CHAR 
424 DB2WMAPN Response time distribution array entry DB2INT4 INT4 
425 DB2WMAXC Maximum capacity DB2CHAR10 CHAR 
426 DB2WMINC Minimum capacity DB2CHAR10 CHAR 
427 DB2WMINT MINTIME DB2INT4 INT4 
428 DB2WMODE WLM mode DB2CHAR13 CHAR 
429 DB2WP work process   CHAR 
430 DB2WP1AUDT The AUDIT TRACE classes started CHAR8 CHAR 
431 DB2WP1BDUR Restart backout limit DB2SINT INT2 
432 DB2WP1CAUD The AUDIT TRACE classes started DB2CHAR90 CHAR 
433 DB2WP1CBDU Restart backout limit DB2NUMC05 NUMC 
434 DB2WP1CCDB Maximum number of connected remote threads DB2NUMC10 NUMC 
435 DB2WP1CCRI Amount of space reserved for critical work DB2NUMC10 NUMC 
436 DB2WP1CCT The maximum number of concurrent allied threads DB2NUMC10 NUMC 
437 DB2WP1CDB Maximum number of connected remote threads DB2INT4 INT4 
438 DB2WP1CDB1 Amount of space reserved for MVS functions DB2NUMC10 NUMC 
439 DB2WP1CDBP Database protocol for 3-part names DB2CHAR08 CHAR 
440 DB2WP1CDFR Number of checkpoints   CHAR 
441 DB2WP1CDTI Time Interval Before DB2 Resets Data Set Statistics (Min.) DB2NUMC05 NUMC 
442 DB2WP1CEXB Maximum number of extra DRDA query blocks for DB2 requester DB2NUMC05 NUMC 
443 DB2WP1CEXS Maximum number of extra DRDA query blocks for DB2 server DB2NUMC05 NUMC 
444 DB2WP1CFLB Maximum DSN1DBM1 Storage for Fast Log Apply (MB) DB2NUMC10 NUMC 
445 DB2WP1CFRE Pseudo-close frequency DB2NUMC10 NUMC 
446 DB2WP1CIDB Maximum number of concurrent connections from batch job DB2NUMC10 NUMC 
447 DB2WP1CIDF Maximum number of concurrent TSO foreground connections DB2NUMC10 NUMC 
448 DB2WP1CIXP Default buffer pool for user indexspaces DB2BPNAME CHAR 
449 DB2WP1CLMB Whether DB2 Postpones Backward Log Processing During Restart DB2CHAR04L CHAR 
450 DB2WP1CLOG Number of log records written between checkpoints DB2NUMC10 NUMC 
451 DB2WP1CLVA Max. number of KB that a user can use to store lob values DB2NUMC10 NUMC 
452 DB2WP1CLVL Used to detect parameters and code that are out of sync DB2NUMC10 NUMC 
453 DB2WP1CLVS Max. number of MB a subsystem can use to store lob values DB2NUMC10 NUMC 
454 DB2WP1CMON Monitor tracing start options DB2CHAR09 CHAR 
455 DB2WP1CMOS Monitor Buffer Size (KB) DB2NUMC10 NUMC 
456 DB2WP1CPRO Indicates Whether Accounting Records Should Be Rolled Up DB2CHAR03L CHAR 
457 DB2WP1CRIT Amount of space reserved for critical work DB2INT4 INT4 
458 DB2WP1CRLA Authorization ID of the resource limit specification table DB2CHAR08 CHAR 
459 DB2WP1CRLF Resource limit facility automatic start DB2CHAR03L CHAR 
460 DB2WP1CRLN Resource limit specification table error action DB2NUMC10 NUMC 
461 DB2WP1CRLR FLAGS (ONE BYTE, USED AS BITS 1-8) DB2RAW01 RAW 
462 DB2WP1CRLT Resource limit specification table ID DB2CHAR04 CHAR 
463 DB2WP1CRMT Maximum number of database access threads DB2NUMC10 NUMC 
464 DB2WP1CSCE Extended security DB2CHAR04 CHAR 
465 DB2WP1CSMA The SMF ACCOUNTING TRACE Classes Started DB2CHAR90 CHAR 
466 DB2WP1CSMF The SMF STATISTICS TRACE Classes Started DB2CHAR90 CHAR 
467 DB2WP1CSMR The individual write-to-operator routing codes started   CHAR 
468 DB2WP1CSPA Number of abends allowed for a stored procedure DB2NUMC10 NUMC 
469 DB2WP1CSPP Name of JCL procedure used to start DB2 address space DB2CHAR10 CHAR 
470 DB2WP1CSPT Stored procedure timeout value DB2NUMC10 NUMC 
471 DB2WP1CSTI Time interval (in minutes) between statistics collection DB2NUMC10 NUMC 
472 DB2WP1CT The maximum number of concurrent allied threads DB2SINT INT2 
473 DB2WP1CTBP Default buffer pool for user tablespaces DB2BPNAME CHAR 
474 DB2WP1CTLS Size of the Local Trace Tables in Multiples of 4 KB DB2NUMC05 NUMC 
475 DB2WP1CTMR Pseudo-close time DB2NUMC10 NUMC 
476 DB2WP1CTRS Size of resident trace table (multiple of 4K) DB2NUMC10 NUMC 
477 DB2WP1CTRT The GLOBAL TRACE Classes Started DB2CHAR90 CHAR 
478 DB2WP1CURC UR Checkpoint Frequency DB2NUMC10 NUMC 
479 DB2WP1CWLM Default WLM environment for user-defined functions/stoprocs DB2CHAR18 CHAR 
480 DB2WP1DB1M Amount of space reserved for MVS functions DB2INT4 INT4 
481 DB2WP1DBPR Database protocol for 3-part names DB2CHAR08 CHAR 
482 DB2WP1DFRQ Number of checkpoints   CHAR 
483 DB2WP1DTIM Time Interval Before DB2 Resets Data Set Statistics (Min.) DB2SINT INT2 
484 DB2WP1EXBR Maximum number of extra DRDA query blocks for DB2 requester DB2SINT INT2 
485 DB2WP1EXBS Maximum number of extra DRDA query blocks for DB2 server DB2SINT INT2 
486 DB2WP1FLBZ Maximum DSN1DBM1 Storage for Fast Log Apply (MB) DB2SINT INT2 
487 DB2WP1FREQ Pseudo-close frequency DB2SINT INT2 
488 DB2WP1IDB Maximum number of concurrent connections from batch job DB2SINT INT2 
489 DB2WP1IDF Maximum number of concurrent TSO foreground connections DB2SINT INT2 
490 DB2WP1IXPL Default buffer pool for user indexspaces DB2BPNAME CHAR 
491 DB2WP1LMBO Whether DB2 postpones backward log processing during restart DB2CHAR04L CHAR 
492 DB2WP1LOGL Number of log records written between checkpoints DB2INT4 INT4 
493 DB2WP1LVA Max. number of KB that a user can use to store lob values DB2INT4 INT4 
494 DB2WP1LVL Used to detect parameters and code that are out of sync DB2SINT INT2 
495 DB2WP1LVS Max. number of MB a subsystem can use to store lob values DB2INT4 INT4 
496 DB2WP1LWCK Long URs detection (UR based) DB2INT4U INT4 
497 DB2WP1MON Monitor tracing start options DB2CHAR03L CHAR 
498 DB2WP1MONS Monitor Buffer Size (KB) DB2INT4 INT4 
499 DB2WP1MRC Bit map of MVS console routing codes DB2CHAR04 CHAR 
500 DB2WP1PROL Whether accounting records should be rolled up DB2CHAR03L CHAR