SAP ABAP Data Element - Index D, page 7
Data Element - D
# | Data Element | Short Description | Domain | Data Type |
---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
1 | ![]() |
Statement text | CHAR | |
2 | ![]() |
DB2 statement name | ![]() |
RAW |
3 | ![]() |
Statement ID | ![]() |
INT4 |
4 | ![]() |
Number of tablespace scans performed for statement | ![]() |
DEC |
5 | ![]() |
Current Copies | ![]() |
DEC |
6 | ![]() |
Synchronous Writes | ![]() |
DEC |
7 | ![]() |
Unit in which primary and secondary allocation are given | ![]() |
CHAR |
8 | ![]() |
Unit of primary and secondary allocation (Format CHAR9) | ![]() |
CHAR |
9 | ![]() |
DB2 OS/390: Number to generate unique qual. for DB2 object | ![]() |
NUMC |
10 | ![]() |
Status if is a tablespace or an index | ![]() |
CHAR |
11 | ![]() |
Value for DB2 special register CURRENT QUERY ACCELERATION | CHAR | |
12 | ![]() |
Occurences in respective latch level per second | ![]() |
DEC |
13 | ![]() |
Accumulated CPU Time | ![]() |
DEC |
14 | ![]() |
Length of program name | ![]() |
INT2 |
15 | ![]() |
Length of transaction name | ![]() |
INT2 |
16 | ![]() |
Length of user ID | ![]() |
INT2 |
17 | ![]() |
Statement Line Number | ![]() |
INT4 |
18 | ![]() |
RID List Not Used due to Insufficient Storage | ![]() |
DEC |
19 | ![]() |
RID List Not Used due to DB2 Limits Exceeded | ![]() |
DEC |
20 | ![]() |
Program name | ![]() |
CHAR |
21 | ![]() |
Transaction name | ![]() |
CHAR |
22 | ![]() |
User ID | ![]() |
CHAR |
23 | ![]() |
Name of the table referenced in the statement | ![]() |
CHAR |
24 | ![]() |
Time when stmt was inserted into cache - stored clock format | CHAR | |
25 | ![]() |
Time when stmt was inserted into cache - stored clock format | RAW | |
26 | ![]() |
Timestamp: Begin of Statistics Collection | ![]() |
DEC |
27 | ![]() |
SAP provided identification of SQL statements | ![]() |
CHAR |
28 | ![]() |
Date/Time when stmt stat was updated -in stored clock format | CHAR | |
29 | ![]() |
Time when the stmt stat was updated - stored clock format | RAW | |
30 | ![]() |
Date/Time when the stmt stat was updated -in external format | CHAR | |
31 | ![]() |
Date/Time when the stmt stat was updated -in external format | RAW | |
32 | ![]() |
Accumulated Wait Time for Synchronous I/O | ![]() |
DEC |
33 | ![]() |
Accumulated Wait Time for Lock and Latch Req. | ![]() |
DEC |
34 | ![]() |
Accumulated Wait Time for Sync. Execution Unit Switch | ![]() |
DEC |
35 | ![]() |
Accumulated Wait Time for Global Locks | ![]() |
DEC |
36 | ![]() |
Accumulated Wait Time for Read Activity by Another Thread | ![]() |
DEC |
37 | ![]() |
Accumulated Wait Time for Write Activity by Another Thread | ![]() |
DEC |
38 | ![]() |
Accumulated wait time for latch req | DEC | |
39 | ![]() |
Accumulated wait time for latch req | CHAR | |
40 | ![]() |
Accumulated wait time for page latch | DEC | |
41 | ![]() |
Accumulated wait time for page latch | CHAR | |
42 | ![]() |
Accumulated wait time for drain lock | DEC | |
43 | ![]() |
Accumulated wait time for drain lock | CHAR | |
44 | ![]() |
Acc. wait for drain when waiting for claims to be released | DEC | |
45 | ![]() |
Acc. wait for drain when waiting for claims to be released | CHAR | |
46 | ![]() |
Accumulated wait time for logwriter | DEC | |
47 | ![]() |
Accumulated wait time for logwriter | CHAR | |
48 | ![]() |
User group | ![]() |
CHAR |
49 | ![]() |
The value of QUALIFIER bind option | ![]() |
CHAR |
50 | ![]() |
ISOLATION | ![]() |
CHAR |
51 | ![]() |
CURRENTDATA | ![]() |
CHAR |
52 | ![]() |
DYNAMICRULES | ![]() |
CHAR |
53 | ![]() |
CURRENT DEGREE | ![]() |
CHAR |
54 | ![]() |
CURRENT RULES | ![]() |
CHAR |
55 | ![]() |
CURRENT PRECISION | ![]() |
CHAR |
56 | ![]() |
WITH HOLD | ![]() |
CHAR |
57 | ![]() |
ENDuser ID - Value provided on RRS (re)signon | CHAR | |
58 | ![]() |
Workstation name - Value provided on RRS (re)signon | CHAR | |
59 | ![]() |
Name of SQL statement (long text) | ![]() |
CHAR |
60 | ![]() |
Accumulated CPU Time | ![]() |
INT4 |
61 | ![]() |
Accumulated CPU Time | ![]() |
INT4 |
62 | ![]() |
Accumulated Wait Time for Synchronous I/O | ![]() |
INT4 |
63 | ![]() |
Accumulated Wait Time for Synchronous I/O | ![]() |
INT4 |
64 | ![]() |
Accumulated Wait Time for Synchronous I/O | CHAR | |
65 | ![]() |
Accumulated Wait Time for Lock and Latch Req. | ![]() |
INT4 |
66 | ![]() |
Accumulated Wait Time for Lock and Latch Req. | ![]() |
INT4 |
67 | ![]() |
Accumulated Wait Time for Lock and Latch Req. | CHAR | |
68 | ![]() |
Accumulated Wait Time for Sync. Execution Unit Switch | ![]() |
INT4 |
69 | ![]() |
Accumulated Wait Time for Sync. Execution Unit Switch | ![]() |
INT4 |
70 | ![]() |
Accumulated Wait Time for Sync. Execution Unit Switch | CHAR | |
71 | ![]() |
Accumulated Wait Time for Global Locks | ![]() |
INT4 |
72 | ![]() |
Accumulated Wait Time for Global Locks | ![]() |
INT4 |
73 | ![]() |
Accumulated Wait Time for Global Locks | CHAR | |
74 | ![]() |
Accumulated Wait Time for Read Activity by Another Thread | ![]() |
INT4 |
75 | ![]() |
Accumulated Wait Time for Read Activity by Another Thread | ![]() |
INT4 |
76 | ![]() |
Accumulated Wait Time for Read Activity by Another Thread | CHAR | |
77 | ![]() |
Accumulated Wait Time for Write Activity by Another Thread | ![]() |
INT4 |
78 | ![]() |
Accumulated Wait Time for Write Activity by Another Thread | ![]() |
INT4 |
79 | ![]() |
Accumulated Wait Time for Write Activity by Another Thread | CHAR | |
80 | ![]() |
Amount of space above MVS and critical space | ![]() |
NUMC |
81 | ![]() |
Maximum number of concurrent connections from batch jobs | ![]() |
NUMC |
82 | ![]() |
Amount of space above MVS and critical space | ![]() |
INT4 |
83 | ![]() |
Total free space in the R/3 System (KB) | ![]() |
DEC |
84 | ![]() |
Percentage of used size to allocated size of the R/3 System | ![]() |
DEC |
85 | ![]() |
Total size allocated by the R/3 System (KB) | ![]() |
DEC |
86 | ![]() |
Number of failures in adding an entry to authorization cache | ![]() |
INT4 |
87 | ![]() |
Number of authorization ID overrides in authorization cache | ![]() |
INT4 |
88 | ![]() |
Number of routine entry overrides in authorization cache | ![]() |
INT4 |
89 | ![]() |
Number of successful public authorization checks | ![]() |
INT4 |
90 | ![]() |
Average elapsed time | ![]() |
DEC |
91 | ![]() |
Average elapsed time / row | ![]() |
DEC |
92 | ![]() |
Number of authorization checks without authorization cache | ![]() |
INT4 |
93 | ![]() |
Field type raw, length 2, 1 byte | ![]() |
RAW |
94 | ![]() |
Field type raw, length 8, 4 bytes | ![]() |
INT4 |
95 | ![]() |
RFC - raw 1 | ![]() |
RAW |
96 | ![]() |
RBA Format | CHAR | |
97 | ![]() |
Creator of the index that is to be rebuilt | ![]() |
CHAR |
98 | ![]() |
Database to which the tablespace belongs | ![]() |
CHAR |
99 | ![]() |
Name of the index to be rebuilt | ![]() |
CHAR |
100 | ![]() |
Partition of the index that is to be rebuilt | ![]() |
INT2 |
101 | ![]() |
Table space from which all indexes are to be rebuilt | ![]() |
CHAR |
102 | ![]() |
Index definitions for the REBUILD INDEX statement | ![]() |
CHAR |
103 | ![]() |
Controls the collection of frequent value statistics | ![]() |
CHAR |
104 | ![]() |
Device on which the SYSRCPY1 dataset resides | ![]() |
CHAR |
105 | ![]() |
Dataset allocated to the SYSRCPY1 DDNAME | ![]() |
CHAR |
106 | ![]() |
Primary space allocation for the SYSRCPY1 dataset (cyl.) | ![]() |
INT2 |
107 | ![]() |
Device on which the SYSRCPY2 dataset resides | ![]() |
CHAR |
108 | ![]() |
Dataset allocated to the SYSRCPY2 DDNAME | ![]() |
CHAR |
109 | ![]() |
Whether copy2 archive logs are read first | ![]() |
CHAR |
110 | ![]() |
Primary space allocation for the SYSRCPY2 dataset (cyl.) | ![]() |
INT2 |
111 | ![]() |
IFI DB Trace: Return Code | ![]() |
CHAR |
112 | ![]() |
Specifies that the recovery process is to continue | ![]() |
CHAR |
113 | ![]() |
Recover to a particular image copy dataset | ![]() |
CHAR |
114 | ![]() |
Name of the database the tablespace belongs to | ![]() |
CHAR |
115 | ![]() |
Partition or dataset that is to be recovered | ![]() |
CHAR |
116 | ![]() |
ERROR RANGE option of the RECOVER TABLESPACE utility | ![]() |
CHAR |
117 | ![]() |
LOGONLY option of the RECOVER TABLESPACE utility | ![]() |
CHAR |
118 | ![]() |
Specifies a point on the log to recover to | ![]() |
RAW |
119 | ![]() |
Specifies a particular page to be recovered | INT4 | |
120 | ![]() |
Point on the log to recover to | ![]() |
RAW |
121 | ![]() |
File sequence number of the image copy dataset | ![]() |
NUMC |
122 | ![]() |
Site (local or recovery) from which the copies are used | ![]() |
CHAR |
123 | ![]() |
Name of the tablespace to be recovered | ![]() |
CHAR |
124 | ![]() |
Identifies the image copy dataset | ![]() |
CHAR |
125 | ![]() |
Read rate per second | ![]() |
DEC |
126 | ![]() |
Pages read vs. pages written | INT4 | |
127 | ![]() |
Real storage in use for 64-bit - used by DB2 buffer pools | ![]() |
DEC |
128 | ![]() |
Reason running utility is recommended | ![]() |
CHAR |
129 | ![]() |
![]() |
INT4 | |
130 | ![]() |
Device on which the SYSREC dataset resides | ![]() |
CHAR |
131 | ![]() |
Dataset allocated to the SYSREC DDNAME | ![]() |
CHAR |
132 | ![]() |
Maximum length (in bytes) of any record in the table | INT4 | |
133 | ![]() |
Maximum length (in bytes) of any record in the table | ![]() |
INT2 |
134 | ![]() |
![]() |
INT4 | |
135 | ![]() |
Primary space allocation for the SYSREC dataset (cylinders) | ![]() |
INT2 |
136 | ![]() |
Last refresh date | ![]() |
DATS |
137 | ![]() |
Last refresh time | ![]() |
TIMS |
138 | ![]() |
DB2 release | ![]() |
CHAR |
139 | ![]() |
State if a reorg is needed (Y/N) | ![]() |
CHAR |
140 | ![]() |
RUNSTATS parameter REPORT | ![]() |
CHAR |
141 | ![]() |
Field type char, length 1, reserved | ![]() |
CHAR |
142 | ![]() |
Field type char, length 2, reserved | ![]() |
CHAR |
143 | ![]() |
Field type char, length 3, reserved | ![]() |
CHAR |
144 | ![]() |
Field type char, length 4, reserved | ![]() |
CHAR |
145 | ![]() |
Field type char, length 5 (reserved) | ![]() |
CHAR |
146 | ![]() |
Field type char, length 7 (reserved) | ![]() |
CHAR |
147 | ![]() |
Field type char, length 8, reserved | ![]() |
CHAR |
148 | ![]() |
Last reset date | ![]() |
DATS |
149 | ![]() |
Whether & at which point a current utility job is restarted | ![]() |
CHAR |
150 | ![]() |
hash and resource token | RAW | |
151 | ![]() |
The type of resource held by a lock | ![]() |
CHAR |
152 | ![]() |
Average rows examined(Only data rows are taken into account) | CHAR | |
153 | ![]() |
Average rows examined(Only data rows are taken into account) | ![]() |
DEC |
154 | ![]() |
Examined/processed Rows (Only data rows are taken into acc.) | ![]() |
DEC |
155 | ![]() |
Examined/Processed Rows (Only data rows are taken into acc.) | CHAR | |
156 | ![]() |
![]() |
INT4 | |
157 | ![]() |
Specified if DB2-managed dataset | ![]() |
CHAR |
158 | ![]() |
RFC destination for alert router | ![]() |
CHAR |
159 | ![]() |
RFC password | ![]() |
CHAR |
160 | ![]() |
Switch RFC trace off | ![]() |
CHAR |
161 | ![]() |
Switch RFC trace on | ![]() |
CHAR |
162 | ![]() |
DB2/390: RFC user for alert router | ![]() |
CHAR |
163 | ![]() |
![]() |
INT4 | |
164 | ![]() |
RID list failures | CHAR | |
165 | ![]() |
Creator of the index to be reorganized | ![]() |
CHAR |
166 | ![]() |
Name of the index to be reorganized | ![]() |
CHAR |
167 | ![]() |
Resource limit facility error parameter | ![]() |
CHAR |
168 | ![]() |
Average synchronous reads | CHAR | |
169 | ![]() |
Random hit ratio | ![]() |
DEC |
170 | ![]() |
Average getpages | CHAR | |
171 | ![]() |
Average index scans | CHAR | |
172 | ![]() |
Average parallel groups | CHAR | |
173 | ![]() |
Average sorts | CHAR | |
174 | ![]() |
Average tablespace scans | CHAR | |
175 | ![]() |
Average synchronous writes | CHAR | |
176 | ![]() |
Row Format | CHAR | |
177 | ![]() |
Reprepare Ratio | CHAR | |
178 | ![]() |
Average rows processed | CHAR | |
179 | ![]() |
Average rows processed | ![]() |
DEC |
180 | ![]() |
Ratio: Rows processed to rows examined of statement | CHAR | |
181 | ![]() |
Average RID failures - no storage | CHAR | |
182 | ![]() |
Average RID failures - limit | CHAR | |
183 | ![]() |
![]() |
INT4 | |
184 | ![]() |
COUNT parameter of the RUNSTATS utility | ![]() |
INT2 |
185 | ![]() |
Column for which information is to be gathered | ![]() |
CHAR |
186 | ![]() |
Name of the database to which the table space belongs | ![]() |
CHAR |
187 | ![]() |
Index for which information is to be gathered | ![]() |
CHAR |
188 | ![]() |
KEYCARD option of the RUNSTATS utility | ![]() |
CHAR |
189 | ![]() |
NUMCOLS parameter of the RUNSTATS utility | ![]() |
INT2 |
190 | ![]() |
Table space partition on which RUNSTATS is to be run | ![]() |
INT2 |
191 | ![]() |
REPORT option of the RUNSTATS utility | ![]() |
CHAR |
192 | ![]() |
Percentage of rows to sample for RUNSTATS | ![]() |
INT2 |
193 | ![]() |
RUNSTATS share level | ![]() |
CHAR |
194 | ![]() |
Table for which column information is to be gathered | ![]() |
CHAR |
195 | ![]() |
Table space on which RUNSTATS is to be run | ![]() |
CHAR |
196 | ![]() |
UPDATE option of the RUNSTATS utility | ![]() |
CHAR |
197 | ![]() |
Conditional / Unconditional | ![]() |
RAW |
198 | ![]() |
Name of the database to which the tablespace belongs | ![]() |
CHAR |
199 | ![]() |
DEADLINE parameter of the REORG utility | ![]() |
CHAR |
200 | ![]() |
DELAY parameter of the REORG utility | ![]() |
CHAR |
201 | ![]() |
KEEPDICTIONARY option of the REORG TABLESPACE utility | ![]() |
CHAR |
202 | ![]() |
LONGLOG parameter of the REORG utility | ![]() |
CHAR |
203 | ![]() |
LOG option of the REORG TABLESPACE utility | ![]() |
CHAR |
204 | ![]() |
Name of the mapping table | ![]() |
CHAR |
205 | ![]() |
Creator of the mapping table | ![]() |
CHAR |
206 | ![]() |
MAXRO parameter of the REORG utility | ![]() |
CHAR |
207 | ![]() |
NOSYSREC option of the REORG TABLESPACE utility | ![]() |
CHAR |
208 | ![]() |
Number of the partition to be reorganized | ![]() |
INT2 |
209 | ![]() |
PREFORMAT option of the REORG utility | ![]() |
CHAR |
210 | ![]() |
SHRLEVEL parameter of the REORG utility | ![]() |
CHAR |
211 | ![]() |
SORTKEYS option of the REORG TABLESPACE utility | ![]() |
CHAR |
212 | ![]() |
SORTDATA option of the REORG TABLESPACE utility | ![]() |
CHAR |
213 | ![]() |
Real Time Statistics: Table size = TOTALENTRIES*AvgRowLen KB | ![]() |
FLTP |
214 | ![]() |
DB2/zOS: Real-Time Statistics index TOTALENTRIES | ![]() |
FLTP |
215 | ![]() |
DB2/zOS: Real-Time Statistics tablespace TOTALROWS | ![]() |
FLTP |
216 | ![]() |
Name of the tablespace that is to be reorganized | ![]() |
CHAR |
217 | ![]() |
UNLOAD parameter of the REORG utility | ![]() |
CHAR |
218 | ![]() |
Index definition for RUNSTATS TABLESPACE statement | ![]() |
CHAR |
219 | ![]() |
Table definition for RUNSTATS TABLESPACE statement | ![]() |
CHAR |
220 | ![]() |
![]() |
INT4 | |
221 | ![]() |
DB2 sample mode | ![]() |
CHAR |
222 | ![]() |
SAP release | ![]() |
CHAR |
223 | ![]() |
Scale of decimal data | ![]() |
INT2 |
224 | ![]() |
DB2 database start date | ![]() |
DATS |
225 | ![]() |
DB2/390: Secondary quantity | ![]() |
NUMC |
226 | ![]() |
Number of pages in a segment of a segmented tablespace | ![]() |
INT2 |
227 | ![]() |
HIGH value of character field selection screen | ![]() |
CHAR |
228 | ![]() |
HIGH value of database selection screen | ![]() |
CHAR |
229 | ![]() |
HIGH value of table selection screen | ![]() |
CHAR |
230 | ![]() |
HIGH value of tablespace selection screen | ![]() |
CHAR |
231 | ![]() |
LOW value of character field selection screen | ![]() |
CHAR |
232 | ![]() |
LOW value of database selection screen | ![]() |
CHAR |
233 | ![]() |
LOW value of table selection screen | ![]() |
CHAR |
234 | ![]() |
LOW value of tablespace selection screen | ![]() |
CHAR |
235 | ![]() |
Selection operator of a selection screen | ![]() |
CHAR |
236 | ![]() |
SIGN flag of selection screen | ![]() |
CHAR |
237 | ![]() |
![]() |
INT4 | |
238 | ![]() |
severity | CHAR | |
239 | ![]() |
Number of Short Prepares | ![]() |
DEC |
240 | ![]() |
RUNSTATS parameter SHRLEVEL | ![]() |
CHAR |
241 | ![]() |
Small integer (2 bytes) | ![]() |
INT2 |
242 | ![]() |
Sync. seq. reads / seq. getpages | ![]() |
DEC |
243 | ![]() |
DB2 for OS/390: Size category of the table (small, large) | ![]() |
CHAR |
244 | ![]() |
DB2 for OS/390 size of a dataset in KBytes | ![]() |
DEC |
245 | ![]() |
Size in KB | DEC | |
246 | ![]() |
Size in MB | DEC | |
247 | ![]() |
Percent of time spent in DB2 for SYSLGRNX recording | ![]() |
CHAR |
248 | ![]() |
Sample interval | ![]() |
NUMC |
249 | ![]() |
sms object type | CHAR | |
250 | ![]() |
Name of sort column | CHAR | |
251 | ![]() |
Specifies that index keys are to be sorted | ![]() |
CHAR |
252 | ![]() |
The unit used in allocating archive data sets | ![]() |
CHAR |
253 | ![]() |
Number of KB of DASD Storage Allocated to Tablespace | ![]() |
INT4 |
254 | ![]() |
Type of tablespace or indexspace e.g. RPUTS, PBG, SEGM | CHAR | |
255 | ![]() |
The unit used in allocating archive datasets | ![]() |
CHAR |
256 | ![]() |
Total elapsed time spent in stored procedures | ![]() |
CHAR |
257 | ![]() |
message returned by Stored Procedure | CHAR | |
258 | ![]() |
Secondary space allocation | INT4 | |
259 | ![]() |
Device type for temporary datasets allocated by DFSORT | ![]() |
CHAR |
260 | ![]() |
Number of temporary datasets allocated by DFSORT | INT4 | |
261 | ![]() |
Percent of time in DB2 for commit, abort, deallocate | ![]() |
CHAR |
262 | ![]() |
Number of pages in each segment of a segmented tablespace | ![]() |
INT2 |
263 | ![]() |
Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit) | ![]() |
CHAR |
264 | ![]() |
SRB time for system service address space | ![]() |
CHAR |
265 | ![]() |
Storage contractions | ![]() |
NUMC |
266 | ![]() |
Availability status of tablespace | ![]() |
CHAR |
267 | ![]() |
Date and time of last RUNSTATS | ![]() |
CHAR |
268 | ![]() |
Status | ![]() |
CHAR |
269 | ![]() |
accumulated elapsed time used | ![]() |
INT4 |
270 | ![]() |
accumulated elapsed time used (2) | ![]() |
INT4 |
271 | ![]() |
TCB time for system service address space | ![]() |
CHAR |
272 | ![]() |
number of copies of the stm | ![]() |
INT4 |
273 | ![]() |
number of rows examined | ![]() |
INT4 |
274 | ![]() |
number of executions of stmt | ![]() |
INT4 |
275 | ![]() |
number of getpage operations | ![]() |
INT4 |
276 | ![]() |
number of index scans performed for statement | ![]() |
INT4 |
277 | ![]() |
time statement was inserted | ![]() |
CHAR |
278 | ![]() |
Number of parallel groups | ![]() |
INT4 |
279 | ![]() |
number of synchronous buffer | ![]() |
INT4 |
280 | ![]() |
xxx | ![]() |
CHAR |
281 | ![]() |
number of sorts performed for statement | ![]() |
INT4 |
282 | ![]() |
status of the statement | ![]() |
CHAR |
283 | ![]() |
entire SQL stmt text length | ![]() |
INT2 |
284 | ![]() |
first 60 bytes of a stmt text | ![]() |
CHAR |
285 | ![]() |
statement name generated by db2 for this statement | ![]() |
CHAR |
286 | ![]() |
unique statement identifier identifying a statement | ![]() |
INT4 |
287 | ![]() |
number of tablespace scans | ![]() |
INT4 |
288 | ![]() |
number of current users of stmt | ![]() |
INT4 |
289 | ![]() |
number of buffer write | ![]() |
INT4 |
290 | ![]() |
DB2 database start time | ![]() |
TIMS |
291 | ![]() |
The current SQL statement type being executed by the thread | ![]() |
CHAR |
292 | ![]() |
Date when the storage information has been collected | ![]() |
DATS |
293 | ![]() |
Storage group | CHAR | |
294 | ![]() |
Name of the storage group used for space allocation | ![]() |
CHAR |
295 | ![]() |
Average duration: stored procedures | ![]() |
CHAR |
296 | ![]() |
Stored procedures | ![]() |
CHAR |
297 | ![]() |
data in store_clock format (DEC 16) | DEC | |
298 | ![]() |
Time when the storage information has been collected | ![]() |
TIMS |
299 | ![]() |
Total time for system service address space | ![]() |
CHAR |
300 | ![]() |
String | STRG | |
301 | ![]() |
DB2 z/OS: subkey of an object | CHAR | |
302 | ![]() |
DB2/OS390: Unique counter | ![]() |
INT2 |
303 | ![]() |
Total number of extents of a TS or index (parts summed up) | INT4 | |
304 | ![]() |
dataelement for summation of DEC19 values | DEC | |
305 | ![]() |
Time spent suspended in DB2 / Time spent in DB2 (%) | ![]() |
CHAR |
306 | ![]() |
Lock duration of the thread holding the resource | ![]() |
CHAR |
307 | ![]() |
Alter Bufferpool/Alter Group Bufferpool commands are issued | ![]() |
CHAR |
308 | ![]() |
Maximum active pages across all the active buffer pools | ![]() |
CHAR |
309 | ![]() |
Buffer pool with maximum active pages | ![]() |
CHAR |
310 | ![]() |
Date when sampling is taken | ![]() |
DATS |
311 | ![]() |
Time when sampling was taken | ![]() |
TIMS |
312 | ![]() |
Time when sampling is taken | ![]() |
TIMS |
313 | ![]() |
Selected buffer pool | ![]() |
CHAR |
314 | ![]() |
Output log buffer writes per active log control interval | ![]() |
CHAR |
315 | ![]() |
Alter Bufferpool/Alter Group Bufferpool commands are issued | ![]() |
CHAR |
316 | ![]() |
Maximum active pages across all the active buffer pools | ![]() |
CHAR |
317 | ![]() |
Buffer pool with maximum active pages | ![]() |
CHAR |
318 | ![]() |
Date when sampling is taken | ![]() |
DATS |
319 | ![]() |
Time when sampling is taken | ![]() |
TIMS |
320 | ![]() |
Selected buffer pool | ![]() |
CHAR |
321 | ![]() |
Output log buffer writes per active log control interval | ![]() |
CHAR |
322 | ![]() |
Percentage of currently open datasets | ![]() |
DEC |
323 | ![]() |
Number of COMMITs | ![]() |
NUMC |
324 | ![]() |
No. of checkpoints | ![]() |
NUMC |
325 | ![]() |
Cursor table section requests/CT section not in EDM pool | ![]() |
CHAR |
326 | ![]() |
Database descriptor requests/DB descriptors not in EDM pool | ![]() |
CHAR |
327 | ![]() |
Datasets closed because deferred close threshold is reached | ![]() |
CHAR |
328 | ![]() |
No. of deadlocks | ![]() |
NUMC |
329 | ![]() |
No. of datasets currently in use | ![]() |
NUMC |
330 | ![]() |
Total no. of failures due to EDM pool being full | ![]() |
NUMC |
331 | ![]() |
Hiper pool concerns for any of the active buffer pools | ![]() |
CHAR |
332 | ![]() |
Buffer pool with hiperpool concerns | ![]() |
CHAR |
333 | ![]() |
Minimum hit ratio across all active buffer pools | ![]() |
DEC |
334 | ![]() |
Buffer pool with minimum hit ratio | ![]() |
CHAR |
335 | ![]() |
Number of Control Intervals Created for Active Log per Sec. | ![]() |
CHAR |
336 | ![]() |
No. of log write waits | ![]() |
NUMC |
337 | ![]() |
No. of log reads that had to access archive log datasets | ![]() |
NUMC |
338 | ![]() |
Time of last reset | ![]() |
TIMS |
339 | ![]() |
Percentage of currently open datasets | CHAR | |
340 | ![]() |
The number of commits | ![]() |
DEC |
341 | ![]() |
Percentage of EDM pool pages currently in use | ![]() |
CHAR |
342 | ![]() |
No. of checkpoints | ![]() |
INT4 |
343 | ![]() |
Degree of parallelism lower than planned | ![]() |
CHAR |
344 | ![]() |
Package table section requests/PT section not in EDM pool | ![]() |
CHAR |
345 | ![]() |
One of RID list limits is reached | ![]() |
CHAR |
346 | ![]() |
Number of ROLLBACKs | ![]() |
NUMC |
347 | ![]() |
Buffer pool with buffer pool shortage | ![]() |
CHAR |
348 | ![]() |
Buffer pool shortage in any of the active buffer pools | ![]() |
CHAR |
349 | ![]() |
DB2 subsystem ID | ![]() |
CHAR |
350 | ![]() |
Start Trace command was issued | ![]() |
CHAR |
351 | ![]() |
No. of suspensions (all kinds) | ![]() |
NUMC |
352 | ![]() |
Total no. of Data Control Language statements | ![]() |
NUMC |
353 | ![]() |
Total no. of Data Definition Language statements | ![]() |
NUMC |
354 | ![]() |
Total no. of Data Manipulation Language statements | ![]() |
NUMC |
355 | ![]() |
Number of timeouts | ![]() |
NUMC |
356 | ![]() |
(CT requests - CT not in EDM pool) / CT requests | ![]() |
CHAR |
357 | ![]() |
(DBD requests - DBD not in EDM pool) / DBD requests | ![]() |
CHAR |
358 | ![]() |
Datasets closed because deferred close threshold is reached | ![]() |
CHAR |
359 | ![]() |
No. of deadlocks | ![]() |
INT4 |
360 | ![]() |
Number of datasets currently in use | ![]() |
NUMC |
361 | ![]() |
Total number of failures due to EDM pool being full | ![]() |
INT4 |
362 | ![]() |
Hiper pool concerns for any of the active buffer pools | ![]() |
CHAR |
363 | ![]() |
Buffer pool which has hiperpool concerns | ![]() |
CHAR |
364 | ![]() |
Minimum hit ratio across all active buffer pools | ![]() |
DEC |
365 | ![]() |
Buffer pool which has the minimum hit ratio | ![]() |
CHAR |
366 | ![]() |
Number of bytes in KB written for active log per sec | ![]() |
CHAR |
367 | ![]() |
Number of log write waits | ![]() |
NUMC |
368 | ![]() |
The number of log reads which had to access archive log DSs | ![]() |
NUMC |
369 | ![]() |
Time of last reset | ![]() |
TIMS |
370 | ![]() |
Percentage of EDM pool pages currently in use | CHAR | |
371 | ![]() |
Degree of parallelism lower than planned | ![]() |
CHAR |
372 | ![]() |
(PT requests - PT not in EDM pool) / PT requests | ![]() |
CHAR |
373 | ![]() |
Any of the RID list limits is reached | ![]() |
CHAR |
374 | ![]() |
Number of rollbacks | ![]() |
INT4 |
375 | ![]() |
Buffer pool shortage in any of the active buffer pools | ![]() |
CHAR |
376 | ![]() |
Buffer pool which has a buffer pool shortage | ![]() |
CHAR |
377 | ![]() |
DB2 subsystem ID | ![]() |
CHAR |
378 | ![]() |
Start Trace command was issued | ![]() |
CHAR |
379 | ![]() |
Number of suspensions of all kinds | ![]() |
DEC |
380 | ![]() |
Total number of Data Control Language statements | ![]() |
DEC |
381 | ![]() |
Total number of Data Definition Language statements | ![]() |
DEC |
382 | ![]() |
Total number of Data Manipulation Language statements | ![]() |
DEC |
383 | ![]() |
Number of timeouts | ![]() |
INT4 |
384 | ![]() |
Sync writes / ( sync writes + async writes) | ![]() |
DEC |
385 | ![]() |
IRLM function request (LOCK, UNLOCK, or CHANGE) | ![]() |
CHAR |
386 | ![]() |
![]() |
CHAR | |
387 | ![]() |
Synchronous I/O per minute (pages) | ![]() |
DEC |
388 | ![]() |
Number of synchronous reads per second | ![]() |
CHAR |
389 | ![]() |
Number of Random Access Synchronous Reads | ![]() |
DEC |
390 | ![]() |
Concatenation of SAP system IDs in an DB2 subsystem | CHAR | |
391 | ![]() |
Z/OS Syslog entry source ID - JOB, CONSOLE or multiline | ![]() |
CHAR |
392 | ![]() |
Z/OS syslog raw line | CHAR | |
393 | ![]() |
Z/OS syslog routing Code | ![]() |
CHAR |
394 | ![]() |
Z/OS Syslog user flags | ![]() |
CHAR |
395 | ![]() |
System number | ![]() |
CHAR |
396 | ![]() |
DB2 system type | CHAR | |
397 | ![]() |
Buffer pool ID of the locked resource | ![]() |
CHAR |
398 | ![]() |
Name of the package collection | ![]() |
CHAR |
399 | ![]() |
Consistency token of the package | ![]() |
CHAR |
400 | ![]() |
Name of the database | ![]() |
CHAR |
401 | ![]() |
Duration of a lock | ![]() |
CHAR |
402 | ![]() |
IRLM function request | ![]() |
CHAR |
403 | ![]() |
Hash class number of the group database exception upd. lock | ![]() |
NUMC |
404 | ![]() |
No. of locks held and susp. on the database/obj. combination | ![]() |
NUMC |
405 | ![]() |
Name of the object associated with the database | ![]() |
CHAR |
406 | ![]() |
Package identifier | ![]() |
CHAR |
407 | ![]() |
Page number of the locked resource | ![]() |
NUMC |
408 | ![]() |
Partition of the locked resource | ![]() |
NUMC |
409 | ![]() |
Indicates the kind of lock for the resource | ![]() |
CHAR |
410 | ![]() |
RMID of the group databases exception update lock | ![]() |
CHAR |
411 | ![]() |
Record ID within the page of the locked resource | ![]() |
NUMC |
412 | ![]() |
State of the lock held on the resource | ![]() |
CHAR |
413 | ![]() |
Subpage number of the index page lock | ![]() |
NUMC |
414 | ![]() |
Whether the thread is suspended waiting for a lock | ![]() |
CHAR |
415 | ![]() |
Type of lock held on a resource | ![]() |
CHAR |
416 | ![]() |
DB2 for OS/390: Table category | ![]() |
CHAR |
417 | ![]() |
Table name | ![]() |
CHAR |
418 | ![]() |
DB2 table name | ![]() |
CHAR |
419 | ![]() |
DB2 long table name | CHAR | |
420 | ![]() |
DB2 medium table name | CHAR | |
421 | ![]() |
DB2 extended table name | STRG | |
422 | ![]() |
Number of rollback requests | ![]() |
INT4 |
423 | ![]() |
Number of rollback requests | ![]() |
INT4 |
424 | ![]() |
Reserved storage space of a table in KBytes | ![]() |
DEC |
425 | ![]() |
DB2 for OS/390: Table size ( pages * reclength / 1024 ) | ![]() |
DEC |
426 | ![]() |
Type of DB2 table | ![]() |
CHAR |
427 | ![]() |
Table: Type of object | CHAR | |
428 | ![]() |
Archive read suspension time | ![]() |
DEC |
429 | ![]() |
Archive log quiesce suspension time | ![]() |
DEC |
430 | ![]() |
Archive log quiesce suspension time | ![]() |
CHAR |
431 | ![]() |
Average duration of ARCHIVE LOG QUIESCE suspensions | ![]() |
CHAR |
432 | ![]() |
Number of archive log quiesce suspensions | ![]() |
INT4 |
433 | ![]() |
Number of ARCHIVE LOG QUIESCE suspensions | ![]() |
NUMC |
434 | ![]() |
Archive read suspension time | ![]() |
CHAR |
435 | ![]() |
Average duration of archive read suspensions | ![]() |
CHAR |
436 | ![]() |
Number of Archive Read Suspensions | ![]() |
INT4 |
437 | ![]() |
Number of archive read suspensions | ![]() |
NUMC |
438 | ![]() |
Average row length of table | INT4 | |
439 | ![]() |
Authorization ID of the owner of the table | ![]() |
CHAR |
440 | ![]() |
Authorization id of the owner of the table | ![]() |
CHAR |
441 | ![]() |
Number of extents after a new extent has been created | ![]() |
NUMC |
442 | ![]() |
Number of extents before a new extent has been created | ![]() |
NUMC |
443 | ![]() |
Maximum number of extents | ![]() |
NUMC |
444 | ![]() |
Parameter if TABLE ALL should used for a RUNSTATS | ![]() |
CHAR |
445 | ![]() |
High allocated after extent, 4KB | ![]() |
NUMC |
446 | ![]() |
DB2 for OS/390: Flag for updating DB02 extent monitor | ![]() |
CHAR |
447 | ![]() |
Number of volumes after a new extent has been created | ![]() |
NUMC |
448 | ![]() |
Number of volumes before extent has been created | ![]() |
NUMC |
449 | ![]() |
Maximum volumes | ![]() |
NUMC |
450 | ![]() |
Number of tables missing in the database | ![]() |
DEC |
451 | ![]() |
Number of tables missing in the ABAP/4 dictionary | ![]() |
DEC |
452 | ![]() |
Name of the table on which the index is defined | ![]() |
CHAR |
453 | ![]() |
Number of tables in the R/3 system | ![]() |
DEC |
454 | ![]() |
Size of the table in KB | ![]() |
DEC |
455 | ![]() |
Total size of all R/3 tables (used storage in KB) | ![]() |
DEC |
456 | ![]() |
Column SYSIBM.SYSTABLES(SPACEF): DASD space used for table | ![]() |
FLTP |
457 | ![]() |
Status of the table | ![]() |
CHAR |
458 | ![]() |
Real Time Statistics: Number of rows in Table | ![]() |
FLTP |
459 | ![]() |
Type of object | ![]() |
CHAR |
460 | ![]() |
DB2 for OS/390: High threshold for extent filtering | ![]() |
NUMC |
461 | ![]() |
DB2 for OS/390: Low threshold for extent filtering | ![]() |
NUMC |
462 | ![]() |
Table category description | ![]() |
CHAR |
463 | ![]() |
Claim release suspension time | ![]() |
DEC |
464 | ![]() |
Claim release suspension time | ![]() |
CHAR |
465 | ![]() |
Average duration of claim release suspensions | ![]() |
CHAR |
466 | ![]() |
Number of Claim Release Suspensions | ![]() |
INT4 |
467 | ![]() |
Number of claim release suspensions | ![]() |
NUMC |
468 | ![]() |
Number of successful phase 2 or single-phase commit requests | ![]() |
INT4 |
469 | ![]() |
Number of successful phase 2 or single-phase commit requests | ![]() |
INT4 |
470 | ![]() |
CPU time spent in DB2 | ![]() |
CHAR |
471 | ![]() |
Average CPU time spent in DB2 | ![]() |
CHAR |
472 | ![]() |
CPU time spent in DB2 | ![]() |
DEC |
473 | ![]() |
Total System z CPU time including DB2 | ![]() |
DEC |
474 | ![]() |
Total CPU time on System z including DB2 | ![]() |
CHAR |
475 | ![]() |
Total elapsed activity time | ![]() |
CHAR |
476 | ![]() |
Drain lock suspension time | ![]() |
CHAR |
477 | ![]() |
Average duration of drain lock suspensions | ![]() |
CHAR |
478 | ![]() |
Drain lock suspension time | ![]() |
DEC |
479 | ![]() |
Number of drain lock suspensions | ![]() |
NUMC |
480 | ![]() |
Number of Drain Lock Suspensions | ![]() |
INT4 |
481 | ![]() |
Number of datasets that were closed via the DRAIN process | ![]() |
INT4 |
482 | ![]() |
Number of datasets open concurrently | ![]() |
INT4 |
483 | ![]() |
Average CPU processing between stored procedure entry/exit | ![]() |
CHAR |
484 | ![]() |
Average stored procedure entry/exit duration | ![]() |
CHAR |
485 | ![]() |
Total elapsed time spent executing SQL in stored procedures | ![]() |
CHAR |
486 | ![]() |
Wait time for data set extend/delete/define service task | ![]() |
CHAR |
487 | ![]() |
Average waiting time for dataset ext./del./def. service task | ![]() |
CHAR |
488 | ![]() |
Wait time for data set extend/delete/define service task | ![]() |
DEC |
489 | ![]() |
Number of waits for data set ext./del./def. service task | ![]() |
NUMC |
490 | ![]() |
Number of waits for data set ext./del./def. service task | ![]() |
INT4 |
491 | ![]() |
DB2 entry/exit duration elapsed time | ![]() |
CHAR |
492 | ![]() |
DB2 entry/exit duration processing (CPU) | ![]() |
CHAR |
493 | ![]() |
Stored procedure entry/exit duration elapsed time | ![]() |
CHAR |
494 | ![]() |
Stored procedure entry/exit duration processing (CPU) | ![]() |
CHAR |
495 | ![]() |
False Contention Rate | ![]() |
CHAR |
496 | ![]() |
False contention rate | ![]() |
CHAR |
497 | ![]() |
Global Contention Rate | ![]() |
CHAR |
498 | ![]() |
Global contention rate | ![]() |
CHAR |
499 | ![]() |
Global locking suspension time | ![]() |
DEC |
500 | ![]() |
Average duration of global locking suspensions | ![]() |
CHAR |