SAP ABAP Data Element - Index D, page 7
Data Element - D
# Data Element Short Description Domain Data Type
1 DB2QSTSTMT Statement text   CHAR 
2 DB2QSTSTNM DB2 statement name DB2RAW16 RAW 
3 DB2QSTTOKN Statement ID DB2INT4 INT4 
4 DB2QSTTSCN Number of tablespace scans performed for statement DB2DEC19V DEC 
5 DB2QSTUSE Current Copies DB2DEC19V DEC 
6 DB2QSTWRIT Synchronous Writes DB2DEC19V DEC 
7 DB2QTYUNIT Unit in which primary and secondary allocation are given DB2QTYUNIT CHAR 
8 DB2QTYUNIT9 Unit of primary and secondary allocation (Format CHAR9) CHAR9 CHAR 
9 DB2QUALNUM DB2 OS/390: Number to generate unique qual. for DB2 object NUM6 NUMC 
10 DB2QUATSIX Status if is a tablespace or an index DB2QUATSIX CHAR 
11 DB2QUERYACCEL Value for DB2 special register CURRENT QUERY ACCELERATION   CHAR 
12 DB2QVLSCPS Occurences in respective latch level per second DB2DEC10_2 DEC 
13 DB2QW316CT Accumulated CPU Time DB2DEC16 DEC 
14 DB2QW316L1 Length of program name INT2 INT2 
15 DB2QW316L2 Length of transaction name INT2 INT2 
16 DB2QW316L3 Length of user ID INT2 INT2 
17 DB2QW316LX Statement Line Number DB2INT4 INT4 
18 DB2QW316RS RID List Not Used due to Insufficient Storage DB2DEC19V DEC 
19 DB2QW316RT RID List Not Used due to DB2 Limits Exceeded DB2DEC19V DEC 
20 DB2QW316T1 Program name CHAR128 CHAR 
21 DB2QW316T2 Transaction name DB2CHAR32 CHAR 
22 DB2QW316T3 User ID CHAR128 CHAR 
23 DB2QW316TD Name of the table referenced in the statement CHAR128 CHAR 
24 DB2QW316TM2 Time when stmt was inserted into cache - stored clock format   CHAR 
25 DB2QW316TM2R Time when stmt was inserted into cache - stored clock format   RAW 
26 DB2QW316TS Timestamp: Begin of Statistics Collection DB2DEC16 DEC 
27 DB2QW316UI SAP provided identification of SQL statements CHAR128 CHAR 
28 DB2QW316UT1 Date/Time when stmt stat was updated -in stored clock format   CHAR 
29 DB2QW316UT1R Time when the stmt stat was updated - stored clock format   RAW 
30 DB2QW316UT2 Date/Time when the stmt stat was updated -in external format   CHAR 
31 DB2QW316UT2R Date/Time when the stmt stat was updated -in external format   RAW 
32 DB2QW316W1 Accumulated Wait Time for Synchronous I/O DB2DEC16 DEC 
33 DB2QW316W2 Accumulated Wait Time for Lock and Latch Req. DB2DEC16 DEC 
34 DB2QW316W3 Accumulated Wait Time for Sync. Execution Unit Switch DB2DEC16 DEC 
35 DB2QW316W4 Accumulated Wait Time for Global Locks DB2DEC16 DEC 
36 DB2QW316W5 Accumulated Wait Time for Read Activity by Another Thread DB2DEC16 DEC 
37 DB2QW316W6 Accumulated Wait Time for Write Activity by Another Thread DB2DEC16 DEC 
38 DB2QW316W7 Accumulated wait time for latch req   DEC 
39 DB2QW316W7C Accumulated wait time for latch req   CHAR 
40 DB2QW316W8 Accumulated wait time for page latch   DEC 
41 DB2QW316W8C Accumulated wait time for page latch   CHAR 
42 DB2QW316W9 Accumulated wait time for drain lock   DEC 
43 DB2QW316W9C Accumulated wait time for drain lock   CHAR 
44 DB2QW316WA Acc. wait for drain when waiting for claims to be released   DEC 
45 DB2QW316WAC Acc. wait for drain when waiting for claims to be released   CHAR 
46 DB2QW316WB Accumulated wait time for logwriter   DEC 
47 DB2QW316WBC Accumulated wait time for logwriter   CHAR 
48 DB2QW316X4 User group CHAR128 CHAR 
49 DB2QW316X5 The value of QUALIFIER bind option CHAR128 CHAR 
50 DB2QW316X6 ISOLATION DB2CHAR03 CHAR 
51 DB2QW316X7 CURRENTDATA DB2CHAR03 CHAR 
52 DB2QW316X8 DYNAMICRULES DB2CHAR04 CHAR 
53 DB2QW316X9 CURRENT DEGREE DB2CHAR03 CHAR 
54 DB2QW316XA CURRENT RULES DB2CHAR03 CHAR 
55 DB2QW316XB CURRENT PRECISION DB2CHAR05 CHAR 
56 DB2QW316XC WITH HOLD DB2CHAR03 CHAR 
57 DB2QW316XE ENDuser ID - Value provided on RRS (re)signon   CHAR 
58 DB2QW316XF Workstation name - Value provided on RRS (re)signon   CHAR 
59 DB2QW317NM Name of SQL statement (long text) DB2CHAR16 CHAR 
60 DB2QW31CT1 Accumulated CPU Time DB2INT4 INT4 
61 DB2QW31CT2 Accumulated CPU Time DB2INT4 INT4 
62 DB2QW31W11 Accumulated Wait Time for Synchronous I/O DB2INT4 INT4 
63 DB2QW31W12 Accumulated Wait Time for Synchronous I/O DB2INT4 INT4 
64 DB2QW31W1C Accumulated Wait Time for Synchronous I/O   CHAR 
65 DB2QW31W21 Accumulated Wait Time for Lock and Latch Req. DB2INT4 INT4 
66 DB2QW31W22 Accumulated Wait Time for Lock and Latch Req. DB2INT4 INT4 
67 DB2QW31W2C Accumulated Wait Time for Lock and Latch Req.   CHAR 
68 DB2QW31W31 Accumulated Wait Time for Sync. Execution Unit Switch DB2INT4 INT4 
69 DB2QW31W32 Accumulated Wait Time for Sync. Execution Unit Switch DB2INT4 INT4 
70 DB2QW31W3C Accumulated Wait Time for Sync. Execution Unit Switch   CHAR 
71 DB2QW31W41 Accumulated Wait Time for Global Locks DB2INT4 INT4 
72 DB2QW31W42 Accumulated Wait Time for Global Locks DB2INT4 INT4 
73 DB2QW31W4C Accumulated Wait Time for Global Locks   CHAR 
74 DB2QW31W51 Accumulated Wait Time for Read Activity by Another Thread DB2INT4 INT4 
75 DB2QW31W52 Accumulated Wait Time for Read Activity by Another Thread DB2INT4 INT4 
76 DB2QW31W5C Accumulated Wait Time for Read Activity by Another Thread   CHAR 
77 DB2QW31W61 Accumulated Wait Time for Write Activity by Another Thread DB2INT4 INT4 
78 DB2QW31W62 Accumulated Wait Time for Write Activity by Another Thread DB2INT4 INT4 
79 DB2QW31W6C Accumulated Wait Time for Write Activity by Another Thread   CHAR 
80 DB2QWP1CSO Amount of space above MVS and critical space DB2NUMC10 NUMC 
81 DB2QWP1IDB Maximum number of concurrent connections from batch jobs DB2NUMC10 NUMC 
82 DB2QWP1SOS Amount of space above MVS and critical space DB2INT4 INT4 
83 DB2R3FREET Total free space in the R/3 System (KB) DEC14 DEC 
84 DB2R3PCTU Percentage of used size to allocated size of the R/3 System DEC5 DEC 
85 DB2R3SIZT Total size allocated by the R/3 System (KB) DEC14 DEC 
86 DB2RACNAC Number of failures in adding an entry to authorization cache DB2INT4 INT4 
87 DB2RACOW1 Number of authorization ID overrides in authorization cache DB2INT4 INT4 
88 DB2RACOW2 Number of routine entry overrides in authorization cache DB2INT4 INT4 
89 DB2RACPUB Number of successful public authorization checks DB2INT4 INT4 
90 DB2RAETOEXECS Average elapsed time DB2DEC19V6 DEC 
91 DB2RAETOROWS Average elapsed time / row DB2DEC19V6 DEC 
92 DB2RANOT Number of authorization checks without authorization cache DB2INT4 INT4 
93 DB2RAW01 Field type raw, length 2, 1 byte DB2RAW01 RAW 
94 DB2RAW04 Field type raw, length 8, 4 bytes DB2INT4 INT4 
95 DB2RAW1 RFC - raw 1 DB2RAW1 RAW 
96 DB2RBAFORMAT RBA Format   CHAR 
97 DB2RBICRE Creator of the index that is to be rebuilt DB2CREATOR CHAR 
98 DB2RBIDB Database to which the tablespace belongs DB2DBNAME CHAR 
99 DB2RBIIX Name of the index to be rebuilt DB2IXNAME CHAR 
100 DB2RBIPART Partition of the index that is to be rebuilt DB2PARTNO INT2 
101 DB2RBITS Table space from which all indexes are to be rebuilt DB2TSNAME CHAR 
102 DB2RBIXFLD Index definitions for the REBUILD INDEX statement DB2RBIXFLD CHAR 
103 DB2RBIXFRQ Controls the collection of frequent value statistics DB2RBIXFRQ CHAR 
104 DB2RC1DEVT Device on which the SYSRCPY1 dataset resides DB2DEVT CHAR 
105 DB2RC1DSN Dataset allocated to the SYSRCPY1 DDNAME DB2DDN CHAR 
106 DB2RC1SPC Primary space allocation for the SYSRCPY1 dataset (cyl.) DB2DDPQTYC INT2 
107 DB2RC2DEVT Device on which the SYSRCPY2 dataset resides DB2DEVT CHAR 
108 DB2RC2DSN Dataset allocated to the SYSRCPY2 DDNAME DB2DDN CHAR 
109 DB2RC2FRST Whether copy2 archive logs are read first DB2CHAR03L CHAR 
110 DB2RC2SPC Primary space allocation for the SYSRCPY2 dataset (cyl.) DB2DDPQTYC INT2 
111 DB2RCH IFI DB Trace: Return Code DB2CHAR15 CHAR 
112 DB2RCTCONT Specifies that the recovery process is to continue DB2YNFLAG CHAR 
113 DB2RCTCOPY Recover to a particular image copy dataset DB2DDN CHAR 
114 DB2RCTDB Name of the database the tablespace belongs to DB2DBNAME CHAR 
115 DB2RCTDS Partition or dataset that is to be recovered CHAR3 CHAR 
116 DB2RCTERR ERROR RANGE option of the RECOVER TABLESPACE utility DB2YNFLAG CHAR 
117 DB2RCTLOGO LOGONLY option of the RECOVER TABLESPACE utility DB2YNFLAG CHAR 
118 DB2RCTLOGP Specifies a point on the log to recover to DB2LRSN RAW 
119 DB2RCTPG Specifies a particular page to be recovered   INT4 
120 DB2RCTRBA Point on the log to recover to DB2RBA RAW 
121 DB2RCTSEQ File sequence number of the image copy dataset NUMC10 NUMC 
122 DB2RCTSITE Site (local or recovery) from which the copies are used DB2RCTSITE CHAR 
123 DB2RCTTS Name of the tablespace to be recovered DB2TSNAME CHAR 
124 DB2RCTVOL Identifies the image copy dataset CHAR7 CHAR 
125 DB2READRAT Read rate per second DB2DEC20V DEC 
126 DB2READWRI Pages read vs. pages written   INT4 
127 DB2REALSTORBP Real storage in use for 64-bit - used by DB2 buffer pools DB2DEC19V DEC 
128 DB2REASON Reason running utility is recommended DB2REASON CHAR 
129 DB2RECCNT DB2INT4 INT4 
130 DB2RECDEVT Device on which the SYSREC dataset resides DB2DEVT CHAR 
131 DB2RECDSN Dataset allocated to the SYSREC DDNAME DB2DDN CHAR 
132 DB2RECLEN Maximum length (in bytes) of any record in the table   INT4 
133 DB2RECLENS Maximum length (in bytes) of any record in the table DB2SINT INT2 
134 DB2RECNCNT DB2INT4 INT4 
135 DB2RECSPC Primary space allocation for the SYSREC dataset (cylinders) DB2DDPQTYC INT2 
136 DB2REFDATE Last refresh date DATS DATS 
137 DB2REFTIME Last refresh time TIME TIMS 
138 DB2RELEASE DB2 release CHAR10 CHAR 
139 DB2REONEED State if a reorg is needed (Y/N) DB2REONEED CHAR 
140 DB2REPORT RUNSTATS parameter REPORT DB2REPORT CHAR 
141 DB2RES01 Field type char, length 1, reserved DB2CHAR01 CHAR 
142 DB2RES02 Field type char, length 2, reserved DB2CHAR02 CHAR 
143 DB2RES03 Field type char, length 3, reserved DB2CHAR03 CHAR 
144 DB2RES04 Field type char, length 4, reserved DB2CHAR04 CHAR 
145 DB2RES05 Field type char, length 5 (reserved) DB2CHAR05 CHAR 
146 DB2RES07 Field type char, length 7 (reserved) DB2CHAR07 CHAR 
147 DB2RES08 Field type char, length 8, reserved DB2CHAR08 CHAR 
148 DB2RESDATE Last reset date DATS DATS 
149 DB2RESTART Whether & at which point a current utility job is restarted DB2RESTART CHAR 
150 DB2RESTOKN hash and resource token   RAW 
151 DB2RESTYPE The type of resource held by a lock CHAR20 CHAR 
152 DB2RETOEXE Average rows examined(Only data rows are taken into account)   CHAR 
153 DB2RETOEXECS Average rows examined(Only data rows are taken into account) DB2DEC25V6 DEC 
154 DB2RETOPROW Examined/processed Rows (Only data rows are taken into acc.) DB2DEC21V2 DEC 
155 DB2RETOPRW Examined/Processed Rows (Only data rows are taken into acc.)   CHAR 
156 DB2RETRY DB2INT4 INT4 
157 DB2REUSE Specified if DB2-managed dataset DB2REUSE CHAR 
158 DB2RFCDES RFC destination for alert router DB2CHAR04 CHAR 
159 DB2RFCPASS RFC password DB2CHAR22 CHAR 
160 DB2RFCTROF Switch RFC trace off FLAG CHAR 
161 DB2RFCTRON Switch RFC trace on FLAG CHAR 
162 DB2RFCUSR DB2/390: RFC user for alert router DB2CHAR12 CHAR 
163 DB2RHSTID DB2INT4 INT4 
164 DB2RIDFAIL RID list failures   CHAR 
165 DB2RIXCRE Creator of the index to be reorganized DB2CREATOR CHAR 
166 DB2RIXIX Name of the index to be reorganized DB2IXNAME CHAR 
167 DB2RLFERRD Resource limit facility error parameter DB2CHAR15 CHAR 
168 DB2RNBTONE Average synchronous reads   CHAR 
169 DB2RNDHITR Random hit ratio DB2DECPCT DEC 
170 DB2RNGTONE Average getpages   CHAR 
171 DB2RNITONE Average index scans   CHAR 
172 DB2RNLTONE Average parallel groups   CHAR 
173 DB2RNSTONE Average sorts   CHAR 
174 DB2RNTTONE Average tablespace scans   CHAR 
175 DB2RNWTONE Average synchronous writes   CHAR 
176 DB2ROWFORMAT Row Format   CHAR 
177 DB2RPRERAT Reprepare Ratio   CHAR 
178 DB2RPTOEXE Average rows processed   CHAR 
179 DB2RPTOEXECS Average rows processed DB2DEC25V6 DEC 
180 DB2RPTOREX Ratio: Rows processed to rows examined of statement   CHAR 
181 DB2RRSTONE Average RID failures - no storage   CHAR 
182 DB2RRTTONE Average RID failures - limit   CHAR 
183 DB2RSSTID DB2INT4 INT4 
184 DB2RSTCNT COUNT parameter of the RUNSTATS utility DB2SINT INT2 
185 DB2RSTCOL Column for which information is to be gathered DB2COLNAME CHAR 
186 DB2RSTDB Name of the database to which the table space belongs DB2DBNAME CHAR 
187 DB2RSTIX Index for which information is to be gathered DB2FIXNAME CHAR 
188 DB2RSTKEY KEYCARD option of the RUNSTATS utility DB2YNFLAG CHAR 
189 DB2RSTNCOL NUMCOLS parameter of the RUNSTATS utility DB2SINT INT2 
190 DB2RSTPART Table space partition on which RUNSTATS is to be run DB2PARTNO INT2 
191 DB2RSTREP REPORT option of the RUNSTATS utility DB2YESNO CHAR 
192 DB2RSTSAMP Percentage of rows to sample for RUNSTATS DB2SINT INT2 
193 DB2RSTSHR RUNSTATS share level DB2SHRLVL CHAR 
194 DB2RSTTB Table for which column information is to be gathered DB2TBNAMEF CHAR 
195 DB2RSTTS Table space on which RUNSTATS is to be run DB2TSNAME CHAR 
196 DB2RSTUPD UPDATE option of the RUNSTATS utility CHAR10 CHAR 
197 DB2RSWF Conditional / Unconditional DB2RAW1 RAW 
198 DB2RTSDB Name of the database to which the tablespace belongs DB2DBNAME CHAR 
199 DB2RTSDEAD DEADLINE parameter of the REORG utility DB2TMSTMP CHAR 
200 DB2RTSDLAY DELAY parameter of the REORG utility CHAR10 CHAR 
201 DB2RTSKDIC KEEPDICTIONARY option of the REORG TABLESPACE utility DB2YNFLAG CHAR 
202 DB2RTSLLOG LONGLOG parameter of the REORG utility CHAR8 CHAR 
203 DB2RTSLOG LOG option of the REORG TABLESPACE utility DB2YESNO CHAR 
204 DB2RTSMAP Name of the mapping table DB2TBNAME CHAR 
205 DB2RTSMAPC Creator of the mapping table DB2CREATOR CHAR 
206 DB2RTSMRO MAXRO parameter of the REORG utility CHAR10 CHAR 
207 DB2RTSNSYS NOSYSREC option of the REORG TABLESPACE utility DB2YNFLAG CHAR 
208 DB2RTSPART Number of the partition to be reorganized DB2PARTNO INT2 
209 DB2RTSPREF PREFORMAT option of the REORG utility DB2YNFLAG CHAR 
210 DB2RTSSHR SHRLEVEL parameter of the REORG utility DB2SHRLVL CHAR 
211 DB2RTSSKEY SORTKEYS option of the REORG TABLESPACE utility DB2YNFLAG CHAR 
212 DB2RTSSORT SORTDATA option of the REORG TABLESPACE utility DB2YNFLAG CHAR 
213 DB2RTSTBSIZE Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB FLTP FLTP 
214 DB2RTSTOTALENTRY DB2/zOS: Real-Time Statistics index TOTALENTRIES FLTP FLTP 
215 DB2RTSTOTALROWS DB2/zOS: Real-Time Statistics tablespace TOTALROWS FLTP FLTP 
216 DB2RTSTS Name of the tablespace that is to be reorganized DB2TSNAME CHAR 
217 DB2RTSUNLD UNLOAD parameter of the REORG utility CHAR8 CHAR 
218 DB2RUNFDIX Index definition for RUNSTATS TABLESPACE statement DB2RUNFDIX CHAR 
219 DB2RUNFDTS Table definition for RUNSTATS TABLESPACE statement DB2RUNFDTS CHAR 
220 DB2RWSTID DB2INT4 INT4 
221 DB2SAMPMOD DB2 sample mode CHAR30 CHAR 
222 DB2SAPRL SAP release DB2CHAR04 CHAR 
223 DB2SCALE Scale of decimal data DB2SINT INT2 
224 DB2SDATE DB2 database start date DB2DATE DATS 
225 DB2SECQTY DB2/390: Secondary quantity DB2SECQTY NUMC 
226 DB2SEGSIZE Number of pages in a segment of a segmented tablespace DB2SINT INT2 
227 DB2SELHICH HIGH value of character field selection screen CHAR255 CHAR 
228 DB2SELHIDB HIGH value of database selection screen CHAR8 CHAR 
229 DB2SELHITB HIGH value of table selection screen CHAR18 CHAR 
230 DB2SELHITS HIGH value of tablespace selection screen CHAR8 CHAR 
231 DB2SELLOCH LOW value of character field selection screen CHAR255 CHAR 
232 DB2SELLODB LOW value of database selection screen CHAR8 CHAR 
233 DB2SELLOTB LOW value of table selection screen CHAR18 CHAR 
234 DB2SELLOTS LOW value of tablespace selection screen CHAR8 CHAR 
235 DB2SELOPT Selection operator of a selection screen DB2CHAR02 CHAR 
236 DB2SELSIGN SIGN flag of selection screen DB2CHAR01 CHAR 
237 DB2SEQNO DB2INT4 INT4 
238 DB2SEVERITY severity   CHAR 
239 DB2SHPREP Number of Short Prepares DB2DEC19V DEC 
240 DB2SHRLVL RUNSTATS parameter SHRLEVEL DB2SHRLVL1 CHAR 
241 DB2SINT Small integer (2 bytes) DB2INT2V INT2 
242 DB2SIOSGT Sync. seq. reads / seq. getpages DB2DEC19V6 DEC 
243 DB2SIZE DB2 for OS/390: Size category of the table (small, large) DB2CHAR06L CHAR 
244 DB2SIZEK DB2 for OS/390 size of a dataset in KBytes DB2SIZEK DEC 
245 DB2SIZEKB Size in KB   DEC 
246 DB2SIZEMB Size in MB   DEC 
247 DB2SLSTP Percent of time spent in DB2 for SYSLGRNX recording DB2CHAR10 CHAR 
248 DB2SMPINT Sample interval DB2NUMC10 NUMC 
249 DB2SMS_OBJTYP sms object type   CHAR 
250 DB2SORTCOL Name of sort column   CHAR 
251 DB2SORTKEY Specifies that index keys are to be sorted DB2SORTKEY CHAR 
252 DB2SPACCEU The unit used in allocating archive data sets CHAR10 CHAR 
253 DB2SPACE Number of KB of DASD Storage Allocated to Tablespace DB2SPACE INT4 
254 DB2SPACETYPE Type of tablespace or indexspace e.g. RPUTS, PBG, SEGM   CHAR 
255 DB2SPACEUN The unit used in allocating archive datasets CHAR10 CHAR 
256 DB2SPELAP Total elapsed time spent in stored procedures DB2CHAR16 CHAR 
257 DB2SP_MSG message returned by Stored Procedure   CHAR 
258 DB2SQTY Secondary space allocation   INT4 
259 DB2SRTDEVT Device type for temporary datasets allocated by DFSORT DB2DEVT CHAR 
260 DB2SRTNUM Number of temporary datasets allocated by DFSORT   INT4 
261 DB2SRVTP Percent of time in DB2 for commit, abort, deallocate DB2CHAR10 CHAR 
262 DB2SSIZE Number of pages in each segment of a segmented tablespace DB2SSIZE INT2 
263 DB2SSPIN Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit) DB2CHAR10 CHAR 
264 DB2SSRBT SRB time for system service address space DB2CHAR16 CHAR 
265 DB2SSTCONT Storage contractions DB2NUMC10 NUMC 
266 DB2STATS Availability status of tablespace DB2STATS CHAR 
267 DB2STATSTM Date and time of last RUNSTATS DB2TMSTMP CHAR 
268 DB2STATTXT Status DB2CHAR18 CHAR 
269 DB2STCAET1 accumulated elapsed time used DB2INT4 INT4 
270 DB2STCAET2 accumulated elapsed time used (2) DB2INT4 INT4 
271 DB2STCBT TCB time for system service address space DB2CHAR16 CHAR 
272 DB2STCCOPY number of copies of the stm DB2INT4 INT4 
273 DB2STCEROW number of rows examined DB2INT4 INT4 
274 DB2STCEXEC number of executions of stmt DB2INT4 INT4 
275 DB2STCGPAG number of getpage operations DB2INT4 INT4 
276 DB2STCINDX number of index scans performed for statement DB2INT4 INT4 
277 DB2STCISTM time statement was inserted CHAR10 CHAR 
278 DB2STCPLGP Number of parallel groups DB2INT4 INT4 
279 DB2STCRBUF number of synchronous buffer DB2INT4 INT4 
280 DB2STCRES1 xxx CHAR1 CHAR 
281 DB2STCSORT number of sorts performed for statement DB2INT4 INT4 
282 DB2STCSTAT status of the statement CHAR1 CHAR 
283 DB2STCSTLN entire SQL stmt text length INT2 INT2 
284 DB2STCSTMT first 60 bytes of a stmt text CHAR60 CHAR 
285 DB2STCSTNM statement name generated by db2 for this statement CHAR16 CHAR 
286 DB2STCTOKN unique statement identifier identifying a statement DB2INT4 INT4 
287 DB2STCTSCN number of tablespace scans DB2INT4 INT4 
288 DB2STCUSE number of current users of stmt DB2INT4 INT4 
289 DB2STCWRIT number of buffer write DB2INT4 INT4 
290 DB2STIME DB2 database start time DB2TIME TIMS 
291 DB2STMTYPE The current SQL statement type being executed by the thread DB2CHAR22 CHAR 
292 DB2STODATE Date when the storage information has been collected DATUM DATS 
293 DB2STOGROUP Storage group   CHAR 
294 DB2STOGRP Name of the storage group used for space allocation CHAR8 CHAR 
295 DB2STOPRA Average duration: stored procedures DB2CHAR10 CHAR 
296 DB2STOPRO Stored procedures DB2CHAR10 CHAR 
297 DB2STORECLOCK data in store_clock format (DEC 16)   DEC 
298 DB2STOTIME Time when the storage information has been collected TIME TIMS 
299 DB2STOTT Total time for system service address space DB2CHAR16 CHAR 
300 DB2STRING String   STRG 
301 DB2SUBKEY DB2 z/OS: subkey of an object   CHAR 
302 DB2SUCNT DB2/OS390: Unique counter INT2 INT2 
303 DB2SUMEXTS Total number of extents of a TS or index (parts summed up)   INT4 
304 DB2SUMSIZE dataelement for summation of DEC19 values   DEC 
305 DB2SUSPDB2 Time spent suspended in DB2 / Time spent in DB2 (%) DB2TIMEP CHAR 
306 DB2SWD Lock duration of the thread holding the resource DB2CHAR12 CHAR 
307 DB2SWPACMD Alter Bufferpool/Alter Group Bufferpool commands are issued DB2CHAR05 CHAR 
308 DB2SWPAPG Maximum active pages across all the active buffer pools CHAR8 CHAR 
309 DB2SWPAPGN Buffer pool with maximum active pages DB2BPNAME CHAR 
310 DB2SWPATDT Date when sampling is taken DB2DATE DATS 
311 DB2SWPATTF Time when sampling was taken DB2TIME TIMS 
312 DB2SWPATTM Time when sampling is taken DB2TIME TIMS 
313 DB2SWPBPNA Selected buffer pool DB2BPNAME CHAR 
314 DB2SWPBWRA Output log buffer writes per active log control interval DB2CHAR10 CHAR 
315 DB2SWPCACM Alter Bufferpool/Alter Group Bufferpool commands are issued DB2CHAR05 CHAR 
316 DB2SWPCAP Maximum active pages across all the active buffer pools CHAR8 CHAR 
317 DB2SWPCAPG Buffer pool with maximum active pages DB2BPNAME CHAR 
318 DB2SWPCATD Date when sampling is taken DB2DATE DATS 
319 DB2SWPCATT Time when sampling is taken DB2TIME TIMS 
320 DB2SWPCBPN Selected buffer pool DB2BPNAME CHAR 
321 DB2SWPCBWR Output log buffer writes per active log control interval DB2CHAR10 CHAR 
322 DB2SWPCCOD Percentage of currently open datasets DB2DEC4_1 DEC 
323 DB2SWPCCOM Number of COMMITs DB2NUMC10 NUMC 
324 DB2SWPCCPN No. of checkpoints DB2NUMC10 NUMC 
325 DB2SWPCCTR Cursor table section requests/CT section not in EDM pool DB2CHAR10 CHAR 
326 DB2SWPCDBD Database descriptor requests/DB descriptors not in EDM pool DB2CHAR10 CHAR 
327 DB2SWPCDEF Datasets closed because deferred close threshold is reached DB2CHAR05 CHAR 
328 DB2SWPCDLC No. of deadlocks DB2NUMC10 NUMC 
329 DB2SWPCDSI No. of datasets currently in use DB2NUMC10 NUMC 
330 DB2SWPCEPF Total no. of failures due to EDM pool being full DB2NUMC10 NUMC 
331 DB2SWPCHPC Hiper pool concerns for any of the active buffer pools DB2CHAR05 CHAR 
332 DB2SWPCHPN Buffer pool with hiperpool concerns DB2BPNAME CHAR 
333 DB2SWPCHR Minimum hit ratio across all active buffer pools DB2DEC5_2 DEC 
334 DB2SWPCHRT Buffer pool with minimum hit ratio DB2BPNAME CHAR 
335 DB2SWPCLGR Number of Control Intervals Created for Active Log per Sec. DB2CHAR10 CHAR 
336 DB2SWPCLGW No. of log write waits DB2NUMC10 NUMC 
337 DB2SWPCLOG No. of log reads that had to access archive log datasets DB2NUMC10 NUMC 
338 DB2SWPCLRT Time of last reset DB2TIME TIMS 
339 DB2SWPCODS Percentage of currently open datasets   CHAR 
340 DB2SWPCOMM The number of commits DB2DEC10V DEC 
341 DB2SWPCPGI Percentage of EDM pool pages currently in use DB2CHAR05 CHAR 
342 DB2SWPCPNT No. of checkpoints DB2INT4 INT4 
343 DB2SWPCPRE Degree of parallelism lower than planned DB2CHAR05 CHAR 
344 DB2SWPCPTR Package table section requests/PT section not in EDM pool DB2CHAR10 CHAR 
345 DB2SWPCRID One of RID list limits is reached DB2CHAR05 CHAR 
346 DB2SWPCROL Number of ROLLBACKs DB2NUMC10 NUMC 
347 DB2SWPCSHN Buffer pool with buffer pool shortage DB2BPNAME CHAR 
348 DB2SWPCSHT Buffer pool shortage in any of the active buffer pools DB2CHAR05 CHAR 
349 DB2SWPCSSI DB2 subsystem ID DB2CHAR04 CHAR 
350 DB2SWPCSTR Start Trace command was issued DB2CHAR05 CHAR 
351 DB2SWPCSUS No. of suspensions (all kinds) DB2NUMC10 NUMC 
352 DB2SWPCTDC Total no. of Data Control Language statements DB2NUMC10 NUMC 
353 DB2SWPCTDD Total no. of Data Definition Language statements DB2NUMC10 NUMC 
354 DB2SWPCTDM Total no. of Data Manipulation Language statements DB2NUMC10 NUMC 
355 DB2SWPCTIM Number of timeouts DB2NUMC10 NUMC 
356 DB2SWPCTR (CT requests - CT not in EDM pool) / CT requests DB2CHAR10 CHAR 
357 DB2SWPDBDR (DBD requests - DBD not in EDM pool) / DBD requests DB2CHAR10 CHAR 
358 DB2SWPDEFC Datasets closed because deferred close threshold is reached DB2CHAR05 CHAR 
359 DB2SWPDLCK No. of deadlocks DB2INT4 INT4 
360 DB2SWPDSIU Number of datasets currently in use DB2NUMC10 NUMC 
361 DB2SWPEPFL Total number of failures due to EDM pool being full DB2INT4 INT4 
362 DB2SWPHPC Hiper pool concerns for any of the active buffer pools DB2CHAR05 CHAR 
363 DB2SWPHPCN Buffer pool which has hiperpool concerns DB2BPNAME CHAR 
364 DB2SWPHRT Minimum hit ratio across all active buffer pools DB2DEC5_2 DEC 
365 DB2SWPHRTN Buffer pool which has the minimum hit ratio DB2BPNAME CHAR 
366 DB2SWPLGWR Number of bytes in KB written for active log per sec DB2CHAR10 CHAR 
367 DB2SWPLGWW Number of log write waits DB2NUMC10 NUMC 
368 DB2SWPLOGR The number of log reads which had to access archive log DSs DB2NUMC10 NUMC 
369 DB2SWPLRTM Time of last reset DB2TIME TIMS 
370 DB2SWPPGIU Percentage of EDM pool pages currently in use   CHAR 
371 DB2SWPPRED Degree of parallelism lower than planned DB2CHAR05 CHAR 
372 DB2SWPPTR (PT requests - PT not in EDM pool) / PT requests DB2CHAR10 CHAR 
373 DB2SWPRIDL Any of the RID list limits is reached DB2CHAR05 CHAR 
374 DB2SWPROLL Number of rollbacks DB2INT4 INT4 
375 DB2SWPSHT Buffer pool shortage in any of the active buffer pools DB2CHAR05 CHAR 
376 DB2SWPSHTN Buffer pool which has a buffer pool shortage DB2BPNAME CHAR 
377 DB2SWPSSID DB2 subsystem ID DB2CHAR04 CHAR 
378 DB2SWPSTRC Start Trace command was issued DB2CHAR05 CHAR 
379 DB2SWPSUSP Number of suspensions of all kinds DB2DEC10V DEC 
380 DB2SWPTDCL Total number of Data Control Language statements DB2DEC21V DEC 
381 DB2SWPTDDL Total number of Data Definition Language statements DB2DEC21V DEC 
382 DB2SWPTDML Total number of Data Manipulation Language statements DB2DEC21V DEC 
383 DB2SWPTIME Number of timeouts DB2INT4 INT4 
384 DB2SWRTRATE Sync writes / ( sync writes + async writes) DB2DECPCT DEC 
385 DB2SWU IRLM function request (LOCK, UNLOCK, or CHANGE) DB2CHAR06 CHAR 
386 DB2SYNASYN CHAR1 CHAR 
387 DB2SYNCIO Synchronous I/O per minute (pages) DB2DEC10_2 DEC 
388 DB2SYNRRAT Number of synchronous reads per second DB2CHAR10 CHAR 
389 DB2SYNRRND Number of Random Access Synchronous Reads DB2DEC20V DEC 
390 DB2SYSIDS Concatenation of SAP system IDs in an DB2 subsystem   CHAR 
391 DB2SYSLOG_ORIGIN Z/OS Syslog entry source ID - JOB, CONSOLE or multiline DB2CHAR08 CHAR 
392 DB2SYSLOG_RAWLINE Z/OS syslog raw line   CHAR 
393 DB2SYSLOG_RTCODE Z/OS syslog routing Code DB2CHAR07 CHAR 
394 DB2SYSLOG_USRFLAGS Z/OS Syslog user flags DB2CHAR08 CHAR 
395 DB2SYSNR System number DB2CHAR03 CHAR 
396 DB2SYSTYPE DB2 system type   CHAR 
397 DB2T3BPID Buffer pool ID of the locked resource DB2CHAR08 CHAR 
398 DB2T3COLL Name of the package collection DB2CHAR18 CHAR 
399 DB2T3CONST Consistency token of the package DB2CHAR19 CHAR 
400 DB2T3DBNAM Name of the database DB2CHAR08 CHAR 
401 DB2T3DURAT Duration of a lock DB2CHAR16 CHAR 
402 DB2T3FUNCT IRLM function request DB2CHAR16 CHAR 
403 DB2T3HASH Hash class number of the group database exception upd. lock DB2NUMC08 NUMC 
404 DB2T3LOCKS No. of locks held and susp. on the database/obj. combination DB2NUMC05 NUMC 
405 DB2T3OBNAM Name of the object associated with the database DB2CHAR18 CHAR 
406 DB2T3PACK Package identifier DB2CHAR08 CHAR 
407 DB2T3PAGE Page number of the locked resource DB2NUMC09 NUMC 
408 DB2T3PART Partition of the locked resource DB2NUMC05 NUMC 
409 DB2T3PLLCK Indicates the kind of lock for the resource DB2CHAR06 CHAR 
410 DB2T3RMID RMID of the group databases exception update lock DB2CHAR08 CHAR 
411 DB2T3ROW Record ID within the page of the locked resource DB2NUMC05 NUMC 
412 DB2T3STATE State of the lock held on the resource DB2CHAR03 CHAR 
413 DB2T3SUBP Subpage number of the index page lock DB2NUMC05 NUMC 
414 DB2T3SUSP Whether the thread is suspended waiting for a lock DB2CHAR09 CHAR 
415 DB2T3TYPE Type of lock held on a resource DB2CHAR08 CHAR 
416 DB2TABCAT DB2 for OS/390: Table category DB2TABCAT CHAR 
417 DB2TABNAMD Table name CHAR18 CHAR 
418 DB2TABNAME DB2 table name CHAR18 CHAR 
419 DB2TABNAML DB2 long table name   CHAR 
420 DB2TABNAMM DB2 medium table name   CHAR 
421 DB2TABNAMX DB2 extended table name   STRG 
422 DB2TABRT Number of rollback requests DB2INT4 INT4 
423 DB2TABRTC Number of rollback requests DB2INT4 INT4 
424 DB2TABSIZD Reserved storage space of a table in KBytes DEC11 DEC 
425 DB2TABSIZE DB2 for OS/390: Table size ( pages * reclength / 1024 ) DEC12 DEC 
426 DB2TABTYP Type of DB2 table DB2TABTYP CHAR 
427 DB2TABTYPE Table: Type of object   CHAR 
428 DB2TARCCC Archive read suspension time DB2DEC16 DEC 
429 DB2TARCHCC Archive log quiesce suspension time DB2DEC16 DEC 
430 DB2TARCHQ Archive log quiesce suspension time DB2CHAR16 CHAR 
431 DB2TARCHQA Average duration of ARCHIVE LOG QUIESCE suspensions DB2CHAR10 CHAR 
432 DB2TARCHQC Number of archive log quiesce suspensions DB2INT4 INT4 
433 DB2TARCHQE Number of ARCHIVE LOG QUIESCE suspensions DB2NUMC10 NUMC 
434 DB2TARCHR Archive read suspension time DB2CHAR16 CHAR 
435 DB2TARCHRA Average duration of archive read suspensions DB2CHAR10 CHAR 
436 DB2TARCHRC Number of Archive Read Suspensions DB2INT4 INT4 
437 DB2TARCHRE Number of archive read suspensions DB2NUMC10 NUMC 
438 DB2TBAVGROWLEN Average row length of table   INT4 
439 DB2TBCREA Authorization ID of the owner of the table CHAR8 CHAR 
440 DB2TBCREAT Authorization id of the owner of the table DB2TBCREAT CHAR 
441 DB2TBKXXA Number of extents after a new extent has been created DB2NUMC05 NUMC 
442 DB2TBKXXB Number of extents before a new extent has been created DB2NUMC05 NUMC 
443 DB2TBKXXM Maximum number of extents DB2NUMC05 NUMC 
444 DB2TBLALL Parameter if TABLE ALL should used for a RUNSTATS DB2TBLALL CHAR 
445 DB2TBLXHA High allocated after extent, 4KB DB2NUMC10 NUMC 
446 DB2TBLXTD DB2 for OS/390: Flag for updating DB02 extent monitor DB2CHAR05 CHAR 
447 DB2TBLXVA Number of volumes after a new extent has been created DB2NUMC05 NUMC 
448 DB2TBLXVB Number of volumes before extent has been created DB2NUMC05 NUMC 
449 DB2TBLXVM Maximum volumes DB2NUMC05 NUMC 
450 DB2TBMISDB Number of tables missing in the database DEC08 DEC 
451 DB2TBMISDD Number of tables missing in the ABAP/4 dictionary DEC08 DEC 
452 DB2TBNAME Name of the table on which the index is defined CHAR18 CHAR 
453 DB2TBNUM Number of tables in the R/3 system DEC08 DEC 
454 DB2TBSIZE Size of the table in KB DEC13 DEC 
455 DB2TBSIZT Total size of all R/3 tables (used storage in KB) DEC13 DEC 
456 DB2TBSPACEF Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table FLTP FLTP 
457 DB2TBSTATU Status of the table DB2TBSTATU CHAR 
458 DB2TBTOTALROWS Real Time Statistics: Number of rows in Table FLTP FLTP 
459 DB2TBTYPE Type of object DB2TBTYPE CHAR 
460 DB2TBXTHH DB2 for OS/390: High threshold for extent filtering DB2NUMC05 NUMC 
461 DB2TBXTHR DB2 for OS/390: Low threshold for extent filtering DB2NUMC05 NUMC 
462 DB2TCATDES Table category description DB2CHAR44 CHAR 
463 DB2TCLRECC Claim release suspension time DB2DEC16 DEC 
464 DB2TCLREL Claim release suspension time DB2CHAR16 CHAR 
465 DB2TCLRELA Average duration of claim release suspensions DB2CHAR10 CHAR 
466 DB2TCLRELC Number of Claim Release Suspensions DB2INT4 INT4 
467 DB2TCLRELE Number of claim release suspensions DB2NUMC10 NUMC 
468 DB2TCOMM Number of successful phase 2 or single-phase commit requests DB2INT4 INT4 
469 DB2TCOMMC Number of successful phase 2 or single-phase commit requests DB2INT4 INT4 
470 DB2TCPUIN CPU time spent in DB2 DB2CHAR16 CHAR 
471 DB2TCPUINA Average CPU time spent in DB2 DB2CHAR16 CHAR 
472 DB2TCPUINC CPU time spent in DB2 DB2DEC16 DEC 
473 DB2TCPUTOC Total System z CPU time including DB2 DB2DEC16 DEC 
474 DB2TCPUTOT Total CPU time on System z including DB2 DB2CHAR16 CHAR 
475 DB2TDACTEL Total elapsed activity time DB2CHAR16 CHAR 
476 DB2TDRLK Drain lock suspension time DB2CHAR16 CHAR 
477 DB2TDRLKA Average duration of drain lock suspensions DB2CHAR10 CHAR 
478 DB2TDRLKC Drain lock suspension time DB2DEC16 DEC 
479 DB2TDRLKE Number of drain lock suspensions DB2NUMC10 NUMC 
480 DB2TDRLKEC Number of Drain Lock Suspensions DB2INT4 INT4 
481 DB2TDSDRN Number of datasets that were closed via the DRAIN process DB2INT4U INT4 
482 DB2TDSOPN Number of datasets open concurrently DB2INT4U INT4 
483 DB2TDSPICA Average CPU processing between stored procedure entry/exit DB2CHAR16 CHAR 
484 DB2TDSPINA Average stored procedure entry/exit duration DB2CHAR16 CHAR 
485 DB2TDSPINE Total elapsed time spent executing SQL in stored procedures DB2CHAR16 CHAR 
486 DB2TDSST Wait time for data set extend/delete/define service task DB2CHAR16 CHAR 
487 DB2TDSSTA Average waiting time for dataset ext./del./def. service task DB2CHAR10 CHAR 
488 DB2TDSSTC Wait time for data set extend/delete/define service task DB2DEC16 DEC 
489 DB2TDSSTE Number of waits for data set ext./del./def. service task DB2NUMC10 NUMC 
490 DB2TDSSTEC Number of waits for data set ext./del./def. service task DB2INT4 INT4 
491 DB2TEEDASC DB2 entry/exit duration elapsed time DB2CHAR10 CHAR 
492 DB2TEEDJST DB2 entry/exit duration processing (CPU) DB2CHAR10 CHAR 
493 DB2TEEDPEB Stored procedure entry/exit duration elapsed time DB2CHAR10 CHAR 
494 DB2TEEDPTT Stored procedure entry/exit duration processing (CPU) DB2CHAR10 CHAR 
495 DB2TFCCONR False Contention Rate DB2CHAR10 CHAR 
496 DB2TFCONRA False contention rate DB2CHAR10 CHAR 
497 DB2TGCCONR Global Contention Rate DB2CHAR10 CHAR 
498 DB2TGCONRA Global contention rate DB2CHAR10 CHAR 
499 DB2TGLOBCC Global locking suspension time DB2DEC16 DEC 
500 DB2TGLOBTA Average duration of global locking suspensions DB2CHAR10 CHAR