SAP ABAP Data Element - Index D, page 5
Data Element - D
# | Data Element | Short Description | Domain | Data Type |
---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
1 | ![]() |
Number of Random Access Getpage Requests | ![]() |
CHAR |
2 | ![]() |
Dynamic Statement Cache Global Hit Ratio | ![]() |
DEC |
3 | ![]() |
DB2/390: changes vs. all executions in percent | ![]() |
NUMC |
4 | ![]() |
Changed pages | ![]() |
DEC |
5 | ![]() |
Field type char, length 1 | ![]() |
CHAR |
6 | ![]() |
Field type char, length 2 | ![]() |
CHAR |
7 | ![]() |
Field type char, length 3 | ![]() |
CHAR |
8 | ![]() |
Field type char, length 4 | ![]() |
CHAR |
9 | ![]() |
Field type char, length 5 | ![]() |
CHAR |
10 | ![]() |
Field type char, length 6 | ![]() |
CHAR |
11 | ![]() |
Field type char, length 8 | ![]() |
CHAR |
12 | ![]() |
Field type char, length 12 | ![]() |
CHAR |
13 | ![]() |
Field type char, length 16 | ![]() |
CHAR |
14 | ![]() |
Field type char, length 17 | ![]() |
CHAR |
15 | ![]() |
Data element of length 20 | ![]() |
CHAR |
16 | ![]() |
Field type char, length 22 | ![]() |
CHAR |
17 | ![]() |
char 256 | ![]() |
CHAR |
18 | ![]() |
Field type CHAR, length 30 | ![]() |
CHAR |
19 | ![]() |
Data element of length 40 | ![]() |
CHAR |
20 | ![]() |
Number of extents: change per day | ![]() |
DEC |
21 | ![]() |
Number of extents: change per day | INT4 | |
22 | ![]() |
Number of extents: change per month | ![]() |
DEC |
23 | ![]() |
Number of extents: change per month | INT4 | |
24 | ![]() |
Number of extents: change per day | ![]() |
DEC |
25 | ![]() |
Number of extents: change per day | ![]() |
DEC |
26 | ![]() |
Number of extents: change per month | ![]() |
DEC |
27 | ![]() |
Number of extents: change per time interval | ![]() |
DEC |
28 | ![]() |
Number of extents: change per week | ![]() |
DEC |
29 | ![]() |
Number of extents: change per week | ![]() |
DEC |
30 | ![]() |
Number of extents: change per week | INT4 | |
31 | ![]() |
Free storage (allocated minus used) in KB: change per day | ![]() |
DEC |
32 | ![]() |
Free storage (allocated minus used) in KB: change per month | ![]() |
DEC |
33 | ![]() |
Free storage in KB: Change per time interval | ![]() |
DEC |
34 | ![]() |
Free storage (allocated minus used) in KB: change per week | ![]() |
DEC |
35 | ![]() |
Number of Rows: changes per day | ![]() |
FLTP |
36 | ![]() |
Number of Rows: changes per month | ![]() |
FLTP |
37 | ![]() |
Number of Rows: changes per week | ![]() |
FLTP |
38 | ![]() |
Allocated storage in KB: change per day | ![]() |
DEC |
39 | ![]() |
Allocated storage in KB: change per month | ![]() |
DEC |
40 | ![]() |
Allocated storage in KB: change per time interval | ![]() |
DEC |
41 | ![]() |
Allocated storage in KB: change per week | ![]() |
DEC |
42 | ![]() |
Change/day for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ![]() |
FLTP |
43 | ![]() |
Change/month for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ![]() |
FLTP |
44 | ![]() |
Change/week for DASD space (SYSIBM.SYSTABLES(SPACEF)) | ![]() |
FLTP |
45 | ![]() |
RTS Table size (= TOTALENTRIES*AvgRowLen KB) daily changes | ![]() |
FLTP |
46 | ![]() |
Tx DB02: Absolute difference in comparison to first run | ![]() |
FLTP |
47 | ![]() |
Tx DB02: Absolute difference in comparison to previous run | ![]() |
FLTP |
48 | ![]() |
RTS Table size (= TOTALENTRIES*AvgRowLen KB) monthly changes | ![]() |
FLTP |
49 | ![]() |
Tx DB02: Difference (percent) in comparison to previous run | INT4 | |
50 | ![]() |
RTS Table size (= TOTALENTRIES*AvgRowLen KB) weekly changes | ![]() |
FLTP |
51 | ![]() |
DB2 OS/390: corrective action for error in DB system check | ![]() |
CHAR |
52 | ![]() |
DB2 for OS/390: Date of the check | ![]() |
DATS |
53 | ![]() |
DB2 OS/390: Description of error reported by DB system check | ![]() |
CHAR |
54 | ![]() |
DB2 for OS/390: Description of DB system check error message | ![]() |
CHAR |
55 | ![]() |
DB2 for OS/390 DB system check - name of a check | ![]() |
CHAR |
56 | ![]() |
DB2 for OS/390: Number of checks performed | ![]() |
NUMC |
57 | ![]() |
DB2 for OS/390: Type of object checked in DB system check | ![]() |
CHAR |
58 | ![]() |
Number of checkpoints taken | ![]() |
NUMC |
59 | ![]() |
DB2 for OS/390: Qualifier of check object | ![]() |
CHAR |
60 | ![]() |
Result of DB2 Installation Parameter Check | ![]() |
CHAR |
61 | ![]() |
DB2 for OS/390: Severity of error detected | ![]() |
CHAR |
62 | ![]() |
Type of Check for DB2 Installation Parameter(s) Check | ![]() |
CHAR |
63 | ![]() |
DB2 for OS/390: Time of the check | ![]() |
TIMS |
64 | ![]() |
DB2 for OS/390: Type of DB system check | ![]() |
CHAR |
65 | ![]() |
DB2 for OS/390: Parameter value in DB system check | ![]() |
CHAR |
66 | ![]() |
DB2 for OS/390: Parameter value in DB system check | ![]() |
CHAR |
67 | ![]() |
DB2 for OS/390: Parameter value in DB system check | ![]() |
CHAR |
68 | ![]() |
Percentage of Hiperpool Buffers Backed | ![]() |
CHAR |
69 | ![]() |
Hiperpool efficiency | ![]() |
CHAR |
70 | ![]() |
Number of Hiperpool Failures | ![]() |
CHAR |
71 | ![]() |
Hiperpool reads ratio (high) | ![]() |
CHAR |
72 | ![]() |
Hiperpool read ratio (low) | ![]() |
CHAR |
73 | ![]() |
Number of entries to and exits from IFI events | ![]() |
NUMC |
74 | ![]() |
Accumulated elapsed time spent processing IFI calls | ![]() |
CHAR |
75 | ![]() |
Accumulated CPU time spent processing IFI calls | ![]() |
CHAR |
76 | ![]() |
Percentage of time spent in DB2 | ![]() |
CHAR |
77 | ![]() |
![]() |
INT2 | |
78 | ![]() |
Field Type INT, Length 4 | ![]() |
INT4 |
79 | ![]() |
Current number of pages in EDM pool used for cursor tables | ![]() |
NUMC |
80 | ![]() |
Number of requests for cursor table sections | ![]() |
NUMC |
81 | ![]() |
Number of CT sections not found in EDM pool | ![]() |
NUMC |
82 | ![]() |
Current number of pages in EDM pool used for DB descriptor | ![]() |
NUMC |
83 | ![]() |
Number of requests for database descriptor | ![]() |
NUMC |
84 | ![]() |
Number of DB descriptors not found in EDM pool | ![]() |
NUMC |
85 | ![]() |
Number of failures because the data space is full | ![]() |
NUMC |
86 | ![]() |
Number of free pages in the data space free chain | ![]() |
NUMC |
87 | ![]() |
Number of pages in the data space used by the EDM pool | ![]() |
NUMC |
88 | ![]() |
Number of pages used for DSC | ![]() |
NUMC |
89 | ![]() |
Number of requests for DSC sections | ![]() |
NUMC |
90 | ![]() |
Number of inserts into EDM pool for dynamic statement cache | ![]() |
NUMC |
91 | ![]() |
Current number of free pages in the free chain | ![]() |
NUMC |
92 | ![]() |
Current number of pages in EDM pool used for package tables | ![]() |
NUMC |
93 | ![]() |
Number of requests for package table sections | ![]() |
NUMC |
94 | ![]() |
Number of times a PT section was not found in EDM pool | ![]() |
NUMC |
95 | ![]() |
Current number of pages in the EDM pool | ![]() |
NUMC |
96 | ![]() |
Current number of pages in EDM pool used for skeleton CT | ![]() |
NUMC |
97 | ![]() |
Current number of pages in EDM pool used for skeleton PT | ![]() |
NUMC |
98 | ![]() |
RID block allocated - current | ![]() |
NUMC |
99 | ![]() |
RID blocks allocated - maximum | ![]() |
NUMC |
100 | ![]() |
RDS limit exceeded | ![]() |
NUMC |
101 | ![]() |
Process limit exceeded | ![]() |
NUMC |
102 | ![]() |
Physical limit reached | ![]() |
NUMC |
103 | ![]() |
RID list processing exhausted virtual storage | ![]() |
NUMC |
104 | ![]() |
Number of archive log read allocations | ![]() |
NUMC |
105 | ![]() |
Number of archive log write allocations | ![]() |
NUMC |
106 | ![]() |
Number of Active Log Output Control Intervals Created | ![]() |
NUMC |
107 | ![]() |
Number of calls to the log write routine | ![]() |
NUMC |
108 | ![]() |
Number of BSDS Access Requests | ![]() |
NUMC |
109 | ![]() |
Count of Control Intervals Offloaded | ![]() |
NUMC |
110 | ![]() |
Check Tape Mounts Attempted | ![]() |
NUMC |
111 | ![]() |
Successful "look ahead" (tape volume) mounts attempted | ![]() |
NUMC |
112 | ![]() |
Number of Log Reads Satisfied from Active Log Data Set | ![]() |
NUMC |
113 | ![]() |
Number of Log Reads Satisfied from Archive Log Data Set | ![]() |
NUMC |
114 | ![]() |
Number of Log Reads Satisfied from Output Buffer | ![]() |
NUMC |
115 | ![]() |
Read accesses delayed due to tape volume contention | ![]() |
NUMC |
116 | ![]() |
Number of Write-No-Wait Requests | ![]() |
NUMC |
117 | ![]() |
Unavailable output log buffers | ![]() |
NUMC |
118 | ![]() |
Read accesses delayed due to unavailable resource | ![]() |
NUMC |
119 | ![]() |
DB2 for OS/390 check class for system check | ![]() |
CHAR |
120 | ![]() |
DB2 for OS/390: check operator (system check) | ![]() |
CHAR |
121 | ![]() |
![]() |
LCHR | |
122 | ![]() |
![]() |
INT2 | |
123 | ![]() |
![]() |
INT2 | |
124 | ![]() |
![]() |
CHAR | |
125 | ![]() |
Dynamic Statement Cache Local Hit Ratio | ![]() |
DEC |
126 | ![]() |
![]() |
INT4 | |
127 | ![]() |
![]() |
INT4 | |
128 | ![]() |
Percent of time spent in DB2 for claim locks | ![]() |
CHAR |
129 | ![]() |
Field type char, length 1 | ![]() |
CHAR |
130 | ![]() |
![]() |
CHAR | |
131 | ![]() |
ICLI client trace level | INT4 | |
132 | ![]() |
![]() |
INT4 | |
133 | ![]() |
DB2 for OS/390 cluster ratio | ![]() |
INT1 |
134 | ![]() |
Clusterratio: Percentage of rows in clustering order | ![]() |
INT2 |
135 | ![]() |
DB2 for OS/390 cluster ratio | ![]() |
CHAR |
136 | ![]() |
Whether CLUSTER was specified when the index was created | ![]() |
CHAR |
137 | ![]() |
Whether the table is actually clustered by the index | ![]() |
CHAR |
138 | ![]() |
Indicates whether the COMPRESS attribute is YES | ![]() |
CHAR |
139 | ![]() |
Field type numc, length 3, 1 byte | ![]() |
NUMC |
140 | ![]() |
Field type numc, length 5, short integer | ![]() |
NUMC |
141 | ![]() |
Field type numc, length 10, integer | ![]() |
NUMC |
142 | ![]() |
Number of columns in the table or view | ![]() |
INT2 |
143 | ![]() |
Length attribute of the column | ![]() |
INT2 |
144 | ![]() |
column length | INT4 | |
145 | ![]() |
Column name | ![]() |
CHAR |
146 | ![]() |
DB2 column name | CHAR | |
147 | ![]() |
Numeric position of the column in the table or view | ![]() |
INT2 |
148 | ![]() |
Numeric position of the column in the key | ![]() |
INT2 |
149 | ![]() |
Column type specified in the column definition | ![]() |
CHAR |
150 | ![]() |
The SQL statement text | ![]() |
CHAR |
151 | ![]() |
connection type | CHAR | |
152 | ![]() |
DB2 Type of Conversion | CHAR | |
153 | ![]() |
Index can be copied | ![]() |
CHAR |
154 | ![]() |
Device on which the SYSCOPY dataset resides | ![]() |
CHAR |
155 | ![]() |
Dataset allocated to the SYSCOPY DDNAME | ![]() |
CHAR |
156 | ![]() |
Primary space allocation for the SYSCOPY dataset (cyl.) | ![]() |
INT2 |
157 | ![]() |
Device on which the SYSCOPY2 dataset resides | ![]() |
CHAR |
158 | ![]() |
Dataset allocated to the SYSCOPY2 DDNAME | ![]() |
CHAR |
159 | ![]() |
Primary space allocation for the SYSCOPY2 dataset (cyl.) | ![]() |
INT2 |
160 | ![]() |
Number of page-ins | ![]() |
CHAR |
161 | ![]() |
Number of Pages Read per Dynamic Prefetch Read | ![]() |
CHAR |
162 | ![]() |
Number of Pages Read per List Prefetch Read | ![]() |
CHAR |
163 | ![]() |
Number of Pages Read per Sequential Prefetch Read | ![]() |
CHAR |
164 | ![]() |
Number of Times Sequential Prefetch Was Disabled | ![]() |
CHAR |
165 | ![]() |
Number of Prepare Requests | ![]() |
NUMC |
166 | ![]() |
Percentage of time spent processing in DB2 | ![]() |
CHAR |
167 | ![]() |
Total CPU processing time | ![]() |
CHAR |
168 | ![]() |
Pages written per write I/O | ![]() |
CHAR |
169 | ![]() |
CHANGELIMIT option of COPY utility | ![]() |
CHAR |
170 | ![]() |
First value in the CHANGELIMIT range | ![]() |
CHAR |
171 | ![]() |
Second value in the CHANGELIMIT range | ![]() |
CHAR |
172 | ![]() |
Name of the database the tablespace belongs to | ![]() |
CHAR |
173 | ![]() |
Partition or data set that is to be copied | ![]() |
CHAR |
174 | ![]() |
Specifies if either a full or an incremental copy is taken | ![]() |
CHAR |
175 | ![]() |
Specifies that image copy information is only displayed | ![]() |
CHAR |
176 | ![]() |
COPY share level | ![]() |
CHAR |
177 | ![]() |
Table space that is to be copied | ![]() |
CHAR |
178 | ![]() |
Number of failures in adding an entry to authorization cache | ![]() |
NUMC |
179 | ![]() |
Number of authorization ID overrides in authorization cache | ![]() |
NUMC |
180 | ![]() |
Number of routine entry overrides in authorization cache | ![]() |
NUMC |
181 | ![]() |
Number of successful public authorization checks | ![]() |
NUMC |
182 | ![]() |
Number of authorization checks without authorization cache | ![]() |
NUMC |
183 | ![]() |
Field type raw, length 2, 1 byte | ![]() |
RAW |
184 | ![]() |
Field type raw, length 8, 4 bytes | ![]() |
INT4 |
185 | ![]() |
Read rate per second | ![]() |
CHAR |
186 | ![]() |
Time when the CREATE statement was executed | ![]() |
CHAR |
187 | ![]() |
Pages read vs. pages written | ![]() |
CHAR |
188 | ![]() |
DB2 creator name | ![]() |
CHAR |
189 | ![]() |
DB2 creator name | CHAR | |
190 | ![]() |
Authorization ID of the creator of the partitioned index | ![]() |
CHAR |
191 | ![]() |
Field type char, length 1, reserved | ![]() |
CHAR |
192 | ![]() |
Field type char, length 2, reserved | ![]() |
CHAR |
193 | ![]() |
Field type char, length 3, reserved | ![]() |
CHAR |
194 | ![]() |
Field type char, length 4, reserved | ![]() |
CHAR |
195 | ![]() |
Character field of length 5 (reserved) | ![]() |
CHAR |
196 | ![]() |
Resource limit facility error parameter | ![]() |
CHAR |
197 | ![]() |
Random hit ratio | ![]() |
CHAR |
198 | ![]() |
Reprepare Ratio | ![]() |
DEC |
199 | ![]() |
Data sets for closure when limit of open data sets reached | ![]() |
CHAR |
200 | ![]() |
Number of Short Prepares | ![]() |
NUMC |
201 | ![]() |
Current value (KB) of secondary quantity from catalog | INT4 | |
202 | ![]() |
DB2/390: Total central storage available for all bufferpools | ![]() |
NUMC |
203 | ![]() |
Number of Random Access Synchronous Reads | ![]() |
NUMC |
204 | ![]() |
Number of datasets that were closed via the DRAIN process | ![]() |
NUMC |
205 | ![]() |
Number of datasets open concurrently | ![]() |
NUMC |
206 | ![]() |
IFI entry/exit duration elapsed time | ![]() |
CHAR |
207 | ![]() |
IFI entry/exit duration processing (CPU) | ![]() |
CHAR |
208 | ![]() |
Field type time, HHMMSS | ![]() |
TIMS |
209 | ![]() |
Max. no. of datasets open concurrently | ![]() |
NUMC |
210 | ![]() |
Page sets available to drain since last statistics interval | ![]() |
NUMC |
211 | ![]() |
No. of infrequently updated datasets conv. from R/W to R/O | ![]() |
NUMC |
212 | ![]() |
Number of successful authorization checks | ![]() |
NUMC |
213 | ![]() |
Number of times a previously unused dataset was used | ![]() |
NUMC |
214 | ![]() |
Datasets not used, but not closed due to deferred close | ![]() |
NUMC |
215 | ![]() |
Number of change requests | ![]() |
NUMC |
216 | ![]() |
Number of claim requests | ![]() |
NUMC |
217 | ![]() |
Number of claim requests that were unsuccessful | ![]() |
NUMC |
218 | ![]() |
Number of deadlocks | ![]() |
NUMC |
219 | ![]() |
Number of drain requests | ![]() |
NUMC |
220 | ![]() |
Number of drain requests that were unsuccessful | ![]() |
NUMC |
221 | ![]() |
Number of other requests | ![]() |
NUMC |
222 | ![]() |
Number of lock escalations (shared) | ![]() |
NUMC |
223 | ![]() |
Number of lock escalations (exclusive) | ![]() |
NUMC |
224 | ![]() |
Number of lock requests | ![]() |
NUMC |
225 | ![]() |
Maximum page or row locks held | ![]() |
NUMC |
226 | ![]() |
Number of query requests | ![]() |
NUMC |
227 | ![]() |
Number of latch suspensions | ![]() |
NUMC |
228 | ![]() |
Number of lock suspensions | ![]() |
NUMC |
229 | ![]() |
Number of other suspensions | ![]() |
NUMC |
230 | ![]() |
Number of timeouts | ![]() |
NUMC |
231 | ![]() |
Number of unlock requests | ![]() |
NUMC |
232 | ![]() |
Buffer update per pages written | ![]() |
CHAR |
233 | ![]() |
Number of Virtual Pool Shortages | ![]() |
CHAR |
234 | ![]() |
DB2/390: Conversion Result Set | ![]() |
CHAR |
235 | ![]() |
Deadlock cycle | ![]() |
NUMC |
236 | ![]() |
Deadlock time (ms) | ![]() |
NUMC |
237 | ![]() |
IRLM maximum CSA usage allowed | ![]() |
NUMC |
238 | ![]() |
Actual resource timeout | ![]() |
NUMC |
239 | ![]() |
Total number bytes of log records written | ![]() |
CHAR |
240 | ![]() |
Number of log records written | ![]() |
NUMC |
241 | ![]() |
Average Work Files Not Given per Degraded Merge Pass | ![]() |
CHAR |
242 | ![]() |
Average Work Files per Merge Pass | ![]() |
CHAR |
243 | ![]() |
The end user's work station user ID | ![]() |
CHAR |
244 | ![]() |
Transaction or application the end user is running | ![]() |
CHAR |
245 | ![]() |
The end user's workstation name | ![]() |
CHAR |
246 | ![]() |
Indicates whether autobind operations are allowed | ![]() |
CHAR |
247 | ![]() |
Indicates Whether Explain is Allowed During Autobind | ![]() |
CHAR |
248 | ![]() |
The authorization ID of the system administrator 2 | ![]() |
CHAR |
249 | ![]() |
Indicates the size of the authorization cache | ![]() |
NUMC |
250 | ![]() |
DB2 authorization | ![]() |
CHAR |
251 | ![]() |
Indicates the authorities required to add a new package | ![]() |
CHAR |
252 | ![]() |
Indicates Whether Change Data Capture is Enabled | ![]() |
CHAR |
253 | ![]() |
Default Parallelism Degree | ![]() |
CHAR |
254 | ![]() |
Cache prepared dynamic SQL statements | ![]() |
CHAR |
255 | ![]() |
Storage Contraction | ![]() |
CHAR |
256 | ![]() |
Storage Contraction Threshold (Commits) | ![]() |
NUMC |
257 | ![]() |
SMS Dataclass for tablespaces | ![]() |
CHAR |
258 | ![]() |
SMS Dataclass for indexspaces | ![]() |
CHAR |
259 | ![]() |
Asynchronous drain start | ![]() |
NUMC |
260 | ![]() |
The authorization ID of the system default user | ![]() |
CHAR |
261 | ![]() |
Minimum Divide Scale | ![]() |
CHAR |
262 | ![]() |
Maximum locks per table(space) before escalation | ![]() |
NUMC |
263 | ![]() |
If an SQLDA for Describe is Built During Bind for Static SQL | ![]() |
CHAR |
264 | ![]() |
Default index type | ![]() |
NUMC |
265 | ![]() |
EDM Pool Algorithm | ![]() |
CHAR |
266 | ![]() |
EDM Pool Data Space Size (MB) | ![]() |
NUMC |
267 | ![]() |
Maximum Size of the EDM Pool (MB) | ![]() |
NUMC |
268 | ![]() |
Indicates Whether DPROP is Supported | ![]() |
CHAR |
269 | ![]() |
The data definition escape character for ART and ORT search | ![]() |
CHAR |
270 | ![]() |
Indicates Whether Access Path Hints are Allowed | ![]() |
CHAR |
271 | ![]() |
Hop site authorization | ![]() |
CHAR |
272 | ![]() |
Autostart of IRLM | ![]() |
CHAR |
273 | ![]() |
Indicates whether IRLM is started automatically by DB2 | ![]() |
CHAR |
274 | ![]() |
Name of IRLM procedure which DB2 uses to start IRLM | ![]() |
CHAR |
275 | ![]() |
Name of the IRLM subsystem by which IRLM is known to MVS | ![]() |
CHAR |
276 | ![]() |
Seconds DB2 will wait for IRLM start | ![]() |
NUMC |
277 | ![]() |
Max. no. of language environment tokens active at any time | ![]() |
NUMC |
278 | ![]() |
Maximum number of locks per tablespace | ![]() |
NUMC |
279 | ![]() |
Maximum number of locks per user | ![]() |
NUMC |
280 | ![]() |
Asynchronous drain stop | ![]() |
NUMC |
281 | ![]() |
Maximum number of prepared dynamic statements | ![]() |
NUMC |
282 | ![]() |
NPAGES threshold for index scan | ![]() |
NUMC |
283 | ![]() |
Outer Join Performance Enhancement | ![]() |
CHAR |
284 | ![]() |
The authorization ID of the system operator 1 | ![]() |
CHAR |
285 | ![]() |
The authorization ID of the system operator 2 | ![]() |
CHAR |
286 | ![]() |
Package authorization cache | ![]() |
NUMC |
287 | ![]() |
Utility Cache Option | ![]() |
CHAR |
288 | ![]() |
Routine authorization cache size | ![]() |
NUMC |
289 | ![]() |
If Page or Row Locks for Held Cursors are Released at Commit | ![]() |
CHAR |
290 | ![]() |
Name of the application registration table | ![]() |
CHAR |
291 | ![]() |
Whether Only Registered Packages or Plans Can Use DDL | ![]() |
CHAR |
292 | ![]() |
Owner of the application registration table | ![]() |
CHAR |
293 | ![]() |
Whether Data Definition Control Support is to Be Used | ![]() |
CHAR |
294 | ![]() |
Name of the database containing the registration tables | ![]() |
CHAR |
295 | ![]() |
The name of the object registration table | ![]() |
CHAR |
296 | ![]() |
Whether Two-Part Names are Required for Objects Reg. in ORT | ![]() |
CHAR |
297 | ![]() |
Unregistered DDL Default | ![]() |
CHAR |
298 | ![]() |
Maximum Size of RID Pool in the DB2 Subsystem (MB) | ![]() |
NUMC |
299 | ![]() |
UPDATE lock for repeatable read or read stability | ![]() |
CHAR |
300 | ![]() |
The authorization ID of the system administrator 1 | ![]() |
CHAR |
301 | ![]() |
Sequential Mode to Read Cached Data from a 3990 Controller | CHAR | |
302 | ![]() |
Indicates Whether the Site is Local or Remote | ![]() |
CHAR |
303 | ![]() |
Maximum Size of the Sort Pool (MB) | ![]() |
INT4 |
304 | ![]() |
Storage Contraction Threshold (MB) | ![]() |
NUMC |
305 | ![]() |
Maximum time DB2 waits for the release of a locked resource | ![]() |
NUMC |
306 | ![]() |
Maximum degree of utility parallelism | ![]() |
NUMC |
307 | ![]() |
Utility timeout factor | ![]() |
NUMC |
308 | ![]() |
VARCHAR from Index | ![]() |
CHAR |
309 | ![]() |
Multiplier for Determining Retained Lock Timeout | ![]() |
NUMC |
310 | ![]() |
Whether X lock is Used for Searched Update or Delete | ![]() |
CHAR |
311 | ![]() |
Flag if X lock is Used for Searched Update or Delete | ![]() |
CHAR |
312 | ![]() |
High qualifier name for all DB2 system datasets | ![]() |
CHAR |
313 | ![]() |
Name of database to be automatically started | ![]() |
CHAR |
314 | ![]() |
Table space name or index space name | ![]() |
CHAR |
315 | ![]() |
Status of a DBAT | ![]() |
CHAR |
316 | ![]() |
Maximum type 1 inactive threads allowed by DB2 | ![]() |
NUMC |
317 | ![]() |
Resource Limit Facility Error Parameter | ![]() |
CHAR |
318 | ![]() |
Specifies the Limit in CPU Time Service Units | ![]() |
NUMC |
319 | ![]() |
Number of minutes between two resynchronization intervals | ![]() |
NUMC |
320 | ![]() |
The startup option for the distributed data facility (DDF) | ![]() |
CHAR |
321 | ![]() |
Whether Verified Conn. Are Accepted from TCP/IP Clients | ![]() |
CHAR |
322 | ![]() |
Idle thread timeout | ![]() |
NUMC |
323 | ![]() |
Indicates whether this DB2 can assist parallel processing | ![]() |
CHAR |
324 | ![]() |
Whether a DB2 subsystem can be a parallelism coordinator | ![]() |
CHAR |
325 | ![]() |
Name of a DB2 data sharing group | ![]() |
CHAR |
326 | ![]() |
Whether data sharing function is used or not | ![]() |
CHAR |
327 | ![]() |
Maximum Number of Members | ![]() |
NUMC |
328 | ![]() |
Name of a new or existing DB2 data sharing member | ![]() |
CHAR |
329 | ![]() |
CPU Service Unit Conversion Factor | ![]() |
NUMC |
330 | ![]() |
ASCII GBCS CCSID | ![]() |
NUMC |
331 | ![]() |
The ASCII mixed coded character set ID | ![]() |
NUMC |
332 | ![]() |
Indicates the rules of precision for a decimal field | ![]() |
CHAR |
333 | ![]() |
The ASCII single-byte coded character set ID | ![]() |
NUMC |
334 | ![]() |
The default character set, which can be ALPHANUM or KATAKANA | ![]() |
CHAR |
335 | ![]() |
The default output format for dates | ![]() |
CHAR |
336 | ![]() |
Whether the decimal contains a comma (,) or a period (.) | ![]() |
CHAR |
337 | ![]() |
Default Delimiter | ![]() |
CHAR |
338 | ![]() |
Local date length | ![]() |
NUMC |
339 | ![]() |
Indicates if DSNHDECP values are used for dyn.SQL statements | ![]() |
CHAR |
340 | ![]() |
Distributed SQL string delimiter | ![]() |
CHAR |
341 | ![]() |
The default encoding scheme, which can be ASCII or EBCDIC. | ![]() |
CHAR |
342 | ![]() |
The EBCDIC graphic coded character set ID | ![]() |
NUMC |
343 | ![]() |
Default mixed graphic | ![]() |
CHAR |
344 | ![]() |
The default programming language for your site | ![]() |
CHAR |
345 | ![]() |
Default Locale LC_CTYPE | ![]() |
CHAR |
346 | ![]() |
The EBCDIC mixed coded character set ID | ![]() |
NUMC |
347 | ![]() |
The string delimiter for SQL | ![]() |
CHAR |
348 | ![]() |
The EBCDIC single-byte coded character set ID | ![]() |
NUMC |
349 | ![]() |
SQL language support level | ![]() |
CHAR |
350 | ![]() |
The default output format for times | ![]() |
CHAR |
351 | ![]() |
Local time length | ![]() |
NUMC |
352 | ![]() |
Write rate = ( Synchronous + async. writes ) / interval | ![]() |
CHAR |
353 | ![]() |
Number of checkpoints DB2 has taken since startup | ![]() |
NUMC |
354 | ![]() |
Count of IFI abends | ![]() |
NUMC |
355 | ![]() |
Count of IFI command requests | ![]() |
NUMC |
356 | ![]() |
Count of IFI READA requests | ![]() |
NUMC |
357 | ![]() |
Count of IFI READS requests | ![]() |
NUMC |
358 | ![]() |
Count of IFI WRITE requests | ![]() |
NUMC |
359 | ![]() |
Count of IFI unrecognized functions. | ![]() |
NUMC |
360 | ![]() |
Number of ALTER DATABASE statements executed | ![]() |
NUMC |
361 | ![]() |
Number of ALTER PROCEDURE statements | ![]() |
NUMC |
362 | ![]() |
Number of ALTER INDEX statements executed | ![]() |
NUMC |
363 | ![]() |
Number of ALTER STORAGE GROUP statements executed | ![]() |
NUMC |
364 | ![]() |
Number of ALTER TABLE statements executed | ![]() |
NUMC |
365 | ![]() |
Number of ALTER TABLE SPACE statements executed | ![]() |
NUMC |
366 | ![]() |
Number of ALTER FUNCTION statements | ![]() |
NUMC |
367 | ![]() |
Number of SQL CALL statements executed | ![]() |
NUMC |
368 | ![]() |
Maximum level of nested SQL cascading | ![]() |
NUMC |
369 | ![]() |
Number of user-defined functions executed | ![]() |
NUMC |
370 | ![]() |
Number of times a user-defined function abended | ![]() |
NUMC |
371 | ![]() |
Number of times a user-defined function was rejected | ![]() |
NUMC |
372 | ![]() |
No. of times a user-defined funct. timed out before sched. | ![]() |
NUMC |
373 | ![]() |
Number of CREATE DISTINCT TYPE statements | ![]() |
NUMC |
374 | ![]() |
Number of CLOSE CURSOR statements executed | ![]() |
NUMC |
375 | ![]() |
Number of COMMENT ON statements executed | ![]() |
NUMC |
376 | ![]() |
Number of CONNECT TYPE 1 statements executed | ![]() |
NUMC |
377 | ![]() |
Number of CONNECT TYPE 2 statements executed | ![]() |
NUMC |
378 | ![]() |
Number of CREATE ALIAS statements executed | ![]() |
NUMC |
379 | ![]() |
Number of CREATE AUXILIARY TABLE statements | ![]() |
NUMC |
380 | ![]() |
Number of CREATE DATABASE statements executed | ![]() |
NUMC |
381 | ![]() |
Number of CREATE INDEX statements executed | ![]() |
NUMC |
382 | ![]() |
Number of CREATE PROCEDURE statements | ![]() |
NUMC |
383 | ![]() |
Number of CREATE STORAGE GROUP statements executed | ![]() |
NUMC |
384 | ![]() |
Number of CREATE SYNONYM statements executed | ![]() |
NUMC |
385 | ![]() |
Number of CREATE TABLE statements executed | ![]() |
NUMC |
386 | ![]() |
Number of CREATE FUNCTION statements | ![]() |
NUMC |
387 | ![]() |
Number of CREATE TABLE SPACE statements executed | ![]() |
NUMC |
388 | ![]() |
Number of SQL CREATE TRIGGER statements | ![]() |
NUMC |
389 | ![]() |
Number of DROP DISTINCT TYPE statements | ![]() |
NUMC |
390 | ![]() |
Number of CREATE VIEW statements executed | ![]() |
NUMC |
391 | ![]() |
Number of DELETE statements executed | ![]() |
NUMC |
392 | ![]() |
Number of DESCRIBE statements executed | ![]() |
NUMC |
393 | ![]() |
Number of DROP ALIAS statements executed | ![]() |
NUMC |
394 | ![]() |
Number of DROP DATABASE statements executed | ![]() |
NUMC |
395 | ![]() |
Number of DROP UDF statements | ![]() |
NUMC |
396 | ![]() |
Number of DROP INDEX statements executed | ![]() |
NUMC |
397 | ![]() |
Number of DROP PACKAGE statements executed | ![]() |
NUMC |
398 | ![]() |
Number of DROP PROCEDURE statements | ![]() |
NUMC |
399 | ![]() |
Number of DROP STORAGE GROUP statements executed | ![]() |
NUMC |
400 | ![]() |
Number of DROP SYNONYM statements executed | ![]() |
NUMC |
401 | ![]() |
Number of DROP TABLE statements executed | ![]() |
NUMC |
402 | ![]() |
Number of SQL DROP TRIGGER statements | ![]() |
NUMC |
403 | ![]() |
Number of DROP TABLE SPACE statements executed | ![]() |
NUMC |
404 | ![]() |
Number of DROP VIEW statements executed | ![]() |
NUMC |
405 | ![]() |
Number of DESCRIBE TABLE statements executed | ![]() |
NUMC |
406 | ![]() |
Number of FETCH statements executed | ![]() |
NUMC |
407 | ![]() |
Number of FREE LOCATOR statements | ![]() |
NUMC |
408 | ![]() |
Number of GRANT statements executed | ![]() |
NUMC |
409 | ![]() |
Number of HOLD LOCATOR statements | ![]() |
NUMC |
410 | ![]() |
Number of INCREMENTAL BINDs executed | ![]() |
NUMC |
411 | ![]() |
Number of INSERT statements executed | ![]() |
NUMC |
412 | ![]() |
Number of LABEL ON statements executed | ![]() |
NUMC |
413 | ![]() |
Number of LOCK TABLE statements executed | ![]() |
NUMC |
414 | ![]() |
Number of times RID list processing is used | ![]() |
NUMC |
415 | ![]() |
RID list processing failed - limit exeeded | ![]() |
NUMC |
416 | ![]() |
RID list processing failed - no storage | ![]() |
NUMC |
417 | ![]() |
Number of OPEN CURSOR statements executed | ![]() |
NUMC |
418 | ![]() |
Number of PREPARE statements executed | ![]() |
NUMC |
419 | ![]() |
Number of RELEASE statements executed | ![]() |
NUMC |
420 | ![]() |
Total Number of Times Reoptimization Occurs | ![]() |
NUMC |
421 | ![]() |
Parallel groups with reformulated access path (Sysplex conf) | ![]() |
NUMC |
422 | ![]() |
Parallel groups with reformulated access path (buffer pool) | ![]() |
NUMC |
423 | ![]() |
Number of REVOKE statements executed | ![]() |
NUMC |
424 | ![]() |
Direct row access attempted, but reverted to using index | ![]() |
NUMC |
425 | ![]() |
Number of times DB2 used dir. row access to locate a record | ![]() |
NUMC |
426 | ![]() |
Direct row access attempted, reverted to tablespace scan | ![]() |
NUMC |
427 | ![]() |
Number of times a row trigger is activated | ![]() |
NUMC |
428 | ![]() |
Number of SELECT statements executed | ![]() |
NUMC |
429 | ![]() |
Number of SET CURRENT DEGREE statements executed | ![]() |
NUMC |
430 | ![]() |
Number of SET CONNECTION statements executed | ![]() |
NUMC |
431 | ![]() |
Number of SET CURRENT RULES statements executed | ![]() |
NUMC |
432 | ![]() |
Number of SET HOST VARIABLE statements executed | ![]() |
NUMC |
433 | ![]() |
Number of SQL SET CURRENT PATH statements | ![]() |
NUMC |
434 | ![]() |
Number of SET CURRENT SQLID statements executed | ![]() |
NUMC |
435 | ![]() |
MAXKEEPD parameter exceeded | ![]() |
NUMC |
436 | ![]() |
Number of Times that DB2 Found the Statement in the Cache | ![]() |
NUMC |
437 | ![]() |
Statement invalidated | ![]() |
NUMC |
438 | ![]() |
Number of implicit prepares | ![]() |
NUMC |
439 | ![]() |
Maximum storage used for LOB values (MB) | ![]() |
NUMC |
440 | ![]() |
Number of times statement could not be found in cache | ![]() |
NUMC |
441 | ![]() |
Number of avoided prepares | ![]() |
NUMC |
442 | ![]() |
Number of times a statement trigger is activated | ![]() |
NUMC |
443 | ![]() |
No. of times an SQL error occurred during a triggered action | ![]() |
NUMC |
444 | ![]() |
Number of UPDATE statements executed | ![]() |
NUMC |
445 | ![]() |
Actual DASD usage (in KB) of dataset | INT4 | |
446 | ![]() |
Actual DASD usage (in KB) of TS (sum of partitions) | ![]() |
FLTP |
447 | ![]() |
Field type date, YYYYMMDD | ![]() |
DATS |
448 | ![]() |
Date and time of index size analysis (YYYYMMDDhhmm) | ![]() |
CHAR |
449 | ![]() |
Date and time of size analysis (format: YYYYMMDDhhmm) | ![]() |
CHAR |
450 | ![]() |
DB2 for OS/390: Short form of timestamp (YYYYMMDDhhmmss) | ![]() |
CHAR |
451 | ![]() |
Number of days since last invocation | ![]() |
INT4 |
452 | ![]() |
cardf | DEC | |
453 | ![]() |
Date of last refresh of transaction DB02 | ![]() |
DATS |
454 | ![]() |
Time of the last refresh of transaction DB02 | ![]() |
TIMS |
455 | ![]() |
DBID | ![]() |
INT2 |
456 | ![]() |
DBID | ![]() |
INT4 |
457 | ![]() |
Name of database | ![]() |
CHAR |
458 | ![]() |
Database name | ![]() |
CHAR |
459 | ![]() |
DB2 DB Name | CHAR | |
460 | ![]() |
The name of the DB2 database | ![]() |
CHAR |
461 | ![]() |
The name of the DB2 database | ![]() |
CHAR |
462 | ![]() |
CASTOUT attribute | ![]() |
CHAR |
463 | ![]() |
The deferred write threshold for the virtual buffer pool | ![]() |
INT4 |
464 | ![]() |
The sequential steal threshold for the hiperpool | INT4 | |
465 | ![]() |
The size of the hiperpool | INT4 | |
466 | ![]() |
Name of buffer pool | ![]() |
CHAR |
467 | ![]() |
Page stealing algorithm to be used for the virtual BP | ![]() |
CHAR |
468 | ![]() |
Parallel I/O sequential steal threshold for virtual BP | ![]() |
INT4 |
469 | ![]() |
Pool vertical write threshold in number of buffers | ![]() |
INT2 |
470 | ![]() |
Pool vertical write threshold in number of buffers | NUMC | |
471 | ![]() |
The vertical deferred write threshold for the virtual BP | INT4 | |
472 | ![]() |
The sequential steal threshold for the virtual buffer pool | ![]() |
INT4 |
473 | ![]() |
The size of the virtual buffer pool | INT4 | |
474 | ![]() |
Type of virtual buffer pool | ![]() |
CHAR |
475 | ![]() |
The size of the virtual buffer pool | INT4 | |
476 | ![]() |
Assisting parallel sequential threshold | ![]() |
INT4 |
477 | ![]() |
Status IFI DB Trace | ![]() |
INT4 |
478 | ![]() |
Length of IFI DB Status Text | ![]() |
INT2 |
479 | ![]() |
Status of IFI DB Trace | ![]() |
CHAR |
480 | ![]() |
Used for Saving content of Special Register Current Server | CHAR | |
481 | ![]() |
SRB time for DDF address space | ![]() |
CHAR |
482 | ![]() |
TCB time for DDF address space | ![]() |
CHAR |
483 | ![]() |
Total time for DDF address space | ![]() |
CHAR |
484 | ![]() |
Field Type DEC, Length 10 | ![]() |
DEC |
485 | ![]() |
Field Type DEC, Length 10 | ![]() |
DEC |
486 | ![]() |
dec 19 with sign | ![]() |
DEC |
487 | ![]() |
decision (including yes/no/no matter what) | ![]() |
CHAR |
488 | ![]() |
DB2 for OS/390: Number of deleted database | ![]() |
NUMC |
489 | ![]() |
IFI DB Trace: Description | ![]() |
CHAR |
490 | ![]() |
(field) description | CHAR | |
491 | ![]() |
(field) long description | CHAR | |
492 | ![]() |
(field) description | CHAR | |
493 | ![]() |
The program name (package ID or DBRM name) | ![]() |
CHAR |
494 | ![]() |
Dataset allocated to the SYSDISC DDNAME | ![]() |
CHAR |
495 | ![]() |
Primary space allocation for the SYSDISC dataset (cyl.) | ![]() |
INT2 |
496 | ![]() |
Device on which the SYSDISC dataset resides | ![]() |
CHAR |
497 | ![]() |
SRB time for IRLM | ![]() |
CHAR |
498 | ![]() |
Precompiler statement number | ![]() |
NUMC |
499 | ![]() |
Precompiler statement number | ![]() |
INT2 |
500 | ![]() |
TCB time for IRLM | ![]() |
CHAR |