SAP ABAP Data Element - Index D, page 6
Data Element - D
# | Data Element | Short Description | Domain | Data Type |
---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
1 | ![]() |
Total time for IRLM | ![]() |
CHAR |
2 | ![]() |
The password for the datasets of the tablespace | ![]() |
CHAR |
3 | ![]() |
Percent of time spent in DB2 for drain locks | ![]() |
CHAR |
4 | ![]() |
![]() |
INT2 | |
5 | ![]() |
type field for dynamic statement cache | ![]() |
INT2 |
6 | ![]() |
![]() |
INT4 | |
7 | ![]() |
DSC Qualification | ![]() |
NUMC |
8 | ![]() |
DB2 IFI DSC qualification for top statements | ![]() |
NUMC |
9 | ![]() |
DSC Threshold | ![]() |
CHAR |
10 | ![]() |
![]() |
INT4 | |
11 | ![]() |
![]() |
INT4 | |
12 | ![]() |
Last qualifier of dataset name of a DB2 tablespace or index | ![]() |
CHAR |
13 | ![]() |
DB2/390: Data sharing group | ![]() |
CHAR |
14 | ![]() |
Data sharing group | ![]() |
CHAR |
15 | ![]() |
Maximum size of a dataset in KBytes | ![]() |
INT4 |
16 | ![]() |
Data sharing member | ![]() |
CHAR |
17 | ![]() |
Dataset name | ![]() |
CHAR |
18 | ![]() |
SRB time for DB2 database service address space | ![]() |
CHAR |
19 | ![]() |
Qual. properties for DB2 data set statistics -IFCID 199 | ![]() |
NUMC |
20 | ![]() |
Qualification for DB2 data set statistics - IFCID 199 | ![]() |
NUMC |
21 | ![]() |
Percent of time spent in DB2 for dataspace manager service | ![]() |
CHAR |
22 | ![]() |
DBSL SQL trace level | INT4 | |
23 | ![]() |
Pageset type | ![]() |
CHAR |
24 | ![]() |
Day of creation of data set (Julian date) | INT4 | |
25 | ![]() |
Year of creation of data set | INT4 | |
26 | ![]() |
Dataset High-Allocated RBA | INT4 | |
27 | ![]() |
Dataset High-Used RBA | INT4 | |
28 | ![]() |
Data set type in integer | INT4 | |
29 | ![]() |
TCB time for DB2 database service address space | ![]() |
CHAR |
30 | ![]() |
Status of the thread | ![]() |
CHAR |
31 | ![]() |
Total time for DB2 database service address space | ![]() |
CHAR |
32 | ![]() |
Dump Size for IFI DB Trace | ![]() |
NUMC |
33 | ![]() |
IFI DB Trace: Duration of Operation | ![]() |
CHAR |
34 | ![]() |
DB2 z/OS: element of an object | CHAR | |
35 | ![]() |
Default encoding scheme of the tablespace | ![]() |
CHAR |
36 | ![]() |
Encoding | CHAR | |
37 | ![]() |
Device on which the SYSERR dataset resides | ![]() |
CHAR |
38 | ![]() |
Dataset allocated to the SYSERR DDNAME | ![]() |
CHAR |
39 | ![]() |
DB2 for OS/390: Number of error reported by DB system check | ![]() |
NUMC |
40 | ![]() |
Primary space allocation for the SYSERR dataset (Cyl.) | ![]() |
INT2 |
41 | ![]() |
Datasets are to be erased when dropped | ![]() |
CHAR |
42 | ![]() |
![]() |
CHAR | |
43 | ![]() |
![]() |
CHAR | |
44 | ![]() |
Date when the event arises | ![]() |
DATS |
45 | ![]() |
Time when the event arises | ![]() |
TIMS |
46 | ![]() |
Event time stamp (milliseconds) | ![]() |
CHAR |
47 | ![]() |
Sum of execution of updates, inserts, deletes and fetches | ![]() |
DEC |
48 | ![]() |
Average executions per second | ![]() |
DEC |
49 | ![]() |
Number of extents of a tablespace | ![]() |
INT4 |
50 | ![]() |
Name of Failover Parameter, needed for special Documentation | STRG | |
51 | ![]() |
Number of rows relocated far from their original page | INT4 | |
52 | ![]() |
Number of referred to rows far from optimal position | ![]() |
FLTP |
53 | ![]() |
False contention rate | ![]() |
CHAR |
54 | ![]() |
DB2 for OS/390: Number of fetches | ![]() |
DEC |
55 | ![]() |
fieldname (of structure etc.) | CHAR | |
56 | ![]() |
Device on which the FILTER dataset resides | ![]() |
CHAR |
57 | ![]() |
Dataset allocated to the FILTER DDNAME | ![]() |
CHAR |
58 | ![]() |
File Name | CHAR | |
59 | ![]() |
File Path | CHAR | |
60 | ![]() |
Primary space allocation for the SYSERR dataset (Cyl.) | ![]() |
INT2 |
61 | ![]() |
![]() |
INT2 | |
62 | ![]() |
c1 flag | CHAR | |
63 | ![]() |
Number of free DSCBs | INT4 | |
64 | ![]() |
Number of cylinders of freespace on an OS/390 DASD volume | INT4 | |
65 | ![]() |
Number of pages loaded before a page is left as free space | ![]() |
INT2 |
66 | ![]() |
Number of distinct values in the first key column | ![]() |
FLTP |
67 | ![]() |
Number of distinct values of the key | ![]() |
FLTP |
68 | ![]() |
Full name of a PDS member (incl. PDS name and brackets) | ![]() |
CHAR |
69 | ![]() |
Total number of prepares: full prepares + short prepares | ![]() |
DEC |
70 | ![]() |
Group buffer pool cache option | ![]() |
CHAR |
71 | ![]() |
Group buffer pool cache option | CHAR | |
72 | ![]() |
Group bufferpool dependence | ![]() |
CHAR |
73 | ![]() |
GBP: Read/Write failures due to storage shortage | ![]() |
NUMC |
74 | ![]() |
Group buffer pool: # of pages returned on CF read request | ![]() |
NUMC |
75 | ![]() |
Group buffer pool: # of times a CF write request completed | ![]() |
NUMC |
76 | ![]() |
Global contention rate | ![]() |
CHAR |
77 | ![]() |
Number of GDG generations | INT4 | |
78 | ![]() |
Number of Getpage Requests per Second | ![]() |
DEC |
79 | ![]() |
Number of Random Access Getpage Requests | ![]() |
DEC |
80 | ![]() |
Dynamic Statement Cache Global Hit Ratio | CHAR | |
81 | ![]() |
Percent of time spent in DB2 for global locks | ![]() |
CHAR |
82 | ![]() |
Getpages per rows processed | ![]() |
DEC |
83 | ![]() |
Getpages per rows processed | CHAR | |
84 | ![]() |
![]() |
CHAR | |
85 | ![]() |
History start/end date | ![]() |
DATS |
86 | ![]() |
History data start/end time | ![]() |
TIMS |
87 | ![]() |
Range for History ( daily, weekly, monthly ) | CHAR | |
88 | ![]() |
Prepare hit ratio | ![]() |
CHAR |
89 | ![]() |
Hostname | ![]() |
CHAR |
90 | ![]() |
TCP address of database host | ![]() |
CHAR |
91 | ![]() |
Host type: Primary or standby | ![]() |
CHAR |
92 | ![]() |
Percentage of hiperpool buffers backed | ![]() |
DEC |
93 | ![]() |
Percentage of buffers in the HP containing pages of the PS | ![]() |
DEC |
94 | ![]() |
Hiperpool failures | ![]() |
CHAR |
95 | ![]() |
Ratio of Sync. Reads vs Sync. Writes for the Hiperpool | ![]() |
CHAR |
96 | ![]() |
No. of Unsuccessful Sync. Hiperpool Read or Write Requests | ![]() |
NUMC |
97 | ![]() |
Hiperpool efficiency | ![]() |
DEC |
98 | ![]() |
Number of Hiperpool Failures | DEC | |
99 | ![]() |
Minimum hiperpool efficiency | ![]() |
DEC |
100 | ![]() |
Hiperpool with minimum efficiency | ![]() |
CHAR |
101 | ![]() |
Hiperpool efficiency | ![]() |
DEC |
102 | ![]() |
Hiperpool reads ratio (high) | INT4 | |
103 | ![]() |
Hiperpool read ratio (low) | INT4 | |
104 | ![]() |
Ratio of synch. reads vs synch. writes for the hiperpool | ![]() |
CHAR |
105 | ![]() |
No. of Unsuccessful Sync. Hiperpool Read or Write Requests | ![]() |
INT4 |
106 | ![]() |
![]() |
INT4 | |
107 | ![]() |
Start ICLI server communications trace | ![]() |
CHAR |
108 | ![]() |
Stop ICLI server communications trace | ![]() |
CHAR |
109 | ![]() |
IFI DB Trace: Identifier | ![]() |
CHAR |
110 | ![]() |
Name of a DB2 for OS/390 index | ![]() |
CHAR |
111 | ![]() |
DB2 long index name | CHAR | |
112 | ![]() |
DB2 extended index name | STRG | |
113 | ![]() |
Storage reserved by all indexes of a table in KB | ![]() |
DEC |
114 | ![]() |
Number of indexes of a table of unknown size | INT4 | |
115 | ![]() |
Number of entries to and exits from IFI events | ![]() |
NUMC |
116 | ![]() |
Elapsed IFI time to total DB2 time in percent | ![]() |
CHAR |
117 | ![]() |
Accumulated elapsed time spent processing IFI calls | ![]() |
CHAR |
118 | ![]() |
Processing (CPU) times to total DB2 activity time in percent | ![]() |
CHAR |
119 | ![]() |
Accumulated CPU time spent processing IFI calls | ![]() |
CHAR |
120 | ![]() |
Average IFI entry/exit CPU time | ![]() |
CHAR |
121 | ![]() |
application type short | ![]() |
CHAR |
122 | ![]() |
IFI DB Trace Application Types | ![]() |
CHAR |
123 | ![]() |
Start the IFI DB trace | ![]() |
CHAR |
124 | ![]() |
Display IFI DB trace files | ![]() |
CHAR |
125 | ![]() |
Stop IFI DB trace | ![]() |
CHAR |
126 | ![]() |
DB Trace Input | ![]() |
CHAR |
127 | ![]() |
DB Trace Level | ![]() |
CHAR |
128 | ![]() |
DB Trace Level | ![]() |
CHAR |
129 | ![]() |
IFI DB Trace: Timestamp | ![]() |
CHAR |
130 | ![]() |
Start the IFI server trace | ![]() |
CHAR |
131 | ![]() |
Display IFI server trace files | ![]() |
CHAR |
132 | ![]() |
IFI Trace Level | ![]() |
INT4 |
133 | ![]() |
Stop IFI server trace | ![]() |
CHAR |
134 | ![]() |
Work Process Description | ![]() |
CHAR |
135 | ![]() |
![]() |
INT4 | |
136 | ![]() |
DB2 for OS/390: ICLI message level | ![]() |
CHAR |
137 | ![]() |
Percentage of time spent in DB2 | ![]() |
CHAR |
138 | ![]() |
Different of far and near relocated position in page | ![]() |
INT2 |
139 | ![]() |
Parameter if INDEX ALL should used for a RUNSTATS | ![]() |
CHAR |
140 | ![]() |
Switch network statistics off | ![]() |
CHAR |
141 | ![]() |
Switch network statistics on (sampling rate in packets) | ![]() |
CHAR |
142 | ![]() |
Switch network statistics on (sampling rate in seconds) | ![]() |
CHAR |
143 | ![]() |
DB2 for OS/390: Number of database inserts | ![]() |
NUMC |
144 | ![]() |
install field | CHAR | |
145 | ![]() |
Instance number (unique value) | ![]() |
RAW |
146 | ![]() |
Install Panel | CHAR | |
147 | ![]() |
Small integer | ![]() |
INT2 |
148 | ![]() |
Field Type INT2, Length 2 | ![]() |
INT2 |
149 | ![]() |
Field Type INT, Length 4 | ![]() |
INT4 |
150 | ![]() |
Field Type INT, Length 4 | ![]() |
INT4 |
151 | ![]() |
Time interval of the data | ![]() |
TIMS |
152 | ![]() |
DB2 for OS/390 History Data Inteval (Start/End Time) | ![]() |
RAW |
153 | ![]() |
Index name | ![]() |
CHAR |
154 | ![]() |
Sampling rate of network statistics | ![]() |
NUMC |
155 | ![]() |
Sampling rate for network statistics | ![]() |
NUMC |
156 | ![]() |
Number of free pages in EDM statement pool | ![]() |
INT4 |
157 | ![]() |
Number of pages in EDM statement pool | ![]() |
INT4 |
158 | ![]() |
Current number of pages in EDM pool used for cursor tables | ![]() |
DEC |
159 | ![]() |
Number of requests for cursor table sections | ![]() |
DEC |
160 | ![]() |
Number of CT sections not found in EDM pool | ![]() |
DEC |
161 | ![]() |
Current number of pages in EDM pool used for DB descriptor | ![]() |
DEC |
162 | ![]() |
Number of requests for database descriptor | ![]() |
DEC |
163 | ![]() |
Number of DB descriptors not found in EDM pool | ![]() |
DEC |
164 | ![]() |
Number of failures because the data space is full | ![]() |
DEC |
165 | ![]() |
Number of free pages in the data space free chain | ![]() |
DEC |
166 | ![]() |
Number of pages in the data space used by the EDM pool | ![]() |
DEC |
167 | ![]() |
Number of pages used for DSC | ![]() |
DEC |
168 | ![]() |
Number of requests for DSC sections | ![]() |
DEC |
169 | ![]() |
Number of inserts into EDM pool for dynamic statement cache | ![]() |
DEC |
170 | ![]() |
Current number of free pages in the free chain | ![]() |
DEC |
171 | ![]() |
Current number of pages in EDM pool used for package tables | ![]() |
DEC |
172 | ![]() |
Number of requests for package table sections | ![]() |
DEC |
173 | ![]() |
Number of times a PT section was not found in EDM pool | ![]() |
DEC |
174 | ![]() |
Current number of pages in the EDM pool | ![]() |
DEC |
175 | ![]() |
Current number of pages in EDM pool used for skeleton CT | ![]() |
DEC |
176 | ![]() |
Current number of pages in EDM pool used for skeleton PT | ![]() |
DEC |
177 | ![]() |
Number of statements in EDM pool for dynamic statement cache | ![]() |
DEC |
178 | ![]() |
DB2 indexspace name | ![]() |
CHAR |
179 | ![]() |
RID block allocated - current | ![]() |
DEC |
180 | ![]() |
RID blocks allocated - maximum | ![]() |
DEC |
181 | ![]() |
RDS limit exceeded | ![]() |
DEC |
182 | ![]() |
Process limit exceeded | ![]() |
DEC |
183 | ![]() |
Physical limit reached | ![]() |
DEC |
184 | ![]() |
RID list processing exhausted virtual storage | ![]() |
DEC |
185 | ![]() |
Display ICLI server trace files | ![]() |
CHAR |
186 | ![]() |
ICLI trace level | ![]() |
NUMC |
187 | ![]() |
Start the ICLI server trace | ![]() |
CHAR |
188 | ![]() |
Stop ICLI server trace | ![]() |
CHAR |
189 | ![]() |
Number of keys in the index that refer to data rows or LOBs | ![]() |
FLTP |
190 | ![]() |
Free size of an index in KB (allocated minus used storage) | ![]() |
DEC |
191 | ![]() |
Free size of an index partition in KB | ![]() |
DEC |
192 | ![]() |
Total free size of all R/3 indexes in KB | ![]() |
DEC |
193 | ![]() |
Number of indexes missing in the database | ![]() |
DEC |
194 | ![]() |
Number of indexes missing in the ABAP dictionary | ![]() |
DEC |
195 | ![]() |
Index name | CHAR | |
196 | ![]() |
Number of indexes in the R/3 system | ![]() |
DEC |
197 | ![]() |
Percentage of free size to allocated size of all indexes | ![]() |
NUMC |
198 | ![]() |
Percentage of used size to allocated size of all indexes | ![]() |
DEC |
199 | ![]() |
Percentage of used to alloc. size of a partition of an IX | ![]() |
DEC |
200 | ![]() |
Percentage of used size to allocated size of an index | ![]() |
DEC |
201 | ![]() |
Percentage of used size to allocated size of all indexes | ![]() |
DEC |
202 | ![]() |
Size in bytes of the leaf pages in the index | ![]() |
INT2 |
203 | ![]() |
Total size of an index (allocated storage in KB) | ![]() |
DEC |
204 | ![]() |
Allocated storage of a partition of an index in KB | ![]() |
DEC |
205 | ![]() |
Total size of all R/3 indexes (allocated storage in kB) | ![]() |
DEC |
206 | ![]() |
Name of the indexspace that contains the index | ![]() |
CHAR |
207 | ![]() |
Index Space | CHAR | |
208 | ![]() |
IX Type | CHAR | |
209 | ![]() |
Index type | ![]() |
CHAR |
210 | ![]() |
JCL job line | ![]() |
CHAR |
211 | ![]() |
DSNACCJP:Obsolete - System name of the target JES subsystem | ![]() |
CHAR |
212 | ![]() |
z/OS JES Job ID | ![]() |
CHAR |
213 | ![]() |
Output of JCL Job | ![]() |
CHAR |
214 | ![]() |
Number of archive log read allocations | ![]() |
INT4 |
215 | ![]() |
Number of archive log write allocations | ![]() |
INT4 |
216 | ![]() |
Number of Active Log Output Control Intervals Created | ![]() |
INT4 |
217 | ![]() |
Number of calls to the log write routine | ![]() |
INT4 |
218 | ![]() |
The number of times a log output buffer had to be paged-in | ![]() |
NUMC |
219 | ![]() |
Number of BSDS Access Requests | ![]() |
INT4 |
220 | ![]() |
Count of Control Intervals Offloaded | ![]() |
INT4 |
221 | ![]() |
Number of control intervals written for active log (second) | ![]() |
NUMC |
222 | ![]() |
Check Tape Mounts Attempted | ![]() |
INT4 |
223 | ![]() |
Successful "look ahead" (tape volume) mounts attempted | ![]() |
INT4 |
224 | ![]() |
The total number of log-write I/O requests | ![]() |
NUMC |
225 | ![]() |
Number of times a log manager request results in suspend | ![]() |
NUMC |
226 | ![]() |
Number of Log Reads Satisfied from Active Log Data Set | ![]() |
INT4 |
227 | ![]() |
Number of Log Reads Satisfied from Archive Log Data Set | ![]() |
INT4 |
228 | ![]() |
Number of Log Reads Satisfied from Output Buffer | ![]() |
INT4 |
229 | ![]() |
The number of "serial" log-write I/O requests | ![]() |
NUMC |
230 | ![]() |
Number of times an async. log-write request was scheduled | ![]() |
NUMC |
231 | ![]() |
Read accesses delayed due to tape volume contention | ![]() |
INT4 |
232 | ![]() |
Number of Write-No-Wait Requests | ![]() |
INT4 |
233 | ![]() |
Number of Write-No-Wait Requests | ![]() |
DEC |
234 | ![]() |
Unavailable output log buffers | ![]() |
INT4 |
235 | ![]() |
Read accesses delayed due to unavailable resource | ![]() |
INT4 |
236 | ![]() |
Number of columns in the key | ![]() |
INT2 |
237 | ![]() |
Number of distinct values in key (first column or full key) | ![]() |
FLTP |
238 | ![]() |
Number of columns in the table's primary key | ![]() |
INT2 |
239 | ![]() |
KEYCARD collects all distinct values | ![]() |
CHAR |
240 | ![]() |
DB2/390: Language for alert receiver | ![]() |
CHAR |
241 | ![]() |
100 * avg number of leaf pages between successive leaf pages | INT4 | |
242 | ![]() |
DB2/390: End user ID (in DB2 sense) | ![]() |
CHAR |
243 | ![]() |
End user transaction name | ![]() |
CHAR |
244 | ![]() |
End user workstation name | ![]() |
CHAR |
245 | ![]() |
Dynamic Statement Cache Local Hit Ratio | CHAR | |
246 | ![]() |
limitkey | CHAR | |
247 | ![]() |
Percent of time spent in DB2 for locks and latches | ![]() |
CHAR |
248 | ![]() |
Maximum number of locks per user before escalating | ![]() |
INT4 |
249 | ![]() |
Lock attribute (logical lock or physical lock) | ![]() |
CHAR |
250 | ![]() |
The mode of the lock held on the resource | ![]() |
CHAR |
251 | ![]() |
Lock duration of the thread holding the resource | ![]() |
CHAR |
252 | ![]() |
Total number of lock escalations | ![]() |
DEC |
253 | ![]() |
The mode of the lock held on the resource | ![]() |
CHAR |
254 | ![]() |
The mode of the lock held on the resource | ![]() |
CHAR |
255 | ![]() |
Locks held and suspended on the database/object combination | ![]() |
NUMC |
256 | ![]() |
Locks held and suspended on the database/object combination | ![]() |
NUMC |
257 | ![]() |
![]() |
CHAR | |
258 | ![]() |
State of lock | ![]() |
CHAR |
259 | ![]() |
Whether the changes to a tablespace are to be logged | ![]() |
CHAR |
260 | ![]() |
Number of internal log latch contentions per second | ![]() |
CHAR |
261 | ![]() |
DB2/390: Logon group | ![]() |
CHAR |
262 | ![]() |
The active log copy number (1 or 2) | ![]() |
CHAR |
263 | ![]() |
Number of log write I/O requests minus serial requests | ![]() |
NUMC |
264 | ![]() |
Percentage filled of last available log DS for this log copy | ![]() |
CHAR |
265 | ![]() |
Log writes suspension time | ![]() |
CHAR |
266 | ![]() |
Average log writes | ![]() |
CHAR |
267 | ![]() |
![]() |
DEC | |
268 | ![]() |
Number of log writes | ![]() |
NUMC |
269 | ![]() |
![]() |
INT4 | |
270 | ![]() |
Percent of time spent in DB2 for log writes | ![]() |
CHAR |
271 | ![]() |
Average duration of a suspension for log write I/O | ![]() |
CHAR |
272 | ![]() |
Lockpart for the tablespace | ![]() |
CHAR |
273 | ![]() |
Lock size of the tablespace | ![]() |
CHAR |
274 | ![]() |
Macro Name | CHAR | |
275 | ![]() |
DB2/390: Alert receiver client | ![]() |
CHAR |
276 | ![]() |
Device on which the SYSMAP dataset resides | ![]() |
CHAR |
277 | ![]() |
Dataset allocated to the SYSMAP DDNAME | ![]() |
CHAR |
278 | ![]() |
Primary space allocation for the SYSMAP dataset (cyl.) | ![]() |
INT2 |
279 | ![]() |
Maximum number of extents of a partition of the TS or IX | INT4 | |
280 | ![]() |
Partition or dataset whose incr. copies are to be merged | ![]() |
CHAR |
281 | ![]() |
Whether incr. image copies are to be merged with full ones | ![]() |
CHAR |
282 | ![]() |
Name of the tablespace whose incr. image copies are merged | ![]() |
CHAR |
283 | ![]() |
Name of partitioned dataset (PDS) member | ![]() |
CHAR |
284 | ![]() |
DB2 member name in data sharing environment | ![]() |
CHAR |
285 | ![]() |
Date of last modification | ![]() |
DATS |
286 | ![]() |
DB2/OS390: Shows if check in DB system check can be modified | ![]() |
CHAR |
287 | ![]() |
Time of last modification | ![]() |
TIMS |
288 | ![]() |
AGE parameter of MODIFY RECOVERY utility | INT4 | |
289 | ![]() |
AGE parameter of MODIFY STATISTICS utility | INT4 | |
290 | ![]() |
Version marker for DB02's data stored in table MONI | ![]() |
CHAR |
291 | ![]() |
Maximum number of rows that DB2 will place on a data page | ![]() |
INT2 |
292 | ![]() |
DB2 for OS/390: ICLI message level | ![]() |
CHAR |
293 | ![]() |
Message server host | ![]() |
CHAR |
294 | ![]() |
Message server service | ![]() |
CHAR |
295 | ![]() |
Number of active pages in the tablespace | INT4 | |
296 | ![]() |
Time not attributed in DB2 / Time spent in DB2 (%) | ![]() |
CHAR |
297 | ![]() |
Number of rows relocated near their original page | INT4 | |
298 | ![]() |
Number of referred to rows near the optimal position | ![]() |
FLTP |
299 | ![]() |
Field to display network statistics | ![]() |
DEC |
300 | ![]() |
Time spent in network in milliseconds | ![]() |
DEC |
301 | ![]() |
Network statistics | ![]() |
INT4 |
302 | ![]() |
Getpages per rows processed | ![]() |
DEC |
303 | ![]() |
Number of active leaf pages in the index | INT4 | |
304 | ![]() |
DB2 for OS/390 number of levels in the index tree | ![]() |
INT2 |
305 | ![]() |
Reason for non-convertible | CHAR | |
306 | ![]() |
A reorg should never work on this tablespace or index | ![]() |
CHAR |
307 | ![]() |
Number of Tables | INT4 | |
308 | ![]() |
Percent of time spent in DB2 for notify messages | ![]() |
CHAR |
309 | ![]() |
Number of pages on which rows of the table appear | INT4 | |
310 | ![]() |
Number of pages on which rows of the table appear | ![]() |
DEC |
311 | ![]() |
Number of records in a table | ![]() |
DEC |
312 | ![]() |
Examined/rows processed (Only data rows are taken into acc.) | ![]() |
DEC |
313 | ![]() |
Number of tables defined in the tablespace | ![]() |
INT2 |
314 | ![]() |
Number of tables defined in the tablespace | INT4 | |
315 | ![]() |
Whether the column can contain null values | ![]() |
CHAR |
316 | ![]() |
Field type numc, length 3, 1 byte | ![]() |
NUMC |
317 | ![]() |
Field type numc, length 5, short integer | ![]() |
NUMC |
318 | ![]() |
Field type numc, length 10, integer | ![]() |
INT4 |
319 | ![]() |
'X' if parameter is numeric, ' ' otherwise | ![]() |
CHAR |
320 | ![]() |
Total number of extents of a tablespace or index | ![]() |
DEC |
321 | ![]() |
Number of extents of the dataset | ![]() |
INT2 |
322 | ![]() |
Number of extents | INT4 | |
323 | ![]() |
Number of extents of a partition of a tablespace or index | ![]() |
DEC |
324 | ![]() |
Total number of extents of a tablespace or index | ![]() |
DEC |
325 | ![]() |
Number of holders | ![]() |
NUMC |
326 | ![]() |
Number of indexes on a table | INT4 | |
327 | ![]() |
Number of partitions of a tablespace or index | ![]() |
INT2 |
328 | ![]() |
Number of pages | DEC | |
329 | ![]() |
DB2 page set ID | ![]() |
INT2 |
330 | ![]() |
Object name (table, index, column) | CHAR | |
331 | ![]() |
Type of object e.g. TS, IS, TB, IX | ![]() |
CHAR |
332 | ![]() |
Used storage space of a table (in KB) | ![]() |
DEC |
333 | ![]() |
Used storage space for the indexes of a table (in KB) | ![]() |
DEC |
334 | ![]() |
Percent of time spent in DB2 for open ,close, HSM recall | ![]() |
CHAR |
335 | ![]() |
Whether offload is switched on | ![]() |
CHAR |
336 | ![]() |
Different of far and near optimal position in page | ![]() |
INT2 |
337 | ![]() |
Number of referred to rows near/far from optimal position | ![]() |
FLTP |
338 | ![]() |
IFI DB Trace: Operation | ![]() |
CHAR |
339 | ![]() |
Order of the column in the key | ![]() |
CHAR |
340 | ![]() |
Order of the column in the key | ![]() |
CHAR |
341 | ![]() |
Percent of time spent in DB2 for other agents' read | ![]() |
CHAR |
342 | ![]() |
Percent time in DB2 for other synchronous EU switch services | ![]() |
CHAR |
343 | ![]() |
Percent of time spend in DB2 for other agents' writes | ![]() |
CHAR |
344 | ![]() |
CPU time spent out of DB2 | ![]() |
CHAR |
345 | ![]() |
Time spent out of DB2 | ![]() |
CHAR |
346 | ![]() |
Time spent out of DB2 | ![]() |
DEC |
347 | ![]() |
Percentage of time spent processing in DB2 | ![]() |
CHAR |
348 | ![]() |
Pseudo-close timer | ![]() |
NUMC |
349 | ![]() |
Index - padded | CHAR | |
350 | ![]() |
Number of page-ins | ![]() |
DEC |
351 | ![]() |
Page number | ![]() |
CHAR |
352 | ![]() |
Page-ins per pages read | ![]() |
DEC |
353 | ![]() |
Object name | ![]() |
CHAR |
354 | ![]() |
Object name | ![]() |
CHAR |
355 | ![]() |
Page-ins per pages read | ![]() |
DEC |
356 | ![]() |
DB2 for OS/390: Paramter to be checked in DB system check | ![]() |
CHAR |
357 | ![]() |
Archive log quiesce suspension time / time spent in DB2 (%) | ![]() |
CHAR |
358 | ![]() |
Archive read suspension time / Time spent in DB2 (%) | ![]() |
CHAR |
359 | ![]() |
No of Checked DB2 Installation Parameters | ![]() |
NUMC |
360 | ![]() |
No of Checked DB2 Installation Parameters with Error | ![]() |
NUMC |
361 | ![]() |
No of unchecked DB2 Installation Parameters | ![]() |
NUMC |
362 | ![]() |
No of Successfully Checked DB2 Installation Parameters | ![]() |
NUMC |
363 | ![]() |
No of Checked DB2 Installation Parameters | ![]() |
NUMC |
364 | ![]() |
Number of partitions of the tablespace or indexspace | ![]() |
INT2 |
365 | ![]() |
Extension or Partition (non-partitioned TS) number | INT4 | |
366 | ![]() |
Row ID or partition number, depending on resource type | ![]() |
CHAR |
367 | ![]() |
Number of partition | INT4 | |
368 | ![]() |
Partition number | ![]() |
INT2 |
369 | ![]() |
Page-ins per pages read (%) | ![]() |
DEC |
370 | ![]() |
DB2 for OS/390: Kernel patch level | INT4 | |
371 | ![]() |
Default Bufferpools | CHAR | |
372 | ![]() |
Claim release suspension time / Time spent in DB2 (%) | ![]() |
CHAR |
373 | ![]() |
CPU time spent in DB2 / Time spent in DB2 (%) | ![]() |
CHAR |
374 | ![]() |
Percentage | ![]() |
INT2 |
375 | ![]() |
Copy of DB2PCTCOMP as INT2 to be DB2 SMALLINT-conform | ![]() |
INT2 |
376 | ![]() |
Percentage of rows compressed within total number of rows | ![]() |
INT1 |
377 | ![]() |
DB2/390: Free space percentage on each page | ![]() |
NUMC |
378 | ![]() |
Percentage of each page left as free space | ![]() |
INT2 |
379 | ![]() |
Percentage of rows compressed within the total no. of rows | ![]() |
INT2 |
380 | ![]() |
Drain lock suspension time / Time spent in DB2 (%) | ![]() |
CHAR |
381 | ![]() |
Time dataset service task / time spent in DB2 (%) | ![]() |
CHAR |
382 | ![]() |
Accumulated CPU time user for DB2 | ![]() |
CHAR |
383 | ![]() |
Accumulated TCB time used before enclave is created | ![]() |
CHAR |
384 | ![]() |
Percentage of space occupied by rows of active tables | ![]() |
INT2 |
385 | ![]() |
Percent of time spent in DB2 for page latches | ![]() |
CHAR |
386 | ![]() |
Global locking suspension time / Time spent in DB2 (%) | ![]() |
CHAR |
387 | ![]() |
Number of Pages Read per Dynamic Prefetch Read | CHAR | |
388 | ![]() |
Number of Pages Read per List Prefetch Read | CHAR | |
389 | ![]() |
Number of Pages Read per Sequential Prefetch Read | CHAR | |
390 | ![]() |
Percentage of pages saved in the TS because of compression | ![]() |
INT2 |
391 | ![]() |
DB2 for OS/390 page size in KBytes | ![]() |
INT2 |
392 | ![]() |
Maximum size of a data set storage piece in KBytes | INT4 | |
393 | ![]() |
Maximum size of a dataset storage piece in KBytes | ![]() |
INT2 |
394 | ![]() |
Time spent in DB2 / Activity time (%) | ![]() |
CHAR |
395 | ![]() |
I/O suspension time / Time spent in DB2 (%) | ![]() |
CHAR |
396 | ![]() |
Name of the partitioned index | ![]() |
CHAR |
397 | ![]() |
Lock (Latch) supension time / Time spent in DB2 (%) | ![]() |
CHAR |
398 | ![]() |
Percent of time spent in DB2 for log write I/O | ![]() |
CHAR |
399 | ![]() |
Delete DB2PM API command trace file | ![]() |
CHAR |
400 | ![]() |
Delete DB2PM API connection trace file | ![]() |
CHAR |
401 | ![]() |
Delete DB2PM API data trace file | ![]() |
CHAR |
402 | ![]() |
Display DB2PM API command trace | ![]() |
CHAR |
403 | ![]() |
Display DB2PM API connection trace | ![]() |
CHAR |
404 | ![]() |
Display DB2PM API data trace | ![]() |
CHAR |
405 | ![]() |
Start DB2PM API command trace | ![]() |
CHAR |
406 | ![]() |
Start DB2PM API connection trace | ![]() |
CHAR |
407 | ![]() |
Start DB2PM API data trace | ![]() |
CHAR |
408 | ![]() |
Stop DB2PM API command trace | ![]() |
CHAR |
409 | ![]() |
Stop DB2PM API connection trace | ![]() |
CHAR |
410 | ![]() |
Stop DB2PM API data trace | ![]() |
CHAR |
411 | ![]() |
DB2PM API trace level | ![]() |
INT4 |
412 | ![]() |
DB2PM API trace type | ![]() |
INT4 |
413 | ![]() |
Not attributed time in DB2 / Time spent in DB2 | ![]() |
CHAR |
414 | ![]() |
Device on which the SYSREC dataset resides | ![]() |
CHAR |
415 | ![]() |
Dataset allocated to the SYSPUNCH DDNAME | ![]() |
CHAR |
416 | ![]() |
Primary space allocation for the SYSPNCH dataset (cyl.) | ![]() |
INT2 |
417 | ![]() |
Notify messages suspension time / Time spent in DB2 (%) | ![]() |
CHAR |
418 | ![]() |
Time for open/close ST / time spent in DB2 (%) | ![]() |
CHAR |
419 | ![]() |
Other read suspensions time / Time spent in db2 (%) | ![]() |
CHAR |
420 | ![]() |
Time for other service task / time spent in DB2 (%) | ![]() |
CHAR |
421 | ![]() |
Other write suspensions time / Time spent in DB2 (%) | ![]() |
CHAR |
422 | ![]() |
Time spent out of DB2 / Activity time (%) | ![]() |
CHAR |
423 | ![]() |
Time spent out of DB2 / Activity time (%) | ![]() |
CHAR |
424 | ![]() |
Page latch suspension time / Time spent in DB2 (%) | ![]() |
CHAR |
425 | ![]() |
Primary space allocation | INT4 | |
426 | ![]() |
Thread activity: % processing in DB2 | ![]() |
CHAR |
427 | ![]() |
Number of Times Sequential Prefetch Was Disabled | ![]() |
DEC |
428 | ![]() |
Number of Prepare Requests | ![]() |
DEC |
429 | ![]() |
DB2/390: Primary quantity | ![]() |
NUMC |
430 | ![]() |
Percentage of time spent processing in DB2 | ![]() |
CHAR |
431 | ![]() |
process ID | NUMC | |
432 | ![]() |
process type | CHAR | |
433 | ![]() |
DB2 page set ID | ![]() |
INT2 |
434 | ![]() |
DB2 page set ID | ![]() |
INT4 |
435 | ![]() |
Time SYSLGRNG recording service task / time spent in DB2 (%) | ![]() |
CHAR |
436 | ![]() |
Pageset name | ![]() |
CHAR |
437 | ![]() |
Time commit phase 2 or abort / Time spent in DB2 (%) | ![]() |
CHAR |
438 | ![]() |
Type of pageset | ![]() |
CHAR |
439 | ![]() |
Time spent suspended in DB2 / Time spent in DB2 (%) | ![]() |
CHAR |
440 | ![]() |
Total CPU time / Activity time | ![]() |
CHAR |
441 | ![]() |
Pages written per write I/O | ![]() |
DEC |
442 | ![]() |
Accumulated CPU Time | CHAR | |
443 | ![]() |
Statement Line Number | ![]() |
CHAR |
444 | ![]() |
RID List Not Used due to Insufficient Storage | CHAR | |
445 | ![]() |
RID List Not Used due to DB2 Limits Exceeded | CHAR | |
446 | ![]() |
Accumulated CPU Time | ![]() |
CHAR |
447 | ![]() |
Timestamp: Begin of Statistics Collection | ![]() |
CHAR |
448 | ![]() |
Accumulated Wait Time for Synchronous I/O | ![]() |
CHAR |
449 | ![]() |
Accumulated Wait Time for Lock and Latch Req. | ![]() |
CHAR |
450 | ![]() |
Accumulated Wait Time for Sync. Execution Unit Switch | ![]() |
CHAR |
451 | ![]() |
Accumulated Wait Time for Global Locks | ![]() |
CHAR |
452 | ![]() |
Accumulated Wait Time for Read Activity by Another Thread | ![]() |
CHAR |
453 | ![]() |
Accumulated Wait Time for Write Activity by Another Thread | ![]() |
CHAR |
454 | ![]() |
DB2 for OS/390: Data collector admin userid | ![]() |
CHAR |
455 | ![]() |
DB2 for OS/390: Types of collected history | ![]() |
CHAR |
456 | ![]() |
DB2 for OS/390: History data set name | ![]() |
CHAR |
457 | ![]() |
DB2 for OS/390: History data space size | INT4 | |
458 | ![]() |
DB2 for OS/390: History data set size | INT4 | |
459 | ![]() |
DB2 for OS/390: History collection interval in seconds | INT4 | |
460 | ![]() |
DB2 for OS/390: Common history interval in seconds | INT4 | |
461 | ![]() |
DB2 for OS/390: History uses data space field | ![]() |
CHAR |
462 | ![]() |
DB2 for OS/390: History qualifier names | ![]() |
CHAR |
463 | ![]() |
DB2 for OS/390: History qualifier value | ![]() |
CHAR |
464 | ![]() |
DB2 for OS/390: History processing on/off | ![]() |
RAW |
465 | ![]() |
Time elapsed | ![]() |
DEC |
466 | ![]() |
Time elapsed | CHAR | |
467 | ![]() |
Time elapsed | CHAR | |
468 | ![]() |
Number of copies of the statement | ![]() |
NUMC |
469 | ![]() |
Rows Examined | NUMC | |
470 | ![]() |
Number of executions of the statement | NUMC | |
471 | ![]() |
Getpages | NUMC | |
472 | ![]() |
Number of index scans performed for statement | NUMC | |
473 | ![]() |
Statement removed from cache by LRU (last recently used) | ![]() |
CHAR |
474 | ![]() |
Number of copies of the statement | ![]() |
INT4 |
475 | ![]() |
Number of parallel groups created for statement | NUMC | |
476 | ![]() |
Rows Processed | NUMC | |
477 | ![]() |
Synchronous Reads | NUMC | |
478 | ![]() |
Number of sorts performed for statement | NUMC | |
479 | ![]() |
DB2 statement name | ![]() |
RAW |
480 | ![]() |
Statement ID | ![]() |
NUMC |
481 | ![]() |
Number of tablespace scans performed for statement | NUMC | |
482 | ![]() |
Current Copies | NUMC | |
483 | ![]() |
Synchronous Writes | NUMC | |
484 | ![]() |
Rows examined (Only data rows are taken into account) | ![]() |
DEC |
485 | ![]() |
Number of executions of the statement | ![]() |
DEC |
486 | ![]() |
Getpages | ![]() |
DEC |
487 | ![]() |
Statement invalidated by DROP or ALTER | ![]() |
CHAR |
488 | ![]() |
Number of index scans performed for statement | ![]() |
DEC |
489 | ![]() |
Statement invalidated by RUNSTATS | ![]() |
CHAR |
490 | ![]() |
Statement invalidated by REVOKE | ![]() |
CHAR |
491 | ![]() |
Time when statement was inserted into cache | ![]() |
CHAR |
492 | ![]() |
Time when statement was inserted into cache | ![]() |
RAW |
493 | ![]() |
Cache literal replacement indicator | CHAR | |
494 | ![]() |
Number of parallel groups created for statement | ![]() |
DEC |
495 | ![]() |
Rows Processed | ![]() |
DEC |
496 | ![]() |
Synchronous Reads | ![]() |
DEC |
497 | ![]() |
Number of sorts performed for statement | ![]() |
DEC |
498 | ![]() |
Status of the statement | ![]() |
CHAR |
499 | ![]() |
Status of the statement | ![]() |
CHAR |
500 | ![]() |
The length of the SQL Statement | ![]() |
INT2 |