SAP ABAP Data Element - Index D, page 9
Data Element - D
# Data Element Short Description Domain Data Type
1 DB2WP1RLF Resource limit facility automatic start DB2CHAR03L CHAR 
2 DB2WP1RLFA Authorization ID of the resource limit specification table CHAR128 CHAR 
3 DB2WP1RLFN Resource limit specification table error action   CHAR 
4 DB2WP1RLFR FLAGS (ONE BYTE, USED AS BITS 1-8) DB2RAW01 RAW 
5 DB2WP1RLFT Resource limit specification table ID DB2CHAR04 CHAR 
6 DB2WP1RMT Maximum number of database access threads DB2SINT INT2 
7 DB2WP1SCER Extended security DB2CHAR04 CHAR 
8 DB2WP1SMFA The SMF ACCOUNTING TRACE Classes Started DB2CHAR03L CHAR 
9 DB2WP1SMFS The SMF STATISTICS TRACE Classes Started DB2CHAR03L CHAR 
10 DB2WP1SMRC The individual write-to-operator routing codes started   CHAR 
11 DB2WP1SPAB Number of abends allowed for a stored procedure DB2SINT INT2 
12 DB2WP1SPPN Name of JCL procedure used to start DB2 address space DB2CHAR10 CHAR 
13 DB2WP1SPTO Stored procedure timeout value DB2SINT INT2 
14 DB2WP1STIM Time interval (in minutes) between statistics collection DB2SINT INT2 
15 DB2WP1SYNO Statistics synchronization CHAR8 CHAR 
16 DB2WP1TBPL Default buffer pool for 4 KB tablespaces DB2BPNAME CHAR 
17 DB2WP1TIM Installation parameter statistics time DB2NUMC10 NUMC 
18 DB2WP1TLSZ Size of the Local Trace Tables in Multiples of 4 KB DB2SINT INT2 
19 DB2WP1TMR Pseudo-close time DB2SINT INT2 
20 DB2WP1TRST The GLOBAL TRACE Classes Started DB2CHAR03L CHAR 
21 DB2WP1TRSZ Size of resident trace table (multiple of 4K) DB2SINT INT2 
22 DB2WP1URCK UR Checkpoint Frequency DB2SINT INT2 
23 DB2WP1WLME Default WLM environment for user-defined functions/stoprocs DB2CHAR18 CHAR 
24 DB2WP2ADL The number of archive log copies CHAR10 CHAR 
25 DB2WP2ARCL Maximum number of archive log datasets DB2INT4 INT4 
26 DB2WP2CADL The Number of Archive Log Copies CHAR10 CHAR 
27 DB2WP2CARC Maximum number of archive log datasets DB2NUMC10 NUMC 
28 DB2WP2CDUA Number of Active Log Copies CHAR10 CHAR 
29 DB2WP2CIBP Log input buffer pool size (in kilobytes) DB2NUMC10 NUMC 
30 DB2WP2CMRT Maximum number of tape units for archive read DB2NUMC10 NUMC 
31 DB2WP2COBP Log Output Buffer Pool Size (MB) DB2NUMC10 NUMC 
32 DB2WP2COPT Active log and BSDS initialization options CHAR20 CHAR 
33 DB2WP2CWRT Write threshold on filled buffers DB2NUMC10 NUMC 
34 DB2WP2DMS Tape volume deallocation period   CHAR 
35 DB2WP2DUAL Number of active log copies CHAR10 CHAR 
36 DB2WP2IBPS Log input buffer pool size (in kilobytes) DB2INT4 INT4 
37 DB2WP2MRTU Maximum number of tape units for archive read DB2SINT INT2 
38 DB2WP2OBPS Log Output Buffer Pool Size (MB) DB2INT4 INT4 
39 DB2WP2OPT1 Active log and BSDS initialization options CHAR20 CHAR 
40 DB2WP2WRTH Write threshold on filled buffers DB2SINT INT2 
41 DB2WP3ALCU The unit used in allocating archive datasets DB2CHAR10L CHAR 
42 DB2WP3BKSZ The block size of the archive log data sets DB2INT4 INT4 
43 DB2WP3CALC The unit used in allocating archive data sets DB2CHAR10L CHAR 
44 DB2WP3CBKS The block size of the archive log data sets DB2NUMC10 NUMC 
45 DB2WP3CCOM Force Data Compaction DB2CHAR03L CHAR 
46 DB2WP3CCTL Whether the archive datasets are cataloged in the IFC   CHAR 
47 DB2WP3CDTI Indicates whether a timestamp is inserted in log datasets DB2CHAR03L CHAR 
48 DB2WP3CMQP Maximum time for DB2 to attempt a full system quiesce DB2NUMC10 NUMC 
49 DB2WP3CMS2 Archive copy 2 mass storage group name DB2CHAR10L CHAR 
50 DB2WP3CMSV Archive copy 1 mass storage group name DB2CHAR10L CHAR 
51 DB2WP3COMP Force data compaction DB2CHAR03L CHAR 
52 DB2WP3CRE1 DSN prefix character string for copy-1 archive log data set CHAR20 CHAR 
53 DB2WP3CREN DSN prefix character string for copy-2 archive log data set CHAR20 CHAR 
54 DB2WP3CRET Number of days the archive log data sets are to be retained DB2NUMC10 NUMC 
55 DB2WP3CRIS Primary space allocation DB2NUMC10 NUMC 
56 DB2WP3CRTC Archive Logs RACF Protection DB2CHAR03L CHAR 
57 DB2WP3CSEC Secondary space allocation DB2NUMC10 NUMC 
58 DB2WP3CTLG Whether the archive datasets are cataloged in the IFC   CHAR 
59 DB2WP3CUN2 The type of device for COPY2 archive logs CHAR10 CHAR 
60 DB2WP3CUNI Device type to which the archive log sets are written CHAR10 CHAR 
61 DB2WP3CUNT The type of device for COPY1 archive logs CHAR10 CHAR 
62 DB2WP3CWTO Issue WTOR Before Archive Mounts DB2CHAR03L CHAR 
63 DB2WP3DTFM Extended timestamp indicator DB2CHAR03L CHAR 
64 DB2WP3DTIM Indicates whether a timestamp is inserted in log datasets DB2CHAR03L CHAR 
65 DB2WP3MOP Max. time permitted for DB2 to attempt a full system quiesce NUMC10 NUMC 
66 DB2WP3MQP Maximum time for DB2 to attempt a full system quiesce DB2SINT INT2 
67 DB2WP3MSV1 Mass storage system volume group 1 name DB2CHAR10L CHAR 
68 DB2WP3MSV2 Mass storage system volume group 2 name DB2CHAR10L CHAR 
69 DB2WP3RE1N DSN prefix character string for copy-1 archive log dataset CHAR20 CHAR 
70 DB2WP3RE2N DSN prefix character string for copy-2 archive log dataset CHAR20 CHAR 
71 DB2WP3RETN Number of days the archive log data sets are to be retained DB2SINT INT2 
72 DB2WP3RISP Primary space allocation DB2INT4 INT4 
73 DB2WP3RTCT Archive logs RACF protection DB2CHAR03L CHAR 
74 DB2WP3SECS Secondary space allocation DB2INT4 INT4 
75 DB2WP3UNIT Device type to which the archive log sets are written CHAR10 CHAR 
76 DB2WP3UNT1 The type of device for COPY1 archive logs CHAR10 CHAR 
77 DB2WP3UNT2 The type of device for COPY2 archive logs CHAR10 CHAR 
78 DB2WP3WTOR Issue WTOR before archive mounts DB2CHAR03L CHAR 
79 DB2WP4ABN Indicates whether autobind operations are allowed DB2CHAR03L CHAR 
80 DB2WP4ABX Whether explain is allowed during autobind DB2CHAR03L CHAR 
81 DB2WP4ADM2 The authorization ID of the system administrator 2 CHAR128 CHAR 
82 DB2WP4AUCA Indicates the size of the authorization cache NUMC10 NUMC 
83 DB2WP4AUTH DB2 authorization DB2CHAR08L CHAR 
84 DB2WP4BNVA Indicates the authorities required to add a new package CHAR10 CHAR 
85 DB2WP4CCDY Cache prepared dynamic SQL statements DB2CHAR03L CHAR 
86 DB2WP4CDC Whether change data capture is enabled DB2CHAR03L CHAR 
87 DB2WP4CDEG Default parallelism degree DB2CHAR03 CHAR 
88 DB2WP4CDYN Cache prepared dynamic SQL statements DB2CHAR03L CHAR 
89 DB2WP4CONT Storage contraction DB2CHAR03L CHAR 
90 DB2WP4COOR Whether a DB2 subsystem can be a parallelism coordinator DB2CHAR08 CHAR 
91 DB2WP4CTHR Storage Contraction Threshold (Commits) DB2SINT INT2 
92 DB2WP4DCFS SMS Dataclass for tablespaces DB2CHAR08 CHAR 
93 DB2WP4DCIX SMS Dataclass for indexspaces DB2CHAR08 CHAR 
94 DB2WP4DDN Asynchronous drain start DB2SINT INT2 
95 DB2WP4DFID The authorization ID of the system default user CHAR128 CHAR 
96 DB2WP4DIV3 Minimum divide scale DB2CHAR03L CHAR 
97 DB2WP4DSMX Maximum number of concurrently open datasets NUMC10 NUMC 
98 DB2WP4DSPM Maximum locks per table(space) before escalation DB2SINT INT2 
99 DB2WP4DSST If an SQLDA for describe is built during bind for static SQL DB2CHAR03L CHAR 
100 DB2WP4DXTP Default index type DB2NUMC1 NUMC 
101 DB2WP4EBF Always use EDM Best Fit Algorithm DB2CHAR09 CHAR 
102 DB2WP4EDDS EDM Pool Data Space Size (MB) DB2INT4 INT4 
103 DB2WP4EDM DB2 for OS/390: EDM Pool Algorithm DB2CHAR10 CHAR 
104 DB2WP4EDMX Max EDM Pool data space size (MB) DB2INT4U INT4 
105 DB2WP4EDPL Maximum Size of the EDM Pool (MB) DB2INT4 INT4 
106 DB2WP4ENF Whether DPROP is supported DB2CHAR03L CHAR 
107 DB2WP4ESC The data definition escape character for ART and ORT search CHAR4 CHAR 
108 DB2WP4FLBS Max. log buffer size per job for fast log apply (10^6 bytes) DB2NUMC05 NUMC 
109 DB2WP4FLMT Maximum number of tasks per job for fast log apply DB2NUMC05 NUMC 
110 DB2WP4HINT Whether access path hints are allowed DB2CHAR03L CHAR 
111 DB2WP4HOP Hop site authorization DB2CHAR10 CHAR 
112 DB2WP4IAU Indicates whether IRLM is started automatically by DB2 CHAR4 CHAR 
113 DB2WP4IAUT Autostart of IRLM CHAR4 CHAR 
114 DB2WP4INTE Real-time statistics interval DB2INT4U INT4 
115 DB2WP4IPRC Name of IRLM procedure which DB2 uses to start IRLM CHAR8 CHAR 
116 DB2WP4ISID Name of the IRLM subsystem by which IRLM is known to MVS CHAR4 CHAR 
117 DB2WP4ISWT Seconds DB2 will wait for IRLM start DB2INT4 INT4 
118 DB2WP4LEM Max. no. of language environment tokens active at any time DB2SINT INT2 
119 DB2WP4LKTS Maximum number of locks per tablespace DB2INT4 INT4 
120 DB2WP4LKUS Maximum number of locks per user DB2INT4 INT4 
121 DB2WP4MDDN Asynchronous drain stop DB2SINT INT2 
122 DB2WP4MDEG Upper limit on the degree of parallelism DB2INT4 INT4 
123 DB2WP4MXKD Maximum number of prepared dynamic statements DB2INT4 INT4 
124 DB2WP4MXTB Maximum joined tables DB2INT4U INT4 
125 DB2WP4NLG Active log disabled DB2CHAR8 CHAR 
126 DB2WP4NPAG NPAGES threshold for index scan DB2INT4U INT4 
127 DB2WP4OJEH Outer join performance enhancement DB2CHAR03L CHAR 
128 DB2WP4OPR1 The authorization ID of the system operator 1 CHAR128 CHAR 
129 DB2WP4OPR2 The authorization ID of the system operator 2 CHAR128 CHAR 
130 DB2WP4OPTP Optimizer index prefetch enhancement CHAR8 CHAR 
131 DB2WP4PAC Package authorization cache DB2INT4 INT4 
132 DB2WP4PKYU Allow partitioning key update DB2CHAR8 CHAR 
133 DB2WP4PST Utility cache option DB2CHAR03L CHAR 
134 DB2WP4RAC Routine authorization cache size DB2INT4 INT4 
135 DB2WP4RCHL If page or row locks for held cursors are released at commit DB2CHAR03L CHAR 
136 DB2WP4REGA Name of the application registration table CHAR128 CHAR 
137 DB2WP4REGC Owner of the application registration table CHAR128 CHAR 
138 DB2WP4REGD Whether only registered packages or plans can use DDL DB2CHAR03L CHAR 
139 DB2WP4REGI Whether data definition control support is to be used DB2CHAR03L CHAR 
140 DB2WP4REGN Name of the database containing the registration tables CHAR8 CHAR 
141 DB2WP4REGO The name of the object registration table CHAR17 CHAR 
142 DB2WP4REGQ Whether two-part names are required for objects reg. in ORT DB2CHAR03L CHAR 
143 DB2WP4REGU Unregistered DDL default DB2CHAR10L CHAR 
144 DB2WP4REGX The name of the object registration table CHAR128 CHAR 
145 DB2WP4RMAX Maximum size of RID pool in the DB2 subsystem NUMC10 NUMC 
146 DB2WP4RRU UPDATE lock for repeatable read or read stability DB2CHAR03L CHAR 
147 DB2WP4RVDPR REVOKE dependent privileges   CHAR 
148 DB2WP4SADM The authorization ID of the system administrator 1 CHAR128 CHAR 
149 DB2WP4SCAC Sequential mode to read cached data from a 3990 controller   CHAR 
150 DB2WP4SECA1 Security Admin 1   CHAR 
151 DB2WP4SECA1_TYPE Security Administrator 1 Type   CHAR 
152 DB2WP4SECA2 Security Admin 2   CHAR 
153 DB2WP4SECA2_TYPE Security Administrator 2 Type   CHAR 
154 DB2WP4SEPSD Separate security duties   CHAR 
155 DB2WP4SIT Indicates whether the site is local or remote DB2CHAR10L CHAR 
156 DB2WP4SJRC DB2 for OS/390: Star Join controls   CHAR 
157 DB2WP4SJRT DB2 for OS/390: Star Join controls   CHAR 
158 DB2WP4SJTB Minimum star join tables DB2INT4U INT4 
159 DB2WP4SPOL Maximum Size of the Sort Pool (MB) DB2INT4 INT4 
160 DB2WP4STHR Storage Contraction Threshold (MB) DB2INT4 INT4 
161 DB2WP4STHT Statistics history default CHAR20 CHAR 
162 DB2WP4STRL Statistics rollup default CHAR8 CHAR 
163 DB2WP4TDDN Asynchronous drain start DB2NUMC10 NUMC 
164 DB2WP4TOUT Maximum time DB2 waits for the release of a locked resource DB2INT4 INT4 
165 DB2WP4TXS Agent local pool extension size (bytes) DB2NUMC10 NUMC 
166 DB2WP4UMD Maximum degree of utility parallelism DB2SINT INT2 
167 DB2WP4URNM REORG FASTSWITCH CHAR8 CHAR 
168 DB2WP4UTO Utility timeout factor DB2SINT INT2 
169 DB2WP4VCFK VARCHAR from index DB2CHAR03L CHAR 
170 DB2WP4VUN Evaluate uncommitted CHAR8 CHAR 
171 DB2WP4WAIT Multiplier for Determining Retained Lock Timeout DB2SINT INT2 
172 DB2WP4XLUC Flag if X lock is used for searched update or delete DB2CHAR03L CHAR 
173 DB2WP4XLUD Whether X lock is used for searched update or delete DB2CHAR06L CHAR 
174 DB2WP5DCYC Deadlock cycle DB2SINT INT2 
175 DB2WP5DLOK Deadlock time (seconds) DB2SINT INT2 
176 DB2WP5MCSA DB2INT4 INT4 
177 DB2WP5PCY IRLM cross memory enabled DB2CHAR03L CHAR 
178 DB2WP5TVAL Actual resource timeout DB2INT4 INT4 
179 DB2WP6CATN High qualifier name for all DB2 system datasets CHAR8 CHAR 
180 DB2WP7STR Start database indicator DB2CHAR10 CHAR 
181 DB2WP8DBNM Name of database to be automatically started CHAR10 CHAR 
182 DB2WP8SPNM Tablespace name or indexspace name CHAR10 CHAR 
183 DB2WP9CMST Status of a DBAT CHAR10 CHAR 
184 DB2WP9MAX1 Maximum type 1 inactive threads allowed by DB2 DB2INT4 INT4 
185 DB2WP9RLER Resource limit facility error parameter DB2CHAR10L CHAR 
186 DB2WP9RLFN Specifies the Limit in CPU Time Service Units DB2INT4 INT4 
187 DB2WP9RYC Number of minutes between two resynchronization intervals DB2SINT INT2 
188 DB2WP9STRT The startup option for the distributed data facility (DDF) CHAR14 CHAR 
189 DB2WP9TCPA Whether verified conn. are accepted from TCP/IP clients DB2CHAR03L CHAR 
190 DB2WP9TTO Idle thread timeout DB2SINT INT2 
191 DB2WPAASST Indicates whether this DB2 can assist parallel processing DB2CHAR08 CHAR 
192 DB2WPACOOR Whether a DB2 subsystem can be a parallelism coordinator DB2CHAR08 CHAR 
193 DB2WPAGRPN Name of a DB2 data sharing group CHAR10 CHAR 
194 DB2WPAIMMW Immediate writes for GBPs DB2CHAR8 CHAR 
195 DB2WPAIOPT Whether data sharing function is used or not CHAR6 CHAR 
196 DB2WPAMAXM Maximum Number of Members DB2INT4 INT4 
197 DB2WPAMBRN Name of a new or existing DB2 data sharing member CHAR10 CHAR 
198 DB2WPAPSC Application encoding scheme CHAR30 CHAR 
199 DB2WPASUCV CPU Service Unit Conversion Factor DB2INT4 INT4 
200 DB2WPBAGID ASCII GBCS CCSID DB2INT4 INT4 
201 DB2WPBAMID The ASCII mixed coded character set ID   INT4 
202 DB2WPBAR Indicates the rules of precision for a decimal field DB2CHAR10L CHAR 
203 DB2WPBASID The ASCII single-byte coded character set ID   INT4 
204 DB2WPBCHAR The default character set, which can be ALPHANUM or KATAKANA CHAR8 CHAR 
205 DB2WPBDATE The default output format for dates CHAR10 CHAR 
206 DB2WPBDE Whether the decimal contains a comma (,) or a period (.) DB2CHAR08L CHAR 
207 DB2WPBDEL Default delimiter DB2CHAR10L CHAR 
208 DB2WPBDLEN Local date length DB2SINT INT2 
209 DB2WPBDRUL Whether DSNHDECP values are used for dynamic SQL statements DB2CHAR03L CHAR 
210 DB2WPBDSD Distributed SQL string delimiter DB2CHAR10L CHAR 
211 DB2WPBENS The default encoding scheme, which can be ASCII or EBCDIC. CHAR8 CHAR 
212 DB2WPBGID The EBCDIC graphic coded character set ID   INT4 
213 DB2WPBGRA Default mixed graphic DB2CHAR03L CHAR 
214 DB2WPBLANG The default programming language for your site CHAR8 CHAR 
215 DB2WPBLCTP Default locale LC_CTYPE DB2CHAR50L CHAR 
216 DB2WPBMID The EBCDIC mixed coded character set ID   INT4 
217 DB2WPBSDL The string delimiter for SQL DB2CHAR10L CHAR 
218 DB2WPBSID The EBCDIC single-byte coded character set ID   INT4 
219 DB2WPBSQL SQL language support level DB2CHAR03L CHAR 
220 DB2WPBTIME The default output format for times CHAR10 CHAR 
221 DB2WPBTLEN Local time length DB2SINT INT2 
222 DB2WPCID Work process ID DB2NUMC10 NUMC 
223 DB2WPCNUM Work process number DB2NUMC10 NUMC 
224 DB2WPCTYE Corresponding R/3 work process type DB2CHAR05 CHAR 
225 DB2WPERN Number of service class periods INT2 INT2 
226 DB2WPID Work process ID DB2NUMC10 NUMC 
227 DB2WPIDI Work process ID DB2CHAR2 CHAR 
228 DB2WPIDS Work process ID DB2CHAR30 CHAR 
229 DB2WPIDX Performance index DB2CHAR10 CHAR 
230 DB2WPMSTG Thread Storage Algorithm DB2CHAR09 CHAR 
231 DB2WPNUM Work process number DB2NUMC10 NUMC 
232 DB2WPOLA Adminitrator name DB2CHAR08 CHAR 
233 DB2WPOLD Service policy description DB2CHAR32 CHAR 
234 DB2WPOLN Policy name DB2CHAR08 CHAR 
235 DB2WPTYE Corresponding R/3 work process type DB2CHAR05 CHAR 
236 DB2WPTYPE work process type   CHAR 
237 DB2WQ0124 SQL TEXT DB2C4000 LCHR 
238 DB2WQW0225SV Total 64-bit shared variable pool storage DB2DEC19V DEC 
239 DB2WRESP Average response time DB2CHAR10 CHAR 
240 DB2WRGNM Resource group name DB2CHAR08 CHAR 
241 DB2WRITRAT Write rate = ( Synchronous + async. writes ) / interval DB2DEC20V DEC 
242 DB2WSAAID Address space ID (ASID) of the address space DB2NUMC10 NUMC 
243 DB2WSAEJST Accumulated job step timer (TCB) value for address space DB2CHAR16 CHAR 
244 DB2WSAPROC Address space DB2CHAR10 CHAR 
245 DB2WSASRBT Accumulated SRB timer value for address space DB2CHAR16 CHAR 
246 DB2WSCDE Service class description DB2CHAR32 CHAR 
247 DB2WSCNM Service class name DB2CHAR08 CHAR 
248 DB2WSDCKPT Number of checkpoints DB2 has taken since startup DB2INT4 INT4 
249 DB2WSDSCA Count of IFI abends DB2NUMC10 NUMC 
250 DB2WSDSCCO Count of IFI command requests DB2NUMC10 NUMC 
251 DB2WSDSCRA Count of IFI READA requests DB2NUMC10 NUMC 
252 DB2WSDSCRS Count of IFI READS requests DB2NUMC10 NUMC 
253 DB2WSDSCU Count of IFI unrecognized functions. DB2NUMC10 NUMC 
254 DB2WSDSCWR Count of IFI WRITE requests DB2NUMC10 NUMC 
255 DB2WSPDU Service class period duration DB2INT4 INT4 
256 DB2WSSTY Subsystem type DB2CHAR04 CHAR 
257 DB2WSYSN System name DB2CHAR08 CHAR 
258 DB2WTIME Start or end time DB2TIME TIMS 
259 DB2WTPNM Transaction program name DB2CHAR08 CHAR 
260 DB2WUSID User ID DB2CHAR08 CHAR 
261 DB2WUSNG Using samples DB2INT4 INT4 
262 DB2WVELO Velocity DB2CHAR03 CHAR 
263 DB2WWLNM Workload name DB2CHAR08 CHAR 
264 DB2XALDAB Number of ALTER DATABASE statements executed DB2DEC19V DEC 
265 DB2XALOCC # of ALLOCATE CURSOR statements executed DB2DEC19V DEC 
266 DB2XALOCL # of ASSOCIATE LOCATOR statements executed DB2DEC19V DEC 
267 DB2XALPRO Number of ALTER PROCEDURE statements DB2DEC19V DEC 
268 DB2XALTCTX alter trusted context DB2DEC19V DEC 
269 DB2XALTIX Number of ALTER INDEX statements executed DB2DEC19V DEC 
270 DB2XALTJR alter jar DB2DEC19V DEC 
271 DB2XALTST Number of ALTER STORAGE GROUP statements executed DB2DEC19V DEC 
272 DB2XALTTA Number of ALTER TABLE statements executed DB2DEC19V DEC 
273 DB2XALTTS Number of ALTER TABLE SPACE statements executed DB2DEC19V DEC 
274 DB2XALUDF Number of ALTER FUNCTION statements DB2DEC19V DEC 
275 DB2XCALL Number of SQL CALL statements executed DB2DEC19V DEC 
276 DB2XCALLAB # of times a stored procedure ABENDed DB2DEC19V DEC 
277 DB2XCALLRJ # of times an SQL CALL statement was rejected DB2DEC19V DEC 
278 DB2XCALLTO # of times an SQL CALL stmt timedout waiting to be scheduled DB2DEC19V DEC 
279 DB2XCASCDP Maximum level of nested SQL cascading DB2DEC19V DEC 
280 DB2XCAUD Number of user-defined functions executed DB2DEC19V DEC 
281 DB2XCAUDAB Number of times a user-defined function abended DB2DEC19V DEC 
282 DB2XCAUDRJ Number of times a user-defined function was rejected DB2DEC19V DEC 
283 DB2XCAUDTO No. of times a user-defined funct. timed out before sched. DB2DEC19V DEC 
284 DB2XCDIST Number of CREATE DISTINCT TYPE statements DB2DEC19V DEC 
285 DB2XCLOSE Number of CLOSE CURSOR statements executed DB2DEC19V DEC 
286 DB2XCMTON Number of COMMENT ON statements executed DB2DEC19V DEC 
287 DB2XCON1 Number of CONNECT TYPE 1 statements executed DB2DEC19V DEC 
288 DB2XCON2 Number of CONNECT TYPE 2 statements executed DB2DEC19V DEC 
289 DB2XCOORNO COORDINATOR setting mismatch DB2DEC19V DEC 
290 DB2XCRALS Number of CREATE ALIAS statements executed DB2DEC19V DEC 
291 DB2XCRATB Number of CREATE AUXILIARY TABLE statements DB2DEC19V DEC 
292 DB2XCRCTX create trusted context DB2DEC19V DEC 
293 DB2XCRDAB Number of CREATE DATABASE statements executed DB2DEC19V DEC 
294 DB2XCRGTT # OF CREATE GLBL TEMP TABLE DB2DEC19V DEC 
295 DB2XCRINX Number of CREATE INDEX statements executed DB2DEC19V DEC 
296 DB2XCRPRO Number of CREATE PROCEDURE statements DB2DEC19V DEC 
297 DB2XCRROL create role DB2DEC19V DEC 
298 DB2XCRSTG Number of CREATE STORAGE GROUP statements executed DB2DEC19V DEC 
299 DB2XCRSYN Number of CREATE SYNONYM statements executed DB2DEC19V DEC 
300 DB2XCRTAB Number of CREATE TABLE statements executed DB2DEC19V DEC 
301 DB2XCRUDF Number of CREATE FUNCTION statements DB2DEC19V DEC 
302 DB2XCTABS Number of CREATE TABLE SPACE statements executed DB2DEC19V DEC 
303 DB2XCTRIG Number of SQL CREATE TRIGGER statements DB2DEC19V DEC 
304 DB2XDDIST Number of DROP DISTINCT TYPE statements DB2DEC19V DEC 
305 DB2XDEFVU Number of CREATE VIEW statements executed DB2DEC19V DEC 
306 DB2XDEGBUF Parallel groups fell to sequential due to storage shortage DB2DEC19V DEC 
307 DB2XDEGCUR Parallel groups fell to sequential due to updatable cursor DB2DEC19V DEC 
308 DB2XDEGENC Par.groups fell to sequ. due to unavailable enclave services DB2DEC19V DEC 
309 DB2XDEGESA Par. groups fell to sequ. due to lack of ESA sort support DB2DEC19V DEC 
310 DB2XDELET Number of DELETE statements executed DB2DEC19V DEC 
311 DB2XDESC Number of DESCRIBE statements executed DB2DEC19V DEC 
312 DB2XDRPAL Number of DROP ALIAS statements executed DB2DEC19V DEC 
313 DB2XDRPCTX drop trusted context DB2DEC19V DEC 
314 DB2XDRPDB Number of DROP DATABASE statements executed DB2DEC19V DEC 
315 DB2XDRPFN Number of DROP UDF statements DB2DEC19V DEC 
316 DB2XDRPIX Number of DROP INDEX statements executed DB2DEC19V DEC 
317 DB2XDRPPKG Number of DROP PACKAGE statements executed DB2DEC19V DEC 
318 DB2XDRPPR Number of DROP PROCEDURE statements DB2DEC19V DEC 
319 DB2XDRPROL drop role DB2DEC19V DEC 
320 DB2XDRPST Number of DROP STORAGE GROUP statements executed DB2DEC19V DEC 
321 DB2XDRPSY Number of DROP SYNONYM statements executed DB2DEC19V DEC 
322 DB2XDRPTA Number of DROP TABLE statements executed DB2DEC19V DEC 
323 DB2XDRPTR Number of SQL DROP TRIGGER statements DB2DEC19V DEC 
324 DB2XDRPTS Number of DROP TABLE SPACE statements executed DB2DEC19V DEC 
325 DB2XDRPVU Number of DROP VIEW statements executed DB2DEC19V DEC 
326 DB2XDSCRTB Number of DESCRIBE TABLE statements executed DB2DEC19V DEC 
327 DB2XFETCH Number of FETCH statements executed DB2DEC19V DEC 
328 DB2XFREEL Number of FREE LOCATOR statements DB2DEC19V DEC 
329 DB2XGRANT Number of GRANT statements executed DB2DEC19V DEC 
330 DB2XHOLDL Number of HOLD LOCATOR statements DB2DEC19V DEC 
331 DB2XINCRB Number of INCREMENTAL BINDs executed DB2DEC19V DEC 
332 DB2XINSRT Number of INSERT statements executed DB2DEC19V DEC 
333 DB2XISORR Isolation level RR or RS DB2DEC19V DEC 
334 DB2XLABON Number of LABEL ON statements executed DB2DEC19V DEC 
335 DB2XLOCK Number of LOCK TABLE statements executed DB2DEC19V DEC 
336 DB2XMAXDEG Maximum parallelism degree DB2DEC19V DEC 
337 DB2XMERGE # of times merge sql statement was executed DB2DEC19V DEC 
338 DB2XMEXTOL Number of extents before last ALTER SECQTY   INT4 
339 DB2XMEXTOS Number of extents before last ALTER SECQTY INT2 INT2 
340 DB2XMIAP Number of times RID list processing is used DB2DEC19V DEC 
341 DB2XMLALT Date of last ALTER INDEX|TABLESPACE SECQTY DATS DATS 
342 DB2XMQ1 First part of name qualifiying the object that got ext.alert CHAR8 CHAR 
343 DB2XMQ2 Sec. part of name qualifiying the object that got ext. alert CHAR18 CHAR 
344 DB2XMRMIAP RID list processing failed - limit exeeded DB2DEC19V DEC 
345 DB2XMSEV Severity of an extent alert NUMC2 NUMC 
346 DB2XMTYP Type of object that got an extent alert DB2XMTYP CHAR 
347 DB2XNORGRP Parallel groups: executed as planned DB2DEC19V DEC 
348 DB2XNSMIAP RID list processing failed - no storage DB2DEC19V DEC 
349 DB2XOPEN Number of OPEN CURSOR statements executed DB2DEC19V DEC 
350 DB2XPREP Number of PREPARE statements executed DB2DEC19V DEC 
351 DB2XREDGRP Parallel groups: executed with reduced degree DB2DEC19V DEC 
352 DB2XREL Number of RELEASE statements executed DB2DEC19V DEC 
353 DB2XREOP Total Number of Times Reoptimization Occurs DB2DEC19V DEC 
354 DB2XREPOP1 Parallel groups with reformulated access path (Sysplex conf) DB2DEC19V DEC 
355 DB2XREPOP2 Parallel groups with reformulated access path (buffer pool) DB2DEC19V DEC 
356 DB2XREVOK Number of REVOKE statements executed DB2DEC19V DEC 
357 DB2XRNIX rename index DB2DEC19V DEC 
358 DB2XRNTAB RENAME TABLE DB2DEC19V DEC 
359 DB2XROIIDX Direct row access attempted, but reverted to using index DB2DEC19V DEC 
360 DB2XROIMAT Number of times DB2 used dir. row access to locate a record DB2DEC19V DEC 
361 DB2XROITS Direct row access attempted, reverted to tablespace scan DB2DEC19V DEC 
362 DB2XROWTRG Number of times a row trigger is activated DB2DEC19V DEC 
363 DB2XSELECT Number of SELECT statements executed DB2DEC19V DEC 
364 DB2XSETCDG Number of SET CURRENT DEGREE statements executed DB2DEC19V DEC 
365 DB2XSETCON Number of SET CONNECTION statements executed DB2DEC19V DEC 
366 DB2XSETCRL Number of SET CURRENT RULES statements executed DB2DEC19V DEC 
367 DB2XSETHV Number of SET HOST VARIABLE statements executed DB2DEC19V DEC 
368 DB2XSETPTH Number of SQL SET CURRENT PATH statements DB2DEC19V DEC 
369 DB2XSETSQL Number of SET CURRENT SQLID statements executed DB2DEC19V DEC 
370 DB2XSTDEXP MAXKEEPD parameter exceeded DB2DEC19V DEC 
371 DB2XSTFND Number of Times that DB2 Found the Statement in the Cache DB2DEC19V DEC 
372 DB2XSTINV Statement invalidated DB2DEC19V DEC 
373 DB2XSTIRP Number of implicit prepares DB2DEC19V DEC 
374 DB2XSTLOBV Maximum storage used for LOB values (MB) DB2DEC19V DEC 
375 DB2XSTNFND Number of times statement could not be found in cache DB2DEC19V DEC 
376 DB2XSTNPRP Number of avoided prepares DB2DEC19V DEC 
377 DB2XSTTRG Number of times a statement trigger is activated DB2DEC19V DEC 
378 DB2XTOTGRP Parallel groups: total executed DB2DEC19V DEC 
379 DB2XTRGERR No. of times an SQL error occurred during a triggered action DB2DEC19V DEC 
380 DB2XTRTBL # of times truncate table stmt was exec. DB2DEC19V DEC 
381 DB2XUPDTE Number of UPDATE statements executed DB2DEC19V DEC 
382 DB2XVGSYIO Average synchronous I/Os DB2DEC25V6 DEC 
383 DB2XXCBPNX Parallel groups: intended to run across data sharing group DB2DEC19V DEC 
384 DB2XXCSKIP Member bypasses due to storage shortage DB2DEC19V DEC 
385 DB2YESNO Yes / NO Flag   CHAR 
386 DB2ZPARM DB2 ZPARM   CHAR 
387 DB2ZPARMVAL ZPARM Value   CHAR 
388 DB2_ACCOR_CALLER Transaction name of caller of DSNACCOR / DSNACCOX   CHAR 
389 DB2_CONINI_LINE Line DB2_LINE CHAR 
390 DB2_CON_INI_APP_NAME Name of application server belonging to a certain group DB2_HOST CHAR 
391 DB2_CON_INI_CONID Connection identifier DB2_CON_ID CHAR 
392 DB2_CON_INI_CONNAME Name of the connection DB2_CON_NAME CHAR 
393 DB2_CON_INI_FTP_HOST host used for ftp DB2_HOST CHAR 
394 DB2_CON_INI_GROUP_NAME Name of a CONNECT.INI group DB2_GROUP_NAME CHAR 
395 DB2_CON_INI_HOST host name DB2_HOST CHAR 
396 DB2_CON_INI_LINE Line DB2_LINE CHAR 
397 DB2_CON_INI_LOCATION location DB2_LOCATION CHAR 
398 DB2_CON_INI_LOG_CONNAME Logical connection name DB2_CON_NAME CHAR 
399 DB2_CON_INI_MEMBER member name of a data sharing group DB2_MEMBER CHAR 
400 DB2_CON_INI_PLAN plan name DB2_PLAN CHAR 
401 DB2_CON_INI_PORT port DB2_PORT CHAR 
402 DB2_CON_INI_PS DB2 package set (collection) DB2_PS CHAR 
403 DB2_CON_INI_RETRY_CNT retry count for the connection DB2_RETRY_CNT CHAR 
404 DB2_CON_INI_SLEEP_TIME sleep time before next retry DB2_SLEEP_TIME CHAR 
405 DB2_CON_INI_SSID subsystem id DB2_SSID CHAR 
406 DB2_ENCODING DB2 Encoding   CHAR 
407 DB2_HOLD_WAIT Detectionflag for Holders(H) or Waiters(W) for DB2Resources CHAR1 CHAR 
408 DB2_HOST RMF Host DB2CHAR40 CHAR 
409 DB2_JOBPROFILE_VAL DB2 Job Profile Value of Variable Name   CHAR 
410 DB2_JOBPROFILE_VAR DB2 Job Profile Variable Name   CHAR 
411 DB2_LPAR_CPU_LOGICAL SYSPLEX processor utilization by MVS image   DEC 
412 DB2_LPAR_CPU_USAGE SYSPLEX processor utilization by MVS image   DEC 
413 DB2_LPAR_CP_USAGE LPAR Total physical utilization by partition   INT4 
414 DB2_LPAR_DELAY_FOR_PROC LPAR delay for processor by MVS image   DEC 
415 DB2_LPAR_FRAMES LPAR no of storage frames   DEC 
416 DB2_LPAR_LOCAL_START LPAR Start of local data collection CHAR14 CHAR 
417 DB2_LPAR_NAME LPAR name CHAR16 CHAR 
418 DB2_LPAR_NAME_OF_IMAGE Name of the z/OS image in the LPAR CHAR16 CHAR 
419 DB2_LPAR_OS_TYPE RMF OS Type and Version CHAR20 CHAR 
420 DB2_LPAR_PAGEIN LPAR pagein rate   DEC 
421 DB2_LPAR_SSID Subsystem ID of DB2 system CHAR4 CHAR 
422 DB2_LPAR_TCP_NAME LPAR TCP LPAR name CHAR32 CHAR 
423 DB2_LPAR_UIC LPAR Unreferenced Interval Count   DEC 
424 DB2_LPAR_WEIGHT LPAR Weight   DEC 
425 DB2_LPAR_WLM WLM management enabled   CHAR 
426 DB2_MSG message field DB2_LINE CHAR 
427 DB2_MSG_ID DB2 message log ID   CHAR 
428 DB2_MTE_NAME DB2 Node Name (RZ20) CHAR255 CHAR 
429 DB2_OBJ_TYPE Object Type (TS or IX)   CHAR 
430 DB2_PARTITION DB2 Partition Number   INT4 
431 DB2_PORT RMF Port   NUMC 
432 DB2_SQL_QUERY_NAME SQL Query Name DB2SQLQUERYNAME CHAR 
433 DB2_SYSPLEX_CAPACITY SYSPLEX CPU Capacity   INT4 
434 DB2_SYSPLEX_CPU_FAMILY SYSPLEX CPU family CHAR4 CHAR 
435 DB2_SYSPLEX_CPU_TYPE SYSPLEX CPU Type CHAR4 CHAR 
436 DB2_SYSPLEX_NAME SYSPLEX Name   CHAR 
437 DB2_SYSPLEX_NUMBER_OF_CP SYSPLEX Number of processors   INT4 
438 DB2_SYSPLEX_NUMBER_OF_LPARS SYSPLEX Number of LPARS   INT4 
439 DB2_SYSPLEX_SERIAL_NO SYSPLEX CPU Serial Number CHAR6 CHAR 
440 DB2_TABPROFILE_DATE_UPDATED DB2 Table Profile Date created or updated   DATS 
441 DB2_TABPROFILE_TEXT DB2 Table Profile Text   STRG 
442 DB2_TABPROFILE_TIME_UPDATED DB2 Table Profile Time created or updated   TIMS 
443 DB2_TABPROFILE_TYPE DB2 Table Profile Type   CHAR 
444 DB4ANLDATE iSeries: Analysis Date   DATS 
445 DB4AVGROWS iSeries: Avarage Growth (Rows)   DEC 
446 DB4AVGSIZE iSeries: Avarage Growth (KB)   DEC 
447 DB4BOUNDEXCL DB2/400: Exclusion Property of a Boundary Vector DB4BOUNDEXCL CHAR 
448 DB4CHAR1 iSeries: Internal (Technical Field)   CHAR 
449 DB4DBM_EN iSeries: Value of Profile Parameter as4/dbmon/enable   CHAR 
450 DB4DIMVAL DB2/400: Boundary Value of a Single-Dimensional Value Area DB4DIMVAL CHAR 
451 DB4DROWS iSeries: Delta Rows   DEC 
452 DB4DSIZE iSeries: Delta Size of Table (KB)   DEC 
453 DB4EVI Index created as DB2/400 encoded vector index DB4EVI CHAR 
454 DB4EVIVAL Number of values for DB2/400 encoded vector index DB4EVIVAL NUMC 
455 DB4HOST Hostname MSHOST2 CHAR 
456 DB4HTIME iSeries: Time interval for history dump of database monitor DB4TIME INT4 
457 DB4IXPARTED DB2/400: Partition Property of an Index DB4IXPARTED CHAR 
458 DB4KEYCOLNAME DB2/400: Partition Key Column DB4KEYCOLNAME CHAR 
459 DB4MSNAME iSeries: System name of server for DBMon dump execution MSNAME CHAR 
460 DB4NULLSLAST DB2/400: NULL Value Sort Below RANGE Partitioning DB4NULLSLAST CHAR 
461 DB4NUMPARTS DB2/400: Number of Partitions of a Table DB4NUMPARTS NUMC 
462 DB4OBJNAME iSeries: Object Name AS4TAB CHAR 
463 DB4PARTBY DB2/400: Partitioning Properties of a Table DB4PARTBY CHAR 
464 DB4PARTNAME DB2/400: Name of a Table Partition DB4PARTNAME CHAR 
465 DB4PCT DB2 UDB for iSeries: Percentage   INT4 
466 DB4RLEN DB2 UDB for iSeries: Record Length   INT4 
467 DB4ROWS iSeries: Number of Rows in Table   DEC 
468 DB4RTIME iSeries: Time interval for regular dump and merge of DBMon DB4TIME INT4 
469 DB4SRV Server MSSERV CHAR 
470 DB4SRVNAM Server Name MSNAME2 CHAR 
471 DB4TABLEPARTED DB2/400: Partition Property of the Basic Table DB4TABLEPARTED CHAR 
472 DB4TABSIZE iSeries: Object Size in Kbytes   DEC 
473 DB4TABTYP Dummy for DB4TS structure DB4TABTYP CHAR 
474 DB4TUNIT iSeries: Time unit for database monitor dump time interval DB4TUNIT CHAR 
475 DB4TXTC132 iSeries: Text Field of Length 132   CHAR 
476 DB4WSPC DB2 UDB for iSeries: Unused Disk Space   DEC 
477 DB4_ANZ15 iSeries: Number of rows / object size DB4_ANZ15 DEC 
478 DB4_CHAR1 iSeries: Data Type CHAR(1) (Internal Use)   CHAR 
479 DB4_CHDATE iSeries: Change Date   DATS 
480 DB4_DMPCNT iSeries: Number of available DB monitor history dumps QINT4 INT4 
481 DB4_DMPDAT iSeries: Date of DB monitor history dump ocurrence DB4_DATE DATS 
482 DB4_EXECDATE iSeries: Execution Date   DATS 
483 DB4_EXECTIME iSeries: Execution Time   TIMS 
484 DB4_FLAG iSeries: Flag to determine if weekly info is available QQCHAR1 CHAR 
485 DB4_RC iSeries: Return Code   CHAR 
486 DB4_TIME iSeries: Change Time   TIMS 
487 DB4_USER iSeries: User   CHAR 
488 DB64KCHAR DB6 CCMS: 4048 Character Text   CHAR 
489 DB6CFG_GROUP_ID DB6: Group ID DB6CFG_GROUP_ID INT4 
490 DB6DATETIM DBA: ISO conform timestamp with ms precission   CHAR 
491 DB6DATETIM_NOMS DBA: ISO conform timestamp with second precission   CHAR 
492 DB6DBHWTKEY DB6: Key for Web Templates   CHAR 
493 DB6DBREL DB6: Database Release Level   CHAR 
494 DB6DEC22 DB6 Bigint value   DEC 
495 DB6DEC22S DB6: signed decimal for integer64 data DB6DEC22S DEC 
496 DB6DEFAULT Default values DB6DEFAULT RAW 
497 DB6FETCHPA PAGE_FETCH_PAIRS VARCHAR 254 DB6FETCHPA RAW 
498 DB6ICOLNAM Field COLNAMES in SYSCAT.INDEXES DB6ICOLNAM LCHR 
499 DB6IDENT DB6: General identifier   CHAR 
500 DB6LONGID DB6: Long identifier   CHAR