SAP ABAP Data Element - Index D, page 4
Data Element - D
# Data Element Short Description Domain Data Type
1 DB2AVGPLGP Average parallel groups DB2DEC25V6 DEC 
2 DB2AVGRBUF Average synchronous reads DB2DEC25V6 DEC 
3 DB2AVGREAD Average wait for other read   CHAR 
4 DB2AVGSIOW Average synchronous I/O time   CHAR 
5 DB2AVGSORT Average sorts DB2DEC25V6 DEC 
6 DB2AVGSYIO Average synchronous I/Os   CHAR 
7 DB2AVGTHDSZ64 Average DB2 thread size (64 bit) DB2DEC19V DEC 
8 DB2AVGTSCN Average tablespace scans DB2DEC25V6 DEC 
9 DB2AVGW Average wait time DB2DEC19V6 DEC 
10 DB2AVGW1 Average synchronous I/O time DB2DEC19V6 DEC 
11 DB2AVGW2 Average wait for lock/latch DB2DEC19V6 DEC 
12 DB2AVGW3 Average wait for EU switch DB2DEC19V6 DEC 
13 DB2AVGW4 Average wait for global lock DB2DEC19V6 DEC 
14 DB2AVGW5 Average wait for other read DB2DEC19V6 DEC 
15 DB2AVGW6 Average wait for other write DB2DEC19V6 DEC 
16 DB2AVGW7 Average wait time for latch req DB2DEC19V6 DEC 
17 DB2AVGW8 Average wait time for page latch DB2DEC19V6 DEC 
18 DB2AVGW9 Average wait time for drain lock DB2DEC19V6 DEC 
19 DB2AVGWA Average wait for drain when waiting for claims to be rel. DB2DEC19V6 DEC 
20 DB2AVGWAIT Average wait time   CHAR 
21 DB2AVGWB Average wait time for logwriter DB2DEC19V6 DEC 
22 DB2AVGWRIT Average wait for other write   CHAR 
23 DB2AVGWRITE Average synchronous writes DB2DEC25V6 DEC 
24 DB2BACCDPF Number of dynamic prefetch requests DB2NUMC10 NUMC 
25 DB2BACCGET Number of Getpage Requests DB2NUMC10 NUMC 
26 DB2BACCHPG Number of Pages Read Asynchronously DB2NUMC10 NUMC 
27 DB2BACCHRE Number of Successful Synchronous Hiperpool Reads DB2NUMC10 NUMC 
28 DB2BACCHRF Number of Unsuccessful Synchronous Hiperpool Reads DB2NUMC10 NUMC 
29 DB2BACCHWF Number of Unsuccessful Synchronous Hiperpool Writes DB2NUMC10 NUMC 
30 DB2BACCHWR Number of Successful Synchronous Hiperpool Writes DB2NUMC10 NUMC 
31 DB2BACCIMW Number of immediate (synchronous) write I/Os DB2NUMC10 NUMC 
32 DB2BACCLPF Number of list prefetch requests DB2NUMC10 NUMC 
33 DB2BACCNGT Unsuccesful Page at Conditional Getpage Request DB2NUMC10 NUMC 
34 DB2BACCPID Buffer pool ID DB2NUMC10 NUMC 
35 DB2BACCRIO Number of synchronous read I/O operations DB2NUMC10 NUMC 
36 DB2BACCSEQ Number of sequential prefetch requests DB2NUMC10 NUMC 
37 DB2BACCSIO Asynchronous pages read DB2NUMC10 NUMC 
38 DB2BACCSWS The number of times a buffer update occurs for the agent DB2NUMC10 NUMC 
39 DB2BACDPF Number of dynamic prefetch requests DB2INT4U INT4 
40 DB2BACGET Number of Getpage Requests DB2INT4U INT4 
41 DB2BACHPG Number of Pages Read Asynchronously DB2INT4U INT4 
42 DB2BACHRE Number of Successful Synchronous Hiperpool Reads DB2INT4U INT4 
43 DB2BACHRF Number of Unsuccessful Synchronous Hiperpool Reads DB2INT4U INT4 
44 DB2BACHWF Number of Unsuccessful Synchronous Hiperpool Writes DB2INT4U INT4 
45 DB2BACHWR Number of Successful Synchronous Hiperpool Writes DB2INT4U INT4 
46 DB2BACIMW Number of immediate (synchronous) write I/Os DB2INT4U INT4 
47 DB2BACLPF Number of list prefetch requests DB2INT4U INT4 
48 DB2BACNGT Unsuccesful Page at Conditional Getpage Request DB2INT4U INT4 
49 DB2BACPID Buffer pool ID DB2INT4U INT4 
50 DB2BACRIO Number of synchronous read I/O operations DB2INT4U INT4 
51 DB2BACSEQ Number of sequential prefetch requests DB2INT4U INT4 
52 DB2BACSIO Asynchronous pages read DB2INT4U INT4 
53 DB2BACSWS The number of times a buffer update occurs for the agent DB2INT4U INT4 
54 DB2BASECOLNAME Name of the LOB column in the base table causing the LOB TS DB2COLNAME CHAR 
55 DB2BASECREATOR Name of the creator of the base table DB2CREATOR CHAR 
56 DB2BASEDBNAME Name of the database where the base table resides DBNAME CHAR 
57 DB2BASEPARTNR Partition number of the base table (0 for non-partitioned) DB2PARTNO INT2 
58 DB2BASETBNAME Name of the base table DB2TBNAME CHAR 
59 DB2BASETSNAME Name of the tablespace where the base table resides DB2TSNAME CHAR 
60 DB2BCKDATE Date of the last check DATUM DATS 
61 DB2BCKTIME Time of the last check TIME TIMS 
62 DB2BGA2W Number of write requests to the secondary GBP DEC_10 DEC 
63 DB2BGAC2W Number of write requests to the secondary GBP DB2NUMC10 NUMC 
64 DB2BGACEX Number of explicit cross-invalidations DB2NUMC10 NUMC 
65 DB2BGACSR Group buffer pool: Synchronous reads DB2NUMC10 NUMC 
66 DB2BGACSW Group buffer pools: synchronous writes DB2NUMC10 NUMC 
67 DB2BGAEX Number of explicit cross-invalidations DEC_10 DEC 
68 DB2BGASR Group buffer pool: Synchronous reads DB2NUMC10 NUMC 
69 DB2BGASW Group buffer pools: synchronous writes DB2NUMC10 NUMC 
70 DB2BGBCTN DB2 11 - Castout class level threshold (buffer num)   DEC 
71 DB2BGBDRR Directory entry reclaim counter DB2INT4 INT4 
72 DB2BGBDTR Data entry reclaim counter DB2INT4 INT4 
73 DB2BGBDUP Duplex or simplex indication for the group buffer pool DB2CHAR08L CHAR 
74 DB2BGBGAS Current automatic recovery setting for the GBP DB2CHAR03L CHAR 
75 DB2BGBGCK GBP checkpoint interval (GBPCHKPT) DB2INT4 INT4 
76 DB2BGBGCS Current group buffer pool cache (GBPCACHE) setting CHAR3 CHAR 
77 DB2BGBGCS8 Current group buffer pool cache (GBPCACHE) setting DB2CHAR03L CHAR 
78 DB2BGBGCT Class castout threshold (%) DB2INT4 INT4 
79 DB2BGBGDR The actual number of allocated directory entries DB2INT4 INT4 
80 DB2BGBGDR2 Number of allocated directory entries in the sec. GBP DB2INT4 INT4 
81 DB2BGBGDT The actual number of allocated data entries DB2INT4 INT4 
82 DB2BGBGDT2 Number of data entries allocated for the secondary GBP DB2INT4 INT4 
83 DB2BGBGGT Group buffer pool castout threshold (%) DB2INT4 INT4 
84 DB2BGBGR1 The current directory entry per data entry ratio DB2CHAR06 CHAR 
85 DB2BGBGR1C The current directory entry per data entry ratio DB2NUMC10 NUMC 
86 DB2BGBGR2 The pending directory entry per data entry ratio DB2CHAR06 CHAR 
87 DB2BGBGR2C The pending directory entry per data entry ratio DB2NUMC10 NUMC 
88 DB2BGBGSZ Allocated group buffer pool size in 4KB increments DB2INT4 INT4 
89 DB2BGBGSZ2 Allocated size of the sec. group buffer pool (in 4KB blocks) DB2INT4 INT4 
90 DB2BGBRXI Cross-invalidation & directory entry reclaim counter DB2INT4 INT4 
91 DB2BGBTCC Total changed counter DB2INT4 INT4 
92 DB2BGL2D Number of requests to delete a list of pages (secondary GBP) DB2DEC19V DEC 
93 DB2BGL2F Number of write requests to the secondary GBP that failed DB2DEC19V DEC 
94 DB2BGL2H # Asynch IXLCACHE invocations for secondary GBP DB2DEC19V DEC 
95 DB2BGL2N Number of requests to delete a page from the secondary GBP DB2DEC19V DEC 
96 DB2BGL2R Number of requests to read the castout statistics (sec. GBP) DB2DEC19V DEC 
97 DB2BGL2W Number of requests to write changed pages to the sec. GBP DB2DEC10V DEC 
98 DB2BGLAC Clean pages written asynchronously DB2DEC19V DEC 
99 DB2BGLAD Asynchronous reads - data returned DB2DEC10V DEC 
100 DB2BGLAN Asynchronous read - no data returned - no directory entry DEC_10 DEC 
101 DB2BGLAR Asynchronous read - no data returned DB2DEC10V DEC 
102 DB2BGLAW Changed pages written asynchronously DB2DEC19V DEC 
103 DB2BGLAX Register page list request DB2DEC19V DEC 
104 DB2BGLAY Changed pages - Read after register page list DB2DEC19V DEC 
105 DB2BGLAZ Clean pages read after register page list DB2DEC10V DEC 
106 DB2BGLCC Read castout class DB2DEC19V DEC 
107 DB2BGLCDG Unregister page DB2NUMC10 NUMC 
108 DB2BGLCGN Group buffer pool ID DB2BPNAME CHAR 
109 DB2BGLCK GBP checkpoints triggered DB2DEC19V DEC 
110 DB2BGLCMD Synchronous read (not found) - Data returned DB2NUMC10 NUMC 
111 DB2BGLCMN Synchronous read (not found) - No data returned (no dir) DB2NUMC10 NUMC 
112 DB2BGLCMR Synchronous Read (Not Found) - No Data Returned (Dir. Entry) DB2NUMC10 NUMC 
113 DB2BGLCN Number of times castout engine was unavailable DEC_10 DEC 
114 DB2BGLCS Read castout statistics DB2DEC19V DEC 
115 DB2BGLCSW Changed pages written synchronously to GBP DB2NUMC10 NUMC 
116 DB2BGLCT Castout class threshold DB2DEC19V DEC 
117 DB2BGLCWC Clean pages written synchronously DB2NUMC10 NUMC 
118 DB2BGLCXD Synchronous read (cross invalidation) - data returned DB2NUMC10 NUMC 
119 DB2BGLCXN Synchronous coupling facility read requests - no data DB2NUMC10 NUMC 
120 DB2BGLCXR Synchronous Read (Cross Invalidation) - No Data Returned DB2NUMC10 NUMC 
121 DB2BGLDG Unregister page DB2DEC19V DEC 
122 DB2BGLDN Delete data and directory entries in GBP DB2DEC19V DEC 
123 DB2BGLEX Number of explicit cross-invalidations DB2DEC19V DEC 
124 DB2BGLGN Group buffer pool ID DB2BPNAME CHAR 
125 DB2BGLGNC Group buffer pool name DB2CHAR08 CHAR 
126 DB2BGLGT Group buffer pool castout threshold DB2DEC19V DEC 
127 DB2BGLHS # Asynch IXLCACHE invocations for primary GBP DB2DEC19V DEC 
128 DB2BGLMD Synchronous read (not found) - Data returned DB2DEC19V DEC 
129 DB2BGLMN Synchronous read (not found) - No data returned (no dir) DEC_10 DEC 
130 DB2BGLMR Synchronous Read (Not Found) - No Data Returned (Dir. Entry) DB2DEC19V DEC 
131 DB2BGLN1 # page P-lock lock negotiations for space map pages DB2DEC19V DEC 
132 DB2BGLN2 # page P-lock lock negotiations for data pages DB2DEC19V DEC 
133 DB2BGLN3 # page P-lock lock negotiations for index leaf pages DB2DEC19V DEC 
134 DB2BGLOS CF requests to read storage statistics DB2DEC19V DEC 
135 DB2BGLP1 # page P-lock lock requests for space map pages DB2DEC19V DEC 
136 DB2BGLP2 # page P-lock lock requests for data pages DB2DEC19V DEC 
137 DB2BGLP3 # page P-lock lock requests for index leaf pages DB2DEC19V DEC 
138 DB2BGLRB Participation in GBP rebuild DEC_10 DEC 
139 DB2BGLRC Pages cast out from GBP to DASD DB2DEC19V DEC 
140 DB2BGLRD Read directory info DB2DEC19V DEC 
141 DB2BGLRF Read failed - no storage DEC_10 DEC 
142 DB2BGLRG Register page DB2DEC19V DEC 
143 DB2BGLS1 # page P-lock lock suspensions for space map pages DB2DEC19V DEC 
144 DB2BGLS2 # page P-lock lock suspensions for data pages DB2DEC19V DEC 
145 DB2BGLS3 # page P-lock lock suspensions for index leaf pages DB2DEC19V DEC 
146 DB2BGLSU Number of times write engine was unavailable DEC_10 DEC 
147 DB2BGLSW Changed pages written synchronously to GBP DB2DEC19V DEC 
148 DB2BGLU1 # page P-lock unlock requests DB2DEC19V DEC 
149 DB2BGLUN Unlock castout DB2DEC19V DEC 
150 DB2BGLWC Clean pages written synchronously DB2DEC19V DEC 
151 DB2BGLWF Write failed - no storage DB2DEC19V DEC 
152 DB2BGLXD Synchronous read (cross invalidation) - data returned DB2DEC19V DEC 
153 DB2BGLXN Synchronous coupling facility read requests - no data DEC_10 DEC 
154 DB2BGLXR Synchronous Read (Cross Invalidation) - No Data Returned DB2DEC19V DEC 
155 DB2BINUSE Percentage of buffers currently in use DB2DECPCT DEC 
156 DB2BIT01 Field type char, length 1, bit field DB2CHAR01 CHAR 
157 DB2BIT02 Field type char, length 2, bit field DB2CHAR02 CHAR 
158 DB2BIT04 Field type char, length 4, bit field DB2CHAR04 CHAR 
159 DB2BIT06 Field type char, length 6, bit field DB2CHAR06 CHAR 
160 DB2BOOLEAN bool type   CHAR 
161 DB2BPACA Active pages DB2DEC13_2 DEC 
162 DB2BPCURR Name of the DB2 buffer pool currently used for the TS DB2BPNAME CHAR 
163 DB2BPCUST Creator of BP tuning settings ( = SAP for default settings ) DB2CHAR12 CHAR 
164 DB2BPHRL Hit ratio DB2DEC13_2 DEC 
165 DB2BPLONG DB2 buffer pool name DB2CHAR10 CHAR 
166 DB2BPNAME DB2 buffer pool name DB2BPNAME CHAR 
167 DB2BPOOL Buffer pool name e.g. BP2, BP8K1   CHAR 
168 DB2BPSHR Buffer pool shortage DB2CHAR10 CHAR 
169 DB2BPSUG Suggested DB2 buffer pool DB2BPNAME CHAR 
170 DB2BSDSCPY Dual bootstrap data set DB2CHAR10 CHAR 
171 DB2BSENDFR Bytes sent from the ICLI server to application server DB2NUMC10 NUMC 
172 DB2BSENDTO Number of bytes sent to the ICLI server DB2NUMC10 NUMC 
173 DB2BSTARA Asynchronous data mover facility hiperpool reads DEC_10 DEC 
174 DB2BSTARF Number of pages for which a read request failed using DMF DEC_10 DEC 
175 DB2BSTAWA Pages moved successfully from virtual pool to hp using DMF DEC_10 DEC 
176 DB2BSTAWF Number of pages for which write request failed using DMF DEC_10 DEC 
177 DB2BSTBPNM DB2 buffer pool name DB2BPNAME CHAR 
178 DB2BSTBPX Number of times a successful buffer pool expansion occurred DB2NUMC10 NUMC 
179 DB2BSTCBA Number of currently active (non-stealable) buffers DB2DEC19V DEC 
180 DB2BSTDIO Number of dynamic prefetch reads DB2DEC19V DEC 
181 DB2BSTDMC Number of times the data manager threshold was reached DB2DEC19V DEC 
182 DB2BSTDPF Number of dynamic prefetch requests DB2DEC19V DEC 
183 DB2BSTDPP Number of pages read via dynamic prefetch read I/O DB2DEC19V DEC 
184 DB2BSTDSO Number of datasets successfully opened physically DB2DEC19V DEC 
185 DB2BSTDWT Number of times the deferred write threshold was reached DB2DEC19V DEC 
186 DB2BSTDWV Number of times vertical deferred write threshold is reached DB2DEC19V DEC 
187 DB2BSTDWVC Number of times vertical deferred write threshold is reached DB2NUMC10 NUMC 
188 DB2BSTGET Number of get page requests (conditional and unconditional) DB2DEC19V DEC 
189 DB2BSTGETC Number of get page requests (conditional and unconditional) DB2NUMC10 NUMC 
190 DB2BSTHBE Number of hp buffers currently backed by expanded storage DEC_10 DEC 
191 DB2BSTHITR Buffer hit ratio   CHAR 
192 DB2BSTHPA Number of successful hiperpool expansions/contractions DEC_10 DEC 
193 DB2BSTHPL Number of buffers allocated for hiperpool DEC_10 DEC 
194 DB2BSTHRA Number of successful hiperpool reads done asynchronously DEC_10 DEC 
195 DB2BSTHRE Number of successful hiperpool reads DEC_10 DEC 
196 DB2BSTHRF Number of unsuccessful hiperpool reads DEC_10 DEC 
197 DB2BSTHWA Number of successful hiperpool writes done asynchronously DEC_10 DEC 
198 DB2BSTHWF Number of unsuccessful hiperpool writes DEC_10 DEC 
199 DB2BSTHWR Number of successful hiperpool writes DEC_10 DEC 
200 DB2BSTIMW Number of immediate writes DB2DEC19V DEC 
201 DB2BSTJIS Total number of denied concurrent prefetch I/O streams DB2DEC19V DEC 
202 DB2BSTLIO Number of list prefetch reads DB2DEC19V DEC 
203 DB2BSTLPF Number of list prefetch requests DB2DEC19V DEC 
204 DB2BSTLPL Number of times one or more pages were added to LPL DB2DEC19V DEC 
205 DB2BSTLPP Number of pages read via list prefetch DB2DEC19V DEC 
206 DB2BSTMAX Number of times a work file could not be opened DB2DEC19V DEC 
207 DB2BSTMIG Number of times migrated datasets were encountered DB2DEC19V DEC 
208 DB2BSTNGT # of unsuccessful GETPAGE due conditional GETPAGE request DB2DEC19V DEC 
209 DB2BSTPIO Number of sequential prefetch reads DB2DEC19V DEC 
210 DB2BSTPL1 Prefetch quantity is reduced from normal to 50% DB2DEC19V DEC 
211 DB2BSTPL2 Number of occurrences of prefetch quantity reduced 1/4 DB2DEC19V DEC 
212 DB2BSTPQF The parallel query went into reduced or degenerated mode DB2DEC19V DEC 
213 DB2BSTPQO Total no. of requests for parallel query support DB2DEC19V DEC 
214 DB2BSTPWS Number of pages written DB2DEC19V DEC 
215 DB2BSTREE Sequential prefetch disabled - unavailable read engine DB2DEC19V DEC 
216 DB2BSTRIO Number of synchronous read I/O operations DB2DEC19V DEC 
217 DB2BSTRIOC Number of synchronous read I/O operations DB2NUMC10 NUMC 
218 DB2BSTRPI Number of page inserts required for read I/O DB2DEC19V DEC 
219 DB2BSTRTO Number of recall timeouts DB2DEC19V DEC 
220 DB2BSTSEQ Number of sequential prefetch requests DB2DEC19V DEC 
221 DB2BSTSGT Number of get page requests issued by sequential access req. DB2DEC19V DEC 
222 DB2BSTSIO Synchronous read requests issued by sequential access req. DB2DEC19V DEC 
223 DB2BSTSPD Sequential prefetch disabled - no buffers available DB2DEC19V DEC 
224 DB2BSTSPP Number of pages read because of normal sequential prefetch DB2DEC19V DEC 
225 DB2BSTSWS Update intents against pages in the buffer pool DB2DEC19V DEC 
226 DB2BSTVPA Number of successful virtual buffer pool expans./contract. DB2DEC19V DEC 
227 DB2BSTVPL Number of buffers allocated for virtual buffer pool DB2DEC19V DEC 
228 DB2BSTWBVQ Number of Pages Removed from the DWQ for Destructive Read DB2DEC19V DEC 
229 DB2BSTWDRP Number of pages for which destructive read was requested DB2DEC19V DEC 
230 DB2BSTWEE A write engine is unavailable for asynchronous write I/O DB2DEC10V DEC 
231 DB2BSTWFD Work file requests were rejected due to buffer pool shortage DB2DEC19V DEC 
232 DB2BSTWFF Number of times a merge pass could not be performed DB2DEC19V DEC 
233 DB2BSTWFM Maximum number of work files concurrently used DB2DEC19V DEC 
234 DB2BSTWFR Number of merge passes requested for DB2 sort activities DB2DEC19V DEC 
235 DB2BSTWFT Number of merge passes requested for DB2 sort activities DB2DEC19V DEC 
236 DB2BSTWIO Number of asynchronous writes DB2DEC19V DEC 
237 DB2BSTWKPD Number of work prefetches not scheduled due to zero prefetch DB2DEC19V DEC 
238 DB2BSTWPI Number of page inserts required for write I/O DB2DEC19V DEC 
239 DB2BSTXFL Number of times the virtual buffer pool was full DB2DEC19V DEC 
240 DB2BSTXFV Total number of virtual buffer pool or hiperpool failures DB2DEC19V DEC 
241 DB2BSTXIS Highest number of concurrent prefetch I/O streams DB2DEC19V DEC 
242 DB2BUFPOOL DB2/390: Buffer pool DB2BUFPOOL CHAR 
243 DB2BUPDRAT Buffer Update Rate DB2DEC19V DEC 
244 DB2BUTTON Navigation button of st04 subsystem activity overview panel DB2BUTTON CHAR 
245 DB2C9STCT0 Display database: # of commands DB2NUMC10 NUMC 
246 DB2C9STCT1 DISPLAY THREAD: # of commands DB2NUMC10 NUMC 
247 DB2C9STCT2 DISPLAY UTILITY: # of commands DB2NUMC10 NUMC 
248 DB2C9STCT3 RECOVER BSDS: # of commands DB2NUMC10 NUMC 
249 DB2C9STCT4 RECOUVER INDOUBT: # of commands DB2NUMC10 NUMC 
250 DB2C9STCT5 START DATABASE: # of commands DB2NUMC10 NUMC 
251 DB2C9STCT6 START TRACE: # of commands DB2NUMC10 NUMC 
252 DB2C9STCT7 START DB2: # of commands DB2NUMC10 NUMC 
253 DB2C9STCT8 STOP DATABASE: # of commands DB2NUMC10 NUMC 
254 DB2C9STCT9 STOP TRACE: # of commands DB2NUMC10 NUMC 
255 DB2C9STCTA STOP DB2: # of commands DB2NUMC10 NUMC 
256 DB2C9STCTB TERM UTLITY: # of commands DB2NUMC10 NUMC 
257 DB2C9STCTC DISPLAY TRACE: # of commands DB2NUMC10 NUMC 
258 DB2C9STCTD RESET GENERICLU: # of commands DB2NUMC10 NUMC 
259 DB2C9STCTE START RLIMIT: # of commands DB2NUMC10 NUMC 
260 DB2C9STCTF STOP RLIMIT: # of commands DB2NUMC10 NUMC 
261 DB2C9STCTG DISPLAY RLIMIT: # of commands DB2NUMC10 NUMC 
262 DB2C9STCTH MODIFY TRACE: # of commands DB2NUMC10 NUMC 
263 DB2C9STCTI START DDF: # of commands DB2NUMC10 NUMC 
264 DB2C9STCTJ STOP DDF: # of commands DB2NUMC10 NUMC 
265 DB2C9STCTK CANCEL THREAD: # of commands DB2NUMC10 NUMC 
266 DB2C9STCTL DISPLAY LOCATION: # of commands DB2NUMC10 NUMC 
267 DB2C9STCTM ARCHIVE LOG: # of commands DB2NUMC10 NUMC 
268 DB2C9STCTN ALTER BUFFERPOOL: # of commands DB2NUMC10 NUMC 
269 DB2C9STCTO DISPLAY BUFFERPOOL: # of commands DB2NUMC10 NUMC 
270 DB2C9STCTP SET ARCHIVE: # of commands DB2NUMC10 NUMC 
271 DB2C9STCTQ DISPLAY ARCHIVE: # of commands DB2NUMC10 NUMC 
272 DB2C9STCTR RESET INDOUBT: # of commands DB2NUMC10 NUMC 
273 DB2C9STCTS ALTER GROUPBUFFERPOOL: # of commands DB2NUMC10 NUMC 
274 DB2C9STCTT DISPLAY GROUPBUFFERPOOL: # of comands DB2NUMC10 NUMC 
275 DB2C9STCTU DISPLAY PROCEDURE: # of commands DB2NUMC10 NUMC 
276 DB2C9STCTV START PROCEDURE: # of commands DB2NUMC10 NUMC 
277 DB2C9STCTW STOP PROCEDURE: # of commands DB2NUMC10 NUMC 
278 DB2C9STCTZ Number of -DISPLAY FUNCTION commands DB2NUMC10 NUMC 
279 DB2C9STCX0 Number of -START FUNCTION commands DB2NUMC10 NUMC 
280 DB2C9STCX1 Number of -STOP FUNCTION commands DB2NUMC10 NUMC 
281 DB2C9STCX2 Number of -SET LOG commands DB2NUMC10 NUMC 
282 DB2C9STCX3 Number of -DISPLAY LOG commands DB2NUMC10 NUMC 
283 DB2C9STERR Unrecognized commands DB2NUMC10 NUMC 
284 DB2CARD Number of rows in the tablespace or partition   INT4 
285 DB2CARDD Cardinality   DEC 
286 DB2CARDF Total number of rows in the table FLOATING FLTP 
287 DB2CARDFD Total number of rows in the table DB2DEC12 DEC 
288 DB2CASHOST Application server host name DB2CHAR30 CHAR 
289 DB2CASHPG Cached pages DB2DECPCT DEC 
290 DB2CASTA Average of stored procedures DB2CHAR10 CHAR 
291 DB2CASTE Number of stored procedures DB2NUMC10 NUMC 
292 DB2CASTP Percent of time spent in DB2 for stored procedures DB2CHAR10 CHAR 
293 DB2CBGBDRR Directory entry reclaim counter DB2NUMC10 NUMC 
294 DB2CBGBDTR Data entry reclaim counter DB2NUMC10 NUMC 
295 DB2CBGBDUP Duplex or simplex indication for the group buffer pool DB2CHAR08L CHAR 
296 DB2CBGBGAS Current automatic recovery setting for the GBP DB2CHAR03L CHAR 
297 DB2CBGBGC8 Current group buffer pool cache (GBPCACHE) setting DB2CHAR03L CHAR 
298 DB2CBGBGCK GBP checkpoint interval (GBPCHKPT) DB2NUMC10 NUMC 
299 DB2CBGBGCT Class castout threshold (%) DB2NUMC10 NUMC 
300 DB2CBGBGD2 Number of allocated directory entries in the sec. GBP DB2NUMC10 NUMC 
301 DB2CBGBGDR The actual number of allocated directory entries DB2NUMC10 NUMC 
302 DB2CBGBGDT The actual number of allocated data entries DB2NUMC10 NUMC 
303 DB2CBGBGGT Group buffer pool castout threshold (%) DB2NUMC10 NUMC 
304 DB2CBGBGR1 The current directory entry per data entry ratio DB2NUMC10 NUMC 
305 DB2CBGBGR2 The pending directory entry per data entry ratio DB2NUMC10 NUMC 
306 DB2CBGBGS2 Allocated size of the sec. group buffer pool (in 4KB blocks) DB2NUMC10 NUMC 
307 DB2CBGBGSZ Allocated group buffer pool size in 4KB increments DB2NUMC10 NUMC 
308 DB2CBGBGT2 Number of data entries allocated for the secondary GBP DB2NUMC10 NUMC 
309 DB2CBGBRXI Cross-invalidation & directory entry reclaim counter DB2NUMC10 NUMC 
310 DB2CBGBTCC Total changed counter DB2NUMC10 NUMC 
311 DB2CBGLGN Group buffer pool ID DB2GBPNAM CHAR 
312 DB2CBINUSE Percentage of Buffers Currently in Use DB2CHAR06 CHAR 
313 DB2CBIT01 Field type char, length 1, bit field DB2CHAR01 CHAR 
314 DB2CBIT02 Field type char, length 2, bit field DB2CHAR02 CHAR 
315 DB2CBIT04 Field type char, length 4, bit field DB2CHAR04 CHAR 
316 DB2CBIT06 Field type char, length 6, bit field DB2CHAR06 CHAR 
317 DB2CBPNAME DB2 buffer pool name DB2BPNAME CHAR 
318 DB2CBSTARA Asynchronous data mover facility hiperpool reads DB2NUMC10 NUMC 
319 DB2CBSTARF Number of pages for which a read request failed using DMF DEC_10 DEC 
320 DB2CBSTAWA Pages moved successfully from virtual pool to hp using DMF DB2NUMC10 NUMC 
321 DB2CBSTAWF Number of pages for which write request failed using DMF DB2NUMC10 NUMC 
322 DB2CBSTBPN DB2 buffer pool name DB2BPNAME CHAR 
323 DB2CBSTCBA Number of currently active (non-stealable) buffers DB2NUMC10 NUMC 
324 DB2CBSTDIO Number of dynamic prefetch reads DB2NUMC10 NUMC 
325 DB2CBSTDMC Number of times the data manager threshold was reached DB2NUMC10 NUMC 
326 DB2CBSTDPF Number of dynamic prefetch requests DB2NUMC10 NUMC 
327 DB2CBSTDPP Number of pages read via dynamic prefetch read I/O DB2NUMC10 NUMC 
328 DB2CBSTDSO Number of datasets successfully opened physically DB2NUMC10 NUMC 
329 DB2CBSTDWT Number of times the deferred write threshold was reached DB2NUMC10 NUMC 
330 DB2CBSTDWV Number of times vertical deferred write threshold is reached DB2NUMC10 NUMC 
331 DB2CBSTGET Number of get page requests (conditional and unconditional) DB2NUMC10 NUMC 
332 DB2CBSTHBE Number of hp buffers currently backed by expanded storage DB2NUMC10 NUMC 
333 DB2CBSTHIT Buffer hit ratio DB2CHAR10 CHAR 
334 DB2CBSTHPA Number of successful hiperpool expansions/contractions DB2NUMC10 NUMC 
335 DB2CBSTHPL Number of buffers allocated for hiperpool DB2NUMC10 NUMC 
336 DB2CBSTHRA Number of successful hiperpool reads done asynchronously DB2NUMC10 NUMC 
337 DB2CBSTHRE Number of successful hiperpool reads DB2NUMC10 NUMC 
338 DB2CBSTHRF Number of unsuccessful hiperpool reads DB2NUMC10 NUMC 
339 DB2CBSTHWA Number of successful hiperpool writes done asynchronously DB2NUMC10 NUMC 
340 DB2CBSTHWF Number of unsuccessful hiperpool writes DB2NUMC10 NUMC 
341 DB2CBSTHWR Number of successful hiperpool writes DB2NUMC10 NUMC 
342 DB2CBSTIMW Number of immediate writes DB2NUMC10 NUMC 
343 DB2CBSTJIS Total number of denied concurrent prefetch I/O streams DB2NUMC10 NUMC 
344 DB2CBSTLIO Number of list prefetch reads DB2NUMC10 NUMC 
345 DB2CBSTLPF Number of list prefetch requests DB2NUMC10 NUMC 
346 DB2CBSTLPP Number of pages read via list prefetch DB2NUMC10 NUMC 
347 DB2CBSTMAX Number of times a work file could not be opened DB2NUMC10 NUMC 
348 DB2CBSTMIG Number of times migrated datasets were encountered DB2NUMC10 NUMC 
349 DB2CBSTPIO Number of sequential prefetch reads DB2NUMC10 NUMC 
350 DB2CBSTPL1 Prefetch quantity is reduced from normal to 50% DB2NUMC10 NUMC 
351 DB2CBSTPL2 Number of occurrences of prefetch quantity reduced 1/4 DB2NUMC10 NUMC 
352 DB2CBSTPQF The parallel query went into reduced or degenerated mode DB2NUMC10 NUMC 
353 DB2CBSTPQO Total no. of requests for parallel query support DB2NUMC10 NUMC 
354 DB2CBSTPWS Number of pages written DB2NUMC10 NUMC 
355 DB2CBSTREE Sequential prefetch disabled - unavailable read engine DB2NUMC10 NUMC 
356 DB2CBSTRIO Number of synchronous read I/O operations DB2NUMC10 NUMC 
357 DB2CBSTRPI Number of page inserts required for read I/O DB2NUMC10 NUMC 
358 DB2CBSTRTO Number of recall timeouts DB2NUMC10 NUMC 
359 DB2CBSTSEQ Number of sequential prefetch requests DB2NUMC10 NUMC 
360 DB2CBSTSGT Number of get page requests issued by sequential access req. DB2NUMC10 NUMC 
361 DB2CBSTSIO Synchronous read requests issued by sequential access req. DB2NUMC10 NUMC 
362 DB2CBSTSPD Sequential prefetch disabled - no buffers available DB2NUMC10 NUMC 
363 DB2CBSTSPP Number of pages read because of normal sequential prefetch DB2NUMC10 NUMC 
364 DB2CBSTSWS Update intents against pages in the buffer pool DB2NUMC10 NUMC 
365 DB2CBSTVPA Number of successful virtual buffer pool expans./contract. DB2NUMC10 NUMC 
366 DB2CBSTVPL Number of buffers allocated for virtual buffer pool DB2NUMC10 NUMC 
367 DB2CBSTWBV Number of Pages Removed from the DWQ for Destructive Read DB2NUMC10 NUMC 
368 DB2CBSTWDR Number of pages for which destructive read was requested DB2NUMC10 NUMC 
369 DB2CBSTWEE A write engine is unavailable for asynchronous write I/O DB2NUMC10 NUMC 
370 DB2CBSTWFD Work file requests were rejected due to buffer pool shortage DB2NUMC10 NUMC 
371 DB2CBSTWFF Number of times a merge pass could not be performed DB2NUMC10 NUMC 
372 DB2CBSTWFM Maximum number of work files concurrently used DB2NUMC10 NUMC 
373 DB2CBSTWFR Number of merge passes requested for DB2 sort activities DB2NUMC10 NUMC 
374 DB2CBSTWFT Number of merge passes requested for DB2 sort activities DB2NUMC10 NUMC 
375 DB2CBSTWIO Number of asynchronous writes DB2NUMC10 NUMC 
376 DB2CBSTWKP Number of work prefetches not scheduled due to zero prefetch DB2NUMC10 NUMC 
377 DB2CBSTWPI Number of page inserts required for write I/O DB2NUMC10 NUMC 
378 DB2CBSTXFL Number of times the virtual buffer pool was full DB2NUMC10 NUMC 
379 DB2CBSTXFV Total number of virtual buffer pool or hiperpool failures DB2NUMC10 NUMC 
380 DB2CBSTXIS Highest number of concurrent prefetch I/O streams DB2NUMC10 NUMC 
381 DB2CBUPDRA Buffer Update Rate DB2CHAR10 CHAR 
382 DB2CCAPP REORG Index: Appended rows (with greater key) in percent   INT4 
383 DB2CCASSTS Associated tablespace for indexspace DB2TSNAME CHAR 
384 DB2CCCCHGS Full/Inc. Copy: Changed rows in percent   INT4 
385 DB2CCCDAYS Full Copy: Number of days since last COPY   INT4 
386 DB2CCCHECK Degree of checking before invocation of stored procedure   INT4 
387 DB2CCCHGA RUN.:Changed rows (insert, delete or update) absolute number FLTP FLTP 
388 DB2CCCHGS Full/Inc. Copy, REORG, RUNSTATS: Changed rows in percent DB2PERCENT NUMC 
389 DB2CCCPYR COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) CHAR3 CHAR 
390 DB2CCCTIME Timestamp of last full image COPY DB2TMSTMP CHAR 
391 DB2CCCWP9R Number of minutes between two resynchronization intervals DB2NUMC05 NUMC 
392 DB2CCDAYS Number of days sice last COPY, RUNSTATS or REORG DB2CCDAYS INT4 
393 DB2CCESCP DSNACCMO: Escape character code of DB2 server CHAR1 CHAR 
394 DB2CCEXCL Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) CHAR40 CHAR 
395 DB2CCEXT Number of allowable dataset extents   INT4 
396 DB2CCEXTL Extentlimit was exceeded: YES or NO CHAR3 CHAR 
397 DB2CCEXTNO Number of physical extents in TS, IS or partition INT2 INT2 
398 DB2CCGDGLIST DSNACCDL: List Generations of specif. generation data group? CHAR1 CHAR 
399 DB2CCHAR01 Field type char, length 1 DB2CHAR01 CHAR 
400 DB2CCHAR02 Field type char, length 2 DB2CHAR02 CHAR 
401 DB2CCHAR03 Field type char, length 3 DB2CHAR03 CHAR 
402 DB2CCHAR04 Field type char, length 4 DB2CHAR04 CHAR 
403 DB2CCHAR08 Field type char, length 8 DB2CHAR08 CHAR 
404 DB2CCHAR12 Field type char, length 12 DB2CHAR12 CHAR 
405 DB2CCHAR16 Field type char, length 16 DB2CHAR16 CHAR 
406 DB2CCHAR22 Field type char, length 22 DB2CHAR22 CHAR 
407 DB2CCICTYP Types of image copies to be considered for recommendation CHAR1 CHAR 
408 DB2CCIND REORG TS: Indirect references (overflow records) in percent   INT4 
409 DB2CCIRES Reason code for the IFI call   INT4 
410 DB2CCIRET Return code for the IFI call   INT4 
411 DB2CCISIZE Full Copy: Minimum size of index in pages (NACTIVE)   INT4 
412 DB2CCJOBSTATE DSNACCJP: Status of the JCL Job   INT4 
413 DB2CCLEAF REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent   INT4 
414 DB2CCLEVEL REORG Index: Change to number of index tree levels absolute   INT4 
415 DB2CCLOB REORG TS: Disorganized LOBs in percent   INT4 
416 DB2CCLST Last statement executed by DSNACCAV stored procedures   CHAR 
417 DB2CCLTIME Timestamp of last LOAD REPLACE DB2TMSTMP CHAR 
418 DB2CCMASS Number of mass deletes (segm./LOB) / table drops (non-segm.)   INT4 
419 DB2CCMAXP DSNACCMO: Maximum number of parallel subtasks INT2 INT2 
420 DB2CCMAXRC DSNACCMO: Highest return code of DSNUTILS for all utilities   INT4 
421 DB2CCMAXRESULTS DSNACCDL: Max number of the temporary results table's rows   INT4 
422 DB2CCMAXWAIT DSNACCJP: Maximum awaiting time for completion   INT4 
423 DB2CCMO_MESSAGE DSNACCMO: Error information   LCHR 
424 DB2CCMTXT Area of the CC stored procedures output values   CHAR 
425 DB2CCNAME DSNACCMO: Name of the object to be treated CHAR31 CHAR 
426 DB2CCOBJID ID of the DB object as input for stored procedure DSNACCMO   INT4 
427 DB2CCOBJS DB2 object status: NULL, restricted states or orphaned CHAR36 CHAR 
428 DB2CCOBJT DB2 object type: TS for tablespace, IX for indexspace CHAR2 CHAR 
429 DB2CCONUM DSNACCMO: Number of input objects to be treated by utilities   INT4 
430 DB2CCOPER DSNACCJP: Requested operation - Cancel, Purge or Query   INT4 
431 DB2CCOPT DSNACCMO: Optimize runtime by sorting workload CHAR8 CHAR 
432 DB2CCOPTION DSNACCDS: Processing option CHAR2 CHAR 
433 DB2CCOREC REORG Recommendation: YES or NO CHAR3 CHAR 
434 DB2CCOTIME Timestamp of last REORG DB2TMSTMP CHAR 
435 DB2CCOTYP Most recent image copy type CHAR1 CHAR 
436 DB2CCOTYPE Types of objects who are considered for recommendation CHAR3 CHAR 
437 DB2CCOUTPUT DSNACCMO: Returned utility output CHAR254 CHAR 
438 DB2CCPARAL DSNACCMO: Number of parallel tasks actually started INT2 INT2 
439 DB2CCPARMLVL DSNACCDL: Level of the parameter list.   INT4 
440 DB2CCPART Data set number or partition number DB2PART INT2 
441 DB2CCPDSMEMBERS DSNACCDL: List MEMBERS of specified dat set? CHAR1 CHAR 
442 DB2CCPSEUD REORG Index: Pseudo deletes in percent   INT4 
443 DB2CCPSW User pword CHAR8 CHAR 
444 DB2CCQUERY Type of the Stored Procedure to run CHAR40 CHAR 
445 DB2CCRC DSNACCAV stored procedure return code   INT4 
446 DB2CCRCHGA REO.:Changed rows (insert, delete or update) absolute number   INT4 
447 DB2CCRCHGS REORG TS/IX: Changed rows in percent   INT4 
448 DB2CCREC Recommendation RUNSTATS/REORG: YES or NO CHAR3 CHAR 
449 DB2CCREORGRECS DB2/zOS: Number of REORG recommendations by DSNACCOR   INT4 
450 DB2CCRESTA DSNACCMO: Save restart info for stopped utilities CHAR8 CHAR 
451 DB2CCRETURN Return code of stored procedure   INT4 
452 DB2CCRMASS REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.)   INT4 
453 DB2CCRROWS REORG TS/IX: Number of active pages   INT4 
454 DB2CCRTIME Timestamp of last REBUILD INDEX DB2TMSTMP CHAR 
455 DB2CCSCHEM Schema name to qualify tables (statistics, catalog, created) CHAR128 CHAR 
456 DB2CCSCHGS RUNSTATS TS/IX: Changed rows in percent   INT4 
457 DB2CCSEQID DSNACCMO: Concatenate 2 IDs as Table key: ID1*10^10 + ID2   NUMC 
458 DB2CCSEQNO DSNACCMO: Sequence number for large statements   INT4 
459 DB2CCSEQUE DSNACCMO/DS: Sequence number   INT4 
460 DB2CCSMASS RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.)   INT4 
461 DB2CCSREC RUNSTATS Recommendation: YES or NO CHAR3 CHAR 
462 DB2CCSTIME Timestamp of last RUNSTATS DB2TMSTMP CHAR 
463 DB2CCSTMID ID of utility statement as input for stored proc. DSNACCMO   INT4 
464 DB2CCSTMNT DSNACCMO: (Part of) utility statement   CHAR 
465 DB2CCSTOPC DSNACCMO: Utility condition, which will stop procedure CHAR8 CHAR 
466 DB2CCTEMP DSNACCMO: Use template dynamic allocation CHAR1 CHAR 
467 DB2CCTOUT DSNACCMO: Timeout (in seconds) before cancelling DSNACCMO INT2 INT2 
468 DB2CCTRACE DSNACCDL/DS: Switch Trace on? CHAR1 CHAR 
469 DB2CCTSTMP Timestamp of last execution of utility as per component name DB2TMSTMP CHAR 
470 DB2CCTYPE DSNACCMO: Type of object for utility invocation CHAR10 CHAR 
471 DB2CCUID z/OS user ID CHAR8 CHAR 
472 DB2CCUNCLU REORG TS: Unclustered inserts in percent   INT4 
473 DB2CCUNUM DSNACCMO: Number of actual utility executions   INT4 
474 DB2CCUPDPG Full/Inc. Copy: Updated pages in percent of preformatted pag   INT4 
475 DB2CCUTID DSNACCMO: Utility-ID stem CHAR8 CHAR 
476 DB2CCUTILSRC DSNUTILS: Highest return code for the utility   INT4 
477 DB2CCWHERE Where clause for the Control Center stored procedures CHAR4096 CHAR 
478 DB2CCWP9RY Number of minutes between two resynchronization intervals DB2NUMC05 NUMC 
479 DB2CCXSB Number of bytes that did not fit in the IFI return area   INT4 
480 DB2CDATE Field type date, YYYYMMDD DB2DATE DATS 
481 DB2CDBPCAS CASTOUT attribute CHAR6 CHAR 
482 DB2CDBPDWQ The deferred write threshold for the virtual buffer pool DB2NUMC10 NUMC 
483 DB2CDBPHPH The sequential steal threshold for the hiperpool DB2NUMC10 NUMC 
484 DB2CDBPHPZ The size of the hiperpool DB2NUMC10 NUMC 
485 DB2CDBPNM Name of buffer pool CHAR8 CHAR 
486 DB2CDBPPGS Page stealing algorithm to be used for the virtual BP DB2CHAR04 CHAR 
487 DB2CDBPPSQ Parallel I/O sequential steal threshold for virtual BP DB2NUMC10 NUMC 
488 DB2CDBPVDB Pool vertical write threshold in number of buffers DB2NUMC05 NUMC 
489 DB2CDBPVDQ The vertical deferred write threshold for the virtual BP DB2NUMC10 NUMC 
490 DB2CDBPVPH The sequential steal threshold for the virtual buffer pool DB2NUMC10 NUMC 
491 DB2CDBPVPT Type of virtual buffer pool DB2CHAR01 CHAR 
492 DB2CDBPVPY Type of virtual buffer pool DB2CHAR01 CHAR 
493 DB2CDBPVPZ The size of the virtual buffer pool DB2NUMC10 NUMC 
494 DB2CDBPXSQ Assisting parallel sequential threshold DB2NUMC10 NUMC 
495 DB2CDROP Percentage of space occupied by rows of dropped tables DB2CDROP INT2 
496 DB2CDTHRST Status of the thread DB2CHAR22 CHAR 
497 DB2CFREAD Coupling factility read misses per second DB2DEC8_2 DEC 
498 DB2CFULLP Total number of prepares: full prepares + short prepares DB2NUMC10 NUMC 
499 DB2CFWRITE Coupling factility write misses per second DB2DEC8_2 DEC 
500 DB2CGETPRA Number of Getpage Requests per Second DB2CHAR10 CHAR