SAP ABAP Data Element - Index D, page 4
Data Element - D
# | Data Element | Short Description | Domain | Data Type |
---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
1 | ![]() |
Average parallel groups | ![]() |
DEC |
2 | ![]() |
Average synchronous reads | ![]() |
DEC |
3 | ![]() |
Average wait for other read | CHAR | |
4 | ![]() |
Average synchronous I/O time | CHAR | |
5 | ![]() |
Average sorts | ![]() |
DEC |
6 | ![]() |
Average synchronous I/Os | CHAR | |
7 | ![]() |
Average DB2 thread size (64 bit) | ![]() |
DEC |
8 | ![]() |
Average tablespace scans | ![]() |
DEC |
9 | ![]() |
Average wait time | ![]() |
DEC |
10 | ![]() |
Average synchronous I/O time | ![]() |
DEC |
11 | ![]() |
Average wait for lock/latch | ![]() |
DEC |
12 | ![]() |
Average wait for EU switch | ![]() |
DEC |
13 | ![]() |
Average wait for global lock | ![]() |
DEC |
14 | ![]() |
Average wait for other read | ![]() |
DEC |
15 | ![]() |
Average wait for other write | ![]() |
DEC |
16 | ![]() |
Average wait time for latch req | ![]() |
DEC |
17 | ![]() |
Average wait time for page latch | ![]() |
DEC |
18 | ![]() |
Average wait time for drain lock | ![]() |
DEC |
19 | ![]() |
Average wait for drain when waiting for claims to be rel. | ![]() |
DEC |
20 | ![]() |
Average wait time | CHAR | |
21 | ![]() |
Average wait time for logwriter | ![]() |
DEC |
22 | ![]() |
Average wait for other write | CHAR | |
23 | ![]() |
Average synchronous writes | ![]() |
DEC |
24 | ![]() |
Number of dynamic prefetch requests | ![]() |
NUMC |
25 | ![]() |
Number of Getpage Requests | ![]() |
NUMC |
26 | ![]() |
Number of Pages Read Asynchronously | ![]() |
NUMC |
27 | ![]() |
Number of Successful Synchronous Hiperpool Reads | ![]() |
NUMC |
28 | ![]() |
Number of Unsuccessful Synchronous Hiperpool Reads | ![]() |
NUMC |
29 | ![]() |
Number of Unsuccessful Synchronous Hiperpool Writes | ![]() |
NUMC |
30 | ![]() |
Number of Successful Synchronous Hiperpool Writes | ![]() |
NUMC |
31 | ![]() |
Number of immediate (synchronous) write I/Os | ![]() |
NUMC |
32 | ![]() |
Number of list prefetch requests | ![]() |
NUMC |
33 | ![]() |
Unsuccesful Page at Conditional Getpage Request | ![]() |
NUMC |
34 | ![]() |
Buffer pool ID | ![]() |
NUMC |
35 | ![]() |
Number of synchronous read I/O operations | ![]() |
NUMC |
36 | ![]() |
Number of sequential prefetch requests | ![]() |
NUMC |
37 | ![]() |
Asynchronous pages read | ![]() |
NUMC |
38 | ![]() |
The number of times a buffer update occurs for the agent | ![]() |
NUMC |
39 | ![]() |
Number of dynamic prefetch requests | ![]() |
INT4 |
40 | ![]() |
Number of Getpage Requests | ![]() |
INT4 |
41 | ![]() |
Number of Pages Read Asynchronously | ![]() |
INT4 |
42 | ![]() |
Number of Successful Synchronous Hiperpool Reads | ![]() |
INT4 |
43 | ![]() |
Number of Unsuccessful Synchronous Hiperpool Reads | ![]() |
INT4 |
44 | ![]() |
Number of Unsuccessful Synchronous Hiperpool Writes | ![]() |
INT4 |
45 | ![]() |
Number of Successful Synchronous Hiperpool Writes | ![]() |
INT4 |
46 | ![]() |
Number of immediate (synchronous) write I/Os | ![]() |
INT4 |
47 | ![]() |
Number of list prefetch requests | ![]() |
INT4 |
48 | ![]() |
Unsuccesful Page at Conditional Getpage Request | ![]() |
INT4 |
49 | ![]() |
Buffer pool ID | ![]() |
INT4 |
50 | ![]() |
Number of synchronous read I/O operations | ![]() |
INT4 |
51 | ![]() |
Number of sequential prefetch requests | ![]() |
INT4 |
52 | ![]() |
Asynchronous pages read | ![]() |
INT4 |
53 | ![]() |
The number of times a buffer update occurs for the agent | ![]() |
INT4 |
54 | ![]() |
Name of the LOB column in the base table causing the LOB TS | ![]() |
CHAR |
55 | ![]() |
Name of the creator of the base table | ![]() |
CHAR |
56 | ![]() |
Name of the database where the base table resides | ![]() |
CHAR |
57 | ![]() |
Partition number of the base table (0 for non-partitioned) | ![]() |
INT2 |
58 | ![]() |
Name of the base table | ![]() |
CHAR |
59 | ![]() |
Name of the tablespace where the base table resides | ![]() |
CHAR |
60 | ![]() |
Date of the last check | ![]() |
DATS |
61 | ![]() |
Time of the last check | ![]() |
TIMS |
62 | ![]() |
Number of write requests to the secondary GBP | ![]() |
DEC |
63 | ![]() |
Number of write requests to the secondary GBP | ![]() |
NUMC |
64 | ![]() |
Number of explicit cross-invalidations | ![]() |
NUMC |
65 | ![]() |
Group buffer pool: Synchronous reads | ![]() |
NUMC |
66 | ![]() |
Group buffer pools: synchronous writes | ![]() |
NUMC |
67 | ![]() |
Number of explicit cross-invalidations | ![]() |
DEC |
68 | ![]() |
Group buffer pool: Synchronous reads | ![]() |
NUMC |
69 | ![]() |
Group buffer pools: synchronous writes | ![]() |
NUMC |
70 | ![]() |
DB2 11 - Castout class level threshold (buffer num) | DEC | |
71 | ![]() |
Directory entry reclaim counter | ![]() |
INT4 |
72 | ![]() |
Data entry reclaim counter | ![]() |
INT4 |
73 | ![]() |
Duplex or simplex indication for the group buffer pool | ![]() |
CHAR |
74 | ![]() |
Current automatic recovery setting for the GBP | ![]() |
CHAR |
75 | ![]() |
GBP checkpoint interval (GBPCHKPT) | ![]() |
INT4 |
76 | ![]() |
Current group buffer pool cache (GBPCACHE) setting | ![]() |
CHAR |
77 | ![]() |
Current group buffer pool cache (GBPCACHE) setting | ![]() |
CHAR |
78 | ![]() |
Class castout threshold (%) | ![]() |
INT4 |
79 | ![]() |
The actual number of allocated directory entries | ![]() |
INT4 |
80 | ![]() |
Number of allocated directory entries in the sec. GBP | ![]() |
INT4 |
81 | ![]() |
The actual number of allocated data entries | ![]() |
INT4 |
82 | ![]() |
Number of data entries allocated for the secondary GBP | ![]() |
INT4 |
83 | ![]() |
Group buffer pool castout threshold (%) | ![]() |
INT4 |
84 | ![]() |
The current directory entry per data entry ratio | ![]() |
CHAR |
85 | ![]() |
The current directory entry per data entry ratio | ![]() |
NUMC |
86 | ![]() |
The pending directory entry per data entry ratio | ![]() |
CHAR |
87 | ![]() |
The pending directory entry per data entry ratio | ![]() |
NUMC |
88 | ![]() |
Allocated group buffer pool size in 4KB increments | ![]() |
INT4 |
89 | ![]() |
Allocated size of the sec. group buffer pool (in 4KB blocks) | ![]() |
INT4 |
90 | ![]() |
Cross-invalidation & directory entry reclaim counter | ![]() |
INT4 |
91 | ![]() |
Total changed counter | ![]() |
INT4 |
92 | ![]() |
Number of requests to delete a list of pages (secondary GBP) | ![]() |
DEC |
93 | ![]() |
Number of write requests to the secondary GBP that failed | ![]() |
DEC |
94 | ![]() |
# Asynch IXLCACHE invocations for secondary GBP | ![]() |
DEC |
95 | ![]() |
Number of requests to delete a page from the secondary GBP | ![]() |
DEC |
96 | ![]() |
Number of requests to read the castout statistics (sec. GBP) | ![]() |
DEC |
97 | ![]() |
Number of requests to write changed pages to the sec. GBP | ![]() |
DEC |
98 | ![]() |
Clean pages written asynchronously | ![]() |
DEC |
99 | ![]() |
Asynchronous reads - data returned | ![]() |
DEC |
100 | ![]() |
Asynchronous read - no data returned - no directory entry | ![]() |
DEC |
101 | ![]() |
Asynchronous read - no data returned | ![]() |
DEC |
102 | ![]() |
Changed pages written asynchronously | ![]() |
DEC |
103 | ![]() |
Register page list request | ![]() |
DEC |
104 | ![]() |
Changed pages - Read after register page list | ![]() |
DEC |
105 | ![]() |
Clean pages read after register page list | ![]() |
DEC |
106 | ![]() |
Read castout class | ![]() |
DEC |
107 | ![]() |
Unregister page | ![]() |
NUMC |
108 | ![]() |
Group buffer pool ID | ![]() |
CHAR |
109 | ![]() |
GBP checkpoints triggered | ![]() |
DEC |
110 | ![]() |
Synchronous read (not found) - Data returned | ![]() |
NUMC |
111 | ![]() |
Synchronous read (not found) - No data returned (no dir) | ![]() |
NUMC |
112 | ![]() |
Synchronous Read (Not Found) - No Data Returned (Dir. Entry) | ![]() |
NUMC |
113 | ![]() |
Number of times castout engine was unavailable | ![]() |
DEC |
114 | ![]() |
Read castout statistics | ![]() |
DEC |
115 | ![]() |
Changed pages written synchronously to GBP | ![]() |
NUMC |
116 | ![]() |
Castout class threshold | ![]() |
DEC |
117 | ![]() |
Clean pages written synchronously | ![]() |
NUMC |
118 | ![]() |
Synchronous read (cross invalidation) - data returned | ![]() |
NUMC |
119 | ![]() |
Synchronous coupling facility read requests - no data | ![]() |
NUMC |
120 | ![]() |
Synchronous Read (Cross Invalidation) - No Data Returned | ![]() |
NUMC |
121 | ![]() |
Unregister page | ![]() |
DEC |
122 | ![]() |
Delete data and directory entries in GBP | ![]() |
DEC |
123 | ![]() |
Number of explicit cross-invalidations | ![]() |
DEC |
124 | ![]() |
Group buffer pool ID | ![]() |
CHAR |
125 | ![]() |
Group buffer pool name | ![]() |
CHAR |
126 | ![]() |
Group buffer pool castout threshold | ![]() |
DEC |
127 | ![]() |
# Asynch IXLCACHE invocations for primary GBP | ![]() |
DEC |
128 | ![]() |
Synchronous read (not found) - Data returned | ![]() |
DEC |
129 | ![]() |
Synchronous read (not found) - No data returned (no dir) | ![]() |
DEC |
130 | ![]() |
Synchronous Read (Not Found) - No Data Returned (Dir. Entry) | ![]() |
DEC |
131 | ![]() |
# page P-lock lock negotiations for space map pages | ![]() |
DEC |
132 | ![]() |
# page P-lock lock negotiations for data pages | ![]() |
DEC |
133 | ![]() |
# page P-lock lock negotiations for index leaf pages | ![]() |
DEC |
134 | ![]() |
CF requests to read storage statistics | ![]() |
DEC |
135 | ![]() |
# page P-lock lock requests for space map pages | ![]() |
DEC |
136 | ![]() |
# page P-lock lock requests for data pages | ![]() |
DEC |
137 | ![]() |
# page P-lock lock requests for index leaf pages | ![]() |
DEC |
138 | ![]() |
Participation in GBP rebuild | ![]() |
DEC |
139 | ![]() |
Pages cast out from GBP to DASD | ![]() |
DEC |
140 | ![]() |
Read directory info | ![]() |
DEC |
141 | ![]() |
Read failed - no storage | ![]() |
DEC |
142 | ![]() |
Register page | ![]() |
DEC |
143 | ![]() |
# page P-lock lock suspensions for space map pages | ![]() |
DEC |
144 | ![]() |
# page P-lock lock suspensions for data pages | ![]() |
DEC |
145 | ![]() |
# page P-lock lock suspensions for index leaf pages | ![]() |
DEC |
146 | ![]() |
Number of times write engine was unavailable | ![]() |
DEC |
147 | ![]() |
Changed pages written synchronously to GBP | ![]() |
DEC |
148 | ![]() |
# page P-lock unlock requests | ![]() |
DEC |
149 | ![]() |
Unlock castout | ![]() |
DEC |
150 | ![]() |
Clean pages written synchronously | ![]() |
DEC |
151 | ![]() |
Write failed - no storage | ![]() |
DEC |
152 | ![]() |
Synchronous read (cross invalidation) - data returned | ![]() |
DEC |
153 | ![]() |
Synchronous coupling facility read requests - no data | ![]() |
DEC |
154 | ![]() |
Synchronous Read (Cross Invalidation) - No Data Returned | ![]() |
DEC |
155 | ![]() |
Percentage of buffers currently in use | ![]() |
DEC |
156 | ![]() |
Field type char, length 1, bit field | ![]() |
CHAR |
157 | ![]() |
Field type char, length 2, bit field | ![]() |
CHAR |
158 | ![]() |
Field type char, length 4, bit field | ![]() |
CHAR |
159 | ![]() |
Field type char, length 6, bit field | ![]() |
CHAR |
160 | ![]() |
bool type | CHAR | |
161 | ![]() |
Active pages | ![]() |
DEC |
162 | ![]() |
Name of the DB2 buffer pool currently used for the TS | ![]() |
CHAR |
163 | ![]() |
Creator of BP tuning settings ( = SAP for default settings ) | ![]() |
CHAR |
164 | ![]() |
Hit ratio | ![]() |
DEC |
165 | ![]() |
DB2 buffer pool name | ![]() |
CHAR |
166 | ![]() |
DB2 buffer pool name | ![]() |
CHAR |
167 | ![]() |
Buffer pool name e.g. BP2, BP8K1 | CHAR | |
168 | ![]() |
Buffer pool shortage | ![]() |
CHAR |
169 | ![]() |
Suggested DB2 buffer pool | ![]() |
CHAR |
170 | ![]() |
Dual bootstrap data set | ![]() |
CHAR |
171 | ![]() |
Bytes sent from the ICLI server to application server | ![]() |
NUMC |
172 | ![]() |
Number of bytes sent to the ICLI server | ![]() |
NUMC |
173 | ![]() |
Asynchronous data mover facility hiperpool reads | ![]() |
DEC |
174 | ![]() |
Number of pages for which a read request failed using DMF | ![]() |
DEC |
175 | ![]() |
Pages moved successfully from virtual pool to hp using DMF | ![]() |
DEC |
176 | ![]() |
Number of pages for which write request failed using DMF | ![]() |
DEC |
177 | ![]() |
DB2 buffer pool name | ![]() |
CHAR |
178 | ![]() |
Number of times a successful buffer pool expansion occurred | ![]() |
NUMC |
179 | ![]() |
Number of currently active (non-stealable) buffers | ![]() |
DEC |
180 | ![]() |
Number of dynamic prefetch reads | ![]() |
DEC |
181 | ![]() |
Number of times the data manager threshold was reached | ![]() |
DEC |
182 | ![]() |
Number of dynamic prefetch requests | ![]() |
DEC |
183 | ![]() |
Number of pages read via dynamic prefetch read I/O | ![]() |
DEC |
184 | ![]() |
Number of datasets successfully opened physically | ![]() |
DEC |
185 | ![]() |
Number of times the deferred write threshold was reached | ![]() |
DEC |
186 | ![]() |
Number of times vertical deferred write threshold is reached | ![]() |
DEC |
187 | ![]() |
Number of times vertical deferred write threshold is reached | ![]() |
NUMC |
188 | ![]() |
Number of get page requests (conditional and unconditional) | ![]() |
DEC |
189 | ![]() |
Number of get page requests (conditional and unconditional) | ![]() |
NUMC |
190 | ![]() |
Number of hp buffers currently backed by expanded storage | ![]() |
DEC |
191 | ![]() |
Buffer hit ratio | CHAR | |
192 | ![]() |
Number of successful hiperpool expansions/contractions | ![]() |
DEC |
193 | ![]() |
Number of buffers allocated for hiperpool | ![]() |
DEC |
194 | ![]() |
Number of successful hiperpool reads done asynchronously | ![]() |
DEC |
195 | ![]() |
Number of successful hiperpool reads | ![]() |
DEC |
196 | ![]() |
Number of unsuccessful hiperpool reads | ![]() |
DEC |
197 | ![]() |
Number of successful hiperpool writes done asynchronously | ![]() |
DEC |
198 | ![]() |
Number of unsuccessful hiperpool writes | ![]() |
DEC |
199 | ![]() |
Number of successful hiperpool writes | ![]() |
DEC |
200 | ![]() |
Number of immediate writes | ![]() |
DEC |
201 | ![]() |
Total number of denied concurrent prefetch I/O streams | ![]() |
DEC |
202 | ![]() |
Number of list prefetch reads | ![]() |
DEC |
203 | ![]() |
Number of list prefetch requests | ![]() |
DEC |
204 | ![]() |
Number of times one or more pages were added to LPL | ![]() |
DEC |
205 | ![]() |
Number of pages read via list prefetch | ![]() |
DEC |
206 | ![]() |
Number of times a work file could not be opened | ![]() |
DEC |
207 | ![]() |
Number of times migrated datasets were encountered | ![]() |
DEC |
208 | ![]() |
# of unsuccessful GETPAGE due conditional GETPAGE request | ![]() |
DEC |
209 | ![]() |
Number of sequential prefetch reads | ![]() |
DEC |
210 | ![]() |
Prefetch quantity is reduced from normal to 50% | ![]() |
DEC |
211 | ![]() |
Number of occurrences of prefetch quantity reduced 1/4 | ![]() |
DEC |
212 | ![]() |
The parallel query went into reduced or degenerated mode | ![]() |
DEC |
213 | ![]() |
Total no. of requests for parallel query support | ![]() |
DEC |
214 | ![]() |
Number of pages written | ![]() |
DEC |
215 | ![]() |
Sequential prefetch disabled - unavailable read engine | ![]() |
DEC |
216 | ![]() |
Number of synchronous read I/O operations | ![]() |
DEC |
217 | ![]() |
Number of synchronous read I/O operations | ![]() |
NUMC |
218 | ![]() |
Number of page inserts required for read I/O | ![]() |
DEC |
219 | ![]() |
Number of recall timeouts | ![]() |
DEC |
220 | ![]() |
Number of sequential prefetch requests | ![]() |
DEC |
221 | ![]() |
Number of get page requests issued by sequential access req. | ![]() |
DEC |
222 | ![]() |
Synchronous read requests issued by sequential access req. | ![]() |
DEC |
223 | ![]() |
Sequential prefetch disabled - no buffers available | ![]() |
DEC |
224 | ![]() |
Number of pages read because of normal sequential prefetch | ![]() |
DEC |
225 | ![]() |
Update intents against pages in the buffer pool | ![]() |
DEC |
226 | ![]() |
Number of successful virtual buffer pool expans./contract. | ![]() |
DEC |
227 | ![]() |
Number of buffers allocated for virtual buffer pool | ![]() |
DEC |
228 | ![]() |
Number of Pages Removed from the DWQ for Destructive Read | ![]() |
DEC |
229 | ![]() |
Number of pages for which destructive read was requested | ![]() |
DEC |
230 | ![]() |
A write engine is unavailable for asynchronous write I/O | ![]() |
DEC |
231 | ![]() |
Work file requests were rejected due to buffer pool shortage | ![]() |
DEC |
232 | ![]() |
Number of times a merge pass could not be performed | ![]() |
DEC |
233 | ![]() |
Maximum number of work files concurrently used | ![]() |
DEC |
234 | ![]() |
Number of merge passes requested for DB2 sort activities | ![]() |
DEC |
235 | ![]() |
Number of merge passes requested for DB2 sort activities | ![]() |
DEC |
236 | ![]() |
Number of asynchronous writes | ![]() |
DEC |
237 | ![]() |
Number of work prefetches not scheduled due to zero prefetch | ![]() |
DEC |
238 | ![]() |
Number of page inserts required for write I/O | ![]() |
DEC |
239 | ![]() |
Number of times the virtual buffer pool was full | ![]() |
DEC |
240 | ![]() |
Total number of virtual buffer pool or hiperpool failures | ![]() |
DEC |
241 | ![]() |
Highest number of concurrent prefetch I/O streams | ![]() |
DEC |
242 | ![]() |
DB2/390: Buffer pool | ![]() |
CHAR |
243 | ![]() |
Buffer Update Rate | ![]() |
DEC |
244 | ![]() |
Navigation button of st04 subsystem activity overview panel | ![]() |
CHAR |
245 | ![]() |
Display database: # of commands | ![]() |
NUMC |
246 | ![]() |
DISPLAY THREAD: # of commands | ![]() |
NUMC |
247 | ![]() |
DISPLAY UTILITY: # of commands | ![]() |
NUMC |
248 | ![]() |
RECOVER BSDS: # of commands | ![]() |
NUMC |
249 | ![]() |
RECOUVER INDOUBT: # of commands | ![]() |
NUMC |
250 | ![]() |
START DATABASE: # of commands | ![]() |
NUMC |
251 | ![]() |
START TRACE: # of commands | ![]() |
NUMC |
252 | ![]() |
START DB2: # of commands | ![]() |
NUMC |
253 | ![]() |
STOP DATABASE: # of commands | ![]() |
NUMC |
254 | ![]() |
STOP TRACE: # of commands | ![]() |
NUMC |
255 | ![]() |
STOP DB2: # of commands | ![]() |
NUMC |
256 | ![]() |
TERM UTLITY: # of commands | ![]() |
NUMC |
257 | ![]() |
DISPLAY TRACE: # of commands | ![]() |
NUMC |
258 | ![]() |
RESET GENERICLU: # of commands | ![]() |
NUMC |
259 | ![]() |
START RLIMIT: # of commands | ![]() |
NUMC |
260 | ![]() |
STOP RLIMIT: # of commands | ![]() |
NUMC |
261 | ![]() |
DISPLAY RLIMIT: # of commands | ![]() |
NUMC |
262 | ![]() |
MODIFY TRACE: # of commands | ![]() |
NUMC |
263 | ![]() |
START DDF: # of commands | ![]() |
NUMC |
264 | ![]() |
STOP DDF: # of commands | ![]() |
NUMC |
265 | ![]() |
CANCEL THREAD: # of commands | ![]() |
NUMC |
266 | ![]() |
DISPLAY LOCATION: # of commands | ![]() |
NUMC |
267 | ![]() |
ARCHIVE LOG: # of commands | ![]() |
NUMC |
268 | ![]() |
ALTER BUFFERPOOL: # of commands | ![]() |
NUMC |
269 | ![]() |
DISPLAY BUFFERPOOL: # of commands | ![]() |
NUMC |
270 | ![]() |
SET ARCHIVE: # of commands | ![]() |
NUMC |
271 | ![]() |
DISPLAY ARCHIVE: # of commands | ![]() |
NUMC |
272 | ![]() |
RESET INDOUBT: # of commands | ![]() |
NUMC |
273 | ![]() |
ALTER GROUPBUFFERPOOL: # of commands | ![]() |
NUMC |
274 | ![]() |
DISPLAY GROUPBUFFERPOOL: # of comands | ![]() |
NUMC |
275 | ![]() |
DISPLAY PROCEDURE: # of commands | ![]() |
NUMC |
276 | ![]() |
START PROCEDURE: # of commands | ![]() |
NUMC |
277 | ![]() |
STOP PROCEDURE: # of commands | ![]() |
NUMC |
278 | ![]() |
Number of -DISPLAY FUNCTION commands | ![]() |
NUMC |
279 | ![]() |
Number of -START FUNCTION commands | ![]() |
NUMC |
280 | ![]() |
Number of -STOP FUNCTION commands | ![]() |
NUMC |
281 | ![]() |
Number of -SET LOG commands | ![]() |
NUMC |
282 | ![]() |
Number of -DISPLAY LOG commands | ![]() |
NUMC |
283 | ![]() |
Unrecognized commands | ![]() |
NUMC |
284 | ![]() |
Number of rows in the tablespace or partition | INT4 | |
285 | ![]() |
Cardinality | DEC | |
286 | ![]() |
Total number of rows in the table | ![]() |
FLTP |
287 | ![]() |
Total number of rows in the table | ![]() |
DEC |
288 | ![]() |
Application server host name | ![]() |
CHAR |
289 | ![]() |
Cached pages | ![]() |
DEC |
290 | ![]() |
Average of stored procedures | ![]() |
CHAR |
291 | ![]() |
Number of stored procedures | ![]() |
NUMC |
292 | ![]() |
Percent of time spent in DB2 for stored procedures | ![]() |
CHAR |
293 | ![]() |
Directory entry reclaim counter | ![]() |
NUMC |
294 | ![]() |
Data entry reclaim counter | ![]() |
NUMC |
295 | ![]() |
Duplex or simplex indication for the group buffer pool | ![]() |
CHAR |
296 | ![]() |
Current automatic recovery setting for the GBP | ![]() |
CHAR |
297 | ![]() |
Current group buffer pool cache (GBPCACHE) setting | ![]() |
CHAR |
298 | ![]() |
GBP checkpoint interval (GBPCHKPT) | ![]() |
NUMC |
299 | ![]() |
Class castout threshold (%) | ![]() |
NUMC |
300 | ![]() |
Number of allocated directory entries in the sec. GBP | ![]() |
NUMC |
301 | ![]() |
The actual number of allocated directory entries | ![]() |
NUMC |
302 | ![]() |
The actual number of allocated data entries | ![]() |
NUMC |
303 | ![]() |
Group buffer pool castout threshold (%) | ![]() |
NUMC |
304 | ![]() |
The current directory entry per data entry ratio | ![]() |
NUMC |
305 | ![]() |
The pending directory entry per data entry ratio | ![]() |
NUMC |
306 | ![]() |
Allocated size of the sec. group buffer pool (in 4KB blocks) | ![]() |
NUMC |
307 | ![]() |
Allocated group buffer pool size in 4KB increments | ![]() |
NUMC |
308 | ![]() |
Number of data entries allocated for the secondary GBP | ![]() |
NUMC |
309 | ![]() |
Cross-invalidation & directory entry reclaim counter | ![]() |
NUMC |
310 | ![]() |
Total changed counter | ![]() |
NUMC |
311 | ![]() |
Group buffer pool ID | ![]() |
CHAR |
312 | ![]() |
Percentage of Buffers Currently in Use | ![]() |
CHAR |
313 | ![]() |
Field type char, length 1, bit field | ![]() |
CHAR |
314 | ![]() |
Field type char, length 2, bit field | ![]() |
CHAR |
315 | ![]() |
Field type char, length 4, bit field | ![]() |
CHAR |
316 | ![]() |
Field type char, length 6, bit field | ![]() |
CHAR |
317 | ![]() |
DB2 buffer pool name | ![]() |
CHAR |
318 | ![]() |
Asynchronous data mover facility hiperpool reads | ![]() |
NUMC |
319 | ![]() |
Number of pages for which a read request failed using DMF | ![]() |
DEC |
320 | ![]() |
Pages moved successfully from virtual pool to hp using DMF | ![]() |
NUMC |
321 | ![]() |
Number of pages for which write request failed using DMF | ![]() |
NUMC |
322 | ![]() |
DB2 buffer pool name | ![]() |
CHAR |
323 | ![]() |
Number of currently active (non-stealable) buffers | ![]() |
NUMC |
324 | ![]() |
Number of dynamic prefetch reads | ![]() |
NUMC |
325 | ![]() |
Number of times the data manager threshold was reached | ![]() |
NUMC |
326 | ![]() |
Number of dynamic prefetch requests | ![]() |
NUMC |
327 | ![]() |
Number of pages read via dynamic prefetch read I/O | ![]() |
NUMC |
328 | ![]() |
Number of datasets successfully opened physically | ![]() |
NUMC |
329 | ![]() |
Number of times the deferred write threshold was reached | ![]() |
NUMC |
330 | ![]() |
Number of times vertical deferred write threshold is reached | ![]() |
NUMC |
331 | ![]() |
Number of get page requests (conditional and unconditional) | ![]() |
NUMC |
332 | ![]() |
Number of hp buffers currently backed by expanded storage | ![]() |
NUMC |
333 | ![]() |
Buffer hit ratio | ![]() |
CHAR |
334 | ![]() |
Number of successful hiperpool expansions/contractions | ![]() |
NUMC |
335 | ![]() |
Number of buffers allocated for hiperpool | ![]() |
NUMC |
336 | ![]() |
Number of successful hiperpool reads done asynchronously | ![]() |
NUMC |
337 | ![]() |
Number of successful hiperpool reads | ![]() |
NUMC |
338 | ![]() |
Number of unsuccessful hiperpool reads | ![]() |
NUMC |
339 | ![]() |
Number of successful hiperpool writes done asynchronously | ![]() |
NUMC |
340 | ![]() |
Number of unsuccessful hiperpool writes | ![]() |
NUMC |
341 | ![]() |
Number of successful hiperpool writes | ![]() |
NUMC |
342 | ![]() |
Number of immediate writes | ![]() |
NUMC |
343 | ![]() |
Total number of denied concurrent prefetch I/O streams | ![]() |
NUMC |
344 | ![]() |
Number of list prefetch reads | ![]() |
NUMC |
345 | ![]() |
Number of list prefetch requests | ![]() |
NUMC |
346 | ![]() |
Number of pages read via list prefetch | ![]() |
NUMC |
347 | ![]() |
Number of times a work file could not be opened | ![]() |
NUMC |
348 | ![]() |
Number of times migrated datasets were encountered | ![]() |
NUMC |
349 | ![]() |
Number of sequential prefetch reads | ![]() |
NUMC |
350 | ![]() |
Prefetch quantity is reduced from normal to 50% | ![]() |
NUMC |
351 | ![]() |
Number of occurrences of prefetch quantity reduced 1/4 | ![]() |
NUMC |
352 | ![]() |
The parallel query went into reduced or degenerated mode | ![]() |
NUMC |
353 | ![]() |
Total no. of requests for parallel query support | ![]() |
NUMC |
354 | ![]() |
Number of pages written | ![]() |
NUMC |
355 | ![]() |
Sequential prefetch disabled - unavailable read engine | ![]() |
NUMC |
356 | ![]() |
Number of synchronous read I/O operations | ![]() |
NUMC |
357 | ![]() |
Number of page inserts required for read I/O | ![]() |
NUMC |
358 | ![]() |
Number of recall timeouts | ![]() |
NUMC |
359 | ![]() |
Number of sequential prefetch requests | ![]() |
NUMC |
360 | ![]() |
Number of get page requests issued by sequential access req. | ![]() |
NUMC |
361 | ![]() |
Synchronous read requests issued by sequential access req. | ![]() |
NUMC |
362 | ![]() |
Sequential prefetch disabled - no buffers available | ![]() |
NUMC |
363 | ![]() |
Number of pages read because of normal sequential prefetch | ![]() |
NUMC |
364 | ![]() |
Update intents against pages in the buffer pool | ![]() |
NUMC |
365 | ![]() |
Number of successful virtual buffer pool expans./contract. | ![]() |
NUMC |
366 | ![]() |
Number of buffers allocated for virtual buffer pool | ![]() |
NUMC |
367 | ![]() |
Number of Pages Removed from the DWQ for Destructive Read | ![]() |
NUMC |
368 | ![]() |
Number of pages for which destructive read was requested | ![]() |
NUMC |
369 | ![]() |
A write engine is unavailable for asynchronous write I/O | ![]() |
NUMC |
370 | ![]() |
Work file requests were rejected due to buffer pool shortage | ![]() |
NUMC |
371 | ![]() |
Number of times a merge pass could not be performed | ![]() |
NUMC |
372 | ![]() |
Maximum number of work files concurrently used | ![]() |
NUMC |
373 | ![]() |
Number of merge passes requested for DB2 sort activities | ![]() |
NUMC |
374 | ![]() |
Number of merge passes requested for DB2 sort activities | ![]() |
NUMC |
375 | ![]() |
Number of asynchronous writes | ![]() |
NUMC |
376 | ![]() |
Number of work prefetches not scheduled due to zero prefetch | ![]() |
NUMC |
377 | ![]() |
Number of page inserts required for write I/O | ![]() |
NUMC |
378 | ![]() |
Number of times the virtual buffer pool was full | ![]() |
NUMC |
379 | ![]() |
Total number of virtual buffer pool or hiperpool failures | ![]() |
NUMC |
380 | ![]() |
Highest number of concurrent prefetch I/O streams | ![]() |
NUMC |
381 | ![]() |
Buffer Update Rate | ![]() |
CHAR |
382 | ![]() |
REORG Index: Appended rows (with greater key) in percent | INT4 | |
383 | ![]() |
Associated tablespace for indexspace | ![]() |
CHAR |
384 | ![]() |
Full/Inc. Copy: Changed rows in percent | INT4 | |
385 | ![]() |
Full Copy: Number of days since last COPY | INT4 | |
386 | ![]() |
Degree of checking before invocation of stored procedure | INT4 | |
387 | ![]() |
RUN.:Changed rows (insert, delete or update) absolute number | ![]() |
FLTP |
388 | ![]() |
Full/Inc. Copy, REORG, RUNSTATS: Changed rows in percent | ![]() |
NUMC |
389 | ![]() |
COPY recommendation: FUL(TS), INC(TS), YES(IX) or NO(Both) | ![]() |
CHAR |
390 | ![]() |
Timestamp of last full image COPY | ![]() |
CHAR |
391 | ![]() |
Number of minutes between two resynchronization intervals | ![]() |
NUMC |
392 | ![]() |
Number of days sice last COPY, RUNSTATS or REORG | ![]() |
INT4 |
393 | ![]() |
DSNACCMO: Escape character code of DB2 server | ![]() |
CHAR |
394 | ![]() |
Defined in exceptiontable: YES, NO, QUERY or NULL(no exctab) | ![]() |
CHAR |
395 | ![]() |
Number of allowable dataset extents | INT4 | |
396 | ![]() |
Extentlimit was exceeded: YES or NO | ![]() |
CHAR |
397 | ![]() |
Number of physical extents in TS, IS or partition | ![]() |
INT2 |
398 | ![]() |
DSNACCDL: List Generations of specif. generation data group? | ![]() |
CHAR |
399 | ![]() |
Field type char, length 1 | ![]() |
CHAR |
400 | ![]() |
Field type char, length 2 | ![]() |
CHAR |
401 | ![]() |
Field type char, length 3 | ![]() |
CHAR |
402 | ![]() |
Field type char, length 4 | ![]() |
CHAR |
403 | ![]() |
Field type char, length 8 | ![]() |
CHAR |
404 | ![]() |
Field type char, length 12 | ![]() |
CHAR |
405 | ![]() |
Field type char, length 16 | ![]() |
CHAR |
406 | ![]() |
Field type char, length 22 | ![]() |
CHAR |
407 | ![]() |
Types of image copies to be considered for recommendation | ![]() |
CHAR |
408 | ![]() |
REORG TS: Indirect references (overflow records) in percent | INT4 | |
409 | ![]() |
Reason code for the IFI call | INT4 | |
410 | ![]() |
Return code for the IFI call | INT4 | |
411 | ![]() |
Full Copy: Minimum size of index in pages (NACTIVE) | INT4 | |
412 | ![]() |
DSNACCJP: Status of the JCL Job | INT4 | |
413 | ![]() |
REORG Indx: Pages phys. far away (INDEXPART.LEAFFAR) percent | INT4 | |
414 | ![]() |
REORG Index: Change to number of index tree levels absolute | INT4 | |
415 | ![]() |
REORG TS: Disorganized LOBs in percent | INT4 | |
416 | ![]() |
Last statement executed by DSNACCAV stored procedures | CHAR | |
417 | ![]() |
Timestamp of last LOAD REPLACE | ![]() |
CHAR |
418 | ![]() |
Number of mass deletes (segm./LOB) / table drops (non-segm.) | INT4 | |
419 | ![]() |
DSNACCMO: Maximum number of parallel subtasks | ![]() |
INT2 |
420 | ![]() |
DSNACCMO: Highest return code of DSNUTILS for all utilities | INT4 | |
421 | ![]() |
DSNACCDL: Max number of the temporary results table's rows | INT4 | |
422 | ![]() |
DSNACCJP: Maximum awaiting time for completion | INT4 | |
423 | ![]() |
DSNACCMO: Error information | LCHR | |
424 | ![]() |
Area of the CC stored procedures output values | CHAR | |
425 | ![]() |
DSNACCMO: Name of the object to be treated | ![]() |
CHAR |
426 | ![]() |
ID of the DB object as input for stored procedure DSNACCMO | INT4 | |
427 | ![]() |
DB2 object status: NULL, restricted states or orphaned | ![]() |
CHAR |
428 | ![]() |
DB2 object type: TS for tablespace, IX for indexspace | ![]() |
CHAR |
429 | ![]() |
DSNACCMO: Number of input objects to be treated by utilities | INT4 | |
430 | ![]() |
DSNACCJP: Requested operation - Cancel, Purge or Query | INT4 | |
431 | ![]() |
DSNACCMO: Optimize runtime by sorting workload | ![]() |
CHAR |
432 | ![]() |
DSNACCDS: Processing option | ![]() |
CHAR |
433 | ![]() |
REORG Recommendation: YES or NO | ![]() |
CHAR |
434 | ![]() |
Timestamp of last REORG | ![]() |
CHAR |
435 | ![]() |
Most recent image copy type | ![]() |
CHAR |
436 | ![]() |
Types of objects who are considered for recommendation | ![]() |
CHAR |
437 | ![]() |
DSNACCMO: Returned utility output | ![]() |
CHAR |
438 | ![]() |
DSNACCMO: Number of parallel tasks actually started | ![]() |
INT2 |
439 | ![]() |
DSNACCDL: Level of the parameter list. | INT4 | |
440 | ![]() |
Data set number or partition number | ![]() |
INT2 |
441 | ![]() |
DSNACCDL: List MEMBERS of specified dat set? | ![]() |
CHAR |
442 | ![]() |
REORG Index: Pseudo deletes in percent | INT4 | |
443 | ![]() |
User pword | ![]() |
CHAR |
444 | ![]() |
Type of the Stored Procedure to run | ![]() |
CHAR |
445 | ![]() |
DSNACCAV stored procedure return code | INT4 | |
446 | ![]() |
REO.:Changed rows (insert, delete or update) absolute number | INT4 | |
447 | ![]() |
REORG TS/IX: Changed rows in percent | INT4 | |
448 | ![]() |
Recommendation RUNSTATS/REORG: YES or NO | ![]() |
CHAR |
449 | ![]() |
DB2/zOS: Number of REORG recommendations by DSNACCOR | INT4 | |
450 | ![]() |
DSNACCMO: Save restart info for stopped utilities | ![]() |
CHAR |
451 | ![]() |
Return code of stored procedure | INT4 | |
452 | ![]() |
REORG:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | INT4 | |
453 | ![]() |
REORG TS/IX: Number of active pages | INT4 | |
454 | ![]() |
Timestamp of last REBUILD INDEX | ![]() |
CHAR |
455 | ![]() |
Schema name to qualify tables (statistics, catalog, created) | ![]() |
CHAR |
456 | ![]() |
RUNSTATS TS/IX: Changed rows in percent | INT4 | |
457 | ![]() |
DSNACCMO: Concatenate 2 IDs as Table key: ID1*10^10 + ID2 | NUMC | |
458 | ![]() |
DSNACCMO: Sequence number for large statements | INT4 | |
459 | ![]() |
DSNACCMO/DS: Sequence number | INT4 | |
460 | ![]() |
RUNST:Number of mass del. (seg./LOB) / tabledrops (non-seg.) | INT4 | |
461 | ![]() |
RUNSTATS Recommendation: YES or NO | ![]() |
CHAR |
462 | ![]() |
Timestamp of last RUNSTATS | ![]() |
CHAR |
463 | ![]() |
ID of utility statement as input for stored proc. DSNACCMO | INT4 | |
464 | ![]() |
DSNACCMO: (Part of) utility statement | CHAR | |
465 | ![]() |
DSNACCMO: Utility condition, which will stop procedure | ![]() |
CHAR |
466 | ![]() |
DSNACCMO: Use template dynamic allocation | ![]() |
CHAR |
467 | ![]() |
DSNACCMO: Timeout (in seconds) before cancelling DSNACCMO | ![]() |
INT2 |
468 | ![]() |
DSNACCDL/DS: Switch Trace on? | ![]() |
CHAR |
469 | ![]() |
Timestamp of last execution of utility as per component name | ![]() |
CHAR |
470 | ![]() |
DSNACCMO: Type of object for utility invocation | ![]() |
CHAR |
471 | ![]() |
z/OS user ID | ![]() |
CHAR |
472 | ![]() |
REORG TS: Unclustered inserts in percent | INT4 | |
473 | ![]() |
DSNACCMO: Number of actual utility executions | INT4 | |
474 | ![]() |
Full/Inc. Copy: Updated pages in percent of preformatted pag | INT4 | |
475 | ![]() |
DSNACCMO: Utility-ID stem | ![]() |
CHAR |
476 | ![]() |
DSNUTILS: Highest return code for the utility | INT4 | |
477 | ![]() |
Where clause for the Control Center stored procedures | ![]() |
CHAR |
478 | ![]() |
Number of minutes between two resynchronization intervals | ![]() |
NUMC |
479 | ![]() |
Number of bytes that did not fit in the IFI return area | INT4 | |
480 | ![]() |
Field type date, YYYYMMDD | ![]() |
DATS |
481 | ![]() |
CASTOUT attribute | ![]() |
CHAR |
482 | ![]() |
The deferred write threshold for the virtual buffer pool | ![]() |
NUMC |
483 | ![]() |
The sequential steal threshold for the hiperpool | ![]() |
NUMC |
484 | ![]() |
The size of the hiperpool | ![]() |
NUMC |
485 | ![]() |
Name of buffer pool | ![]() |
CHAR |
486 | ![]() |
Page stealing algorithm to be used for the virtual BP | ![]() |
CHAR |
487 | ![]() |
Parallel I/O sequential steal threshold for virtual BP | ![]() |
NUMC |
488 | ![]() |
Pool vertical write threshold in number of buffers | ![]() |
NUMC |
489 | ![]() |
The vertical deferred write threshold for the virtual BP | ![]() |
NUMC |
490 | ![]() |
The sequential steal threshold for the virtual buffer pool | ![]() |
NUMC |
491 | ![]() |
Type of virtual buffer pool | ![]() |
CHAR |
492 | ![]() |
Type of virtual buffer pool | ![]() |
CHAR |
493 | ![]() |
The size of the virtual buffer pool | ![]() |
NUMC |
494 | ![]() |
Assisting parallel sequential threshold | ![]() |
NUMC |
495 | ![]() |
Percentage of space occupied by rows of dropped tables | ![]() |
INT2 |
496 | ![]() |
Status of the thread | ![]() |
CHAR |
497 | ![]() |
Coupling factility read misses per second | ![]() |
DEC |
498 | ![]() |
Total number of prepares: full prepares + short prepares | ![]() |
NUMC |
499 | ![]() |
Coupling factility write misses per second | ![]() |
DEC |
500 | ![]() |
Number of Getpage Requests per Second | ![]() |
CHAR |