SAP ABAP Data Element - Index D, page 9
Data Element - D
# | Data Element | Short Description | Domain | Data Type |
---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
1 | ![]() |
Resource limit facility automatic start | ![]() |
CHAR |
2 | ![]() |
Authorization ID of the resource limit specification table | ![]() |
CHAR |
3 | ![]() |
Resource limit specification table error action | CHAR | |
4 | ![]() |
FLAGS (ONE BYTE, USED AS BITS 1-8) | ![]() |
RAW |
5 | ![]() |
Resource limit specification table ID | ![]() |
CHAR |
6 | ![]() |
Maximum number of database access threads | ![]() |
INT2 |
7 | ![]() |
Extended security | ![]() |
CHAR |
8 | ![]() |
The SMF ACCOUNTING TRACE Classes Started | ![]() |
CHAR |
9 | ![]() |
The SMF STATISTICS TRACE Classes Started | ![]() |
CHAR |
10 | ![]() |
The individual write-to-operator routing codes started | CHAR | |
11 | ![]() |
Number of abends allowed for a stored procedure | ![]() |
INT2 |
12 | ![]() |
Name of JCL procedure used to start DB2 address space | ![]() |
CHAR |
13 | ![]() |
Stored procedure timeout value | ![]() |
INT2 |
14 | ![]() |
Time interval (in minutes) between statistics collection | ![]() |
INT2 |
15 | ![]() |
Statistics synchronization | ![]() |
CHAR |
16 | ![]() |
Default buffer pool for 4 KB tablespaces | ![]() |
CHAR |
17 | ![]() |
Installation parameter statistics time | ![]() |
NUMC |
18 | ![]() |
Size of the Local Trace Tables in Multiples of 4 KB | ![]() |
INT2 |
19 | ![]() |
Pseudo-close time | ![]() |
INT2 |
20 | ![]() |
The GLOBAL TRACE Classes Started | ![]() |
CHAR |
21 | ![]() |
Size of resident trace table (multiple of 4K) | ![]() |
INT2 |
22 | ![]() |
UR Checkpoint Frequency | ![]() |
INT2 |
23 | ![]() |
Default WLM environment for user-defined functions/stoprocs | ![]() |
CHAR |
24 | ![]() |
The number of archive log copies | ![]() |
CHAR |
25 | ![]() |
Maximum number of archive log datasets | ![]() |
INT4 |
26 | ![]() |
The Number of Archive Log Copies | ![]() |
CHAR |
27 | ![]() |
Maximum number of archive log datasets | ![]() |
NUMC |
28 | ![]() |
Number of Active Log Copies | ![]() |
CHAR |
29 | ![]() |
Log input buffer pool size (in kilobytes) | ![]() |
NUMC |
30 | ![]() |
Maximum number of tape units for archive read | ![]() |
NUMC |
31 | ![]() |
Log Output Buffer Pool Size (MB) | ![]() |
NUMC |
32 | ![]() |
Active log and BSDS initialization options | ![]() |
CHAR |
33 | ![]() |
Write threshold on filled buffers | ![]() |
NUMC |
34 | ![]() |
Tape volume deallocation period | CHAR | |
35 | ![]() |
Number of active log copies | ![]() |
CHAR |
36 | ![]() |
Log input buffer pool size (in kilobytes) | ![]() |
INT4 |
37 | ![]() |
Maximum number of tape units for archive read | ![]() |
INT2 |
38 | ![]() |
Log Output Buffer Pool Size (MB) | ![]() |
INT4 |
39 | ![]() |
Active log and BSDS initialization options | ![]() |
CHAR |
40 | ![]() |
Write threshold on filled buffers | ![]() |
INT2 |
41 | ![]() |
The unit used in allocating archive datasets | ![]() |
CHAR |
42 | ![]() |
The block size of the archive log data sets | ![]() |
INT4 |
43 | ![]() |
The unit used in allocating archive data sets | ![]() |
CHAR |
44 | ![]() |
The block size of the archive log data sets | ![]() |
NUMC |
45 | ![]() |
Force Data Compaction | ![]() |
CHAR |
46 | ![]() |
Whether the archive datasets are cataloged in the IFC | CHAR | |
47 | ![]() |
Indicates whether a timestamp is inserted in log datasets | ![]() |
CHAR |
48 | ![]() |
Maximum time for DB2 to attempt a full system quiesce | ![]() |
NUMC |
49 | ![]() |
Archive copy 2 mass storage group name | ![]() |
CHAR |
50 | ![]() |
Archive copy 1 mass storage group name | ![]() |
CHAR |
51 | ![]() |
Force data compaction | ![]() |
CHAR |
52 | ![]() |
DSN prefix character string for copy-1 archive log data set | ![]() |
CHAR |
53 | ![]() |
DSN prefix character string for copy-2 archive log data set | ![]() |
CHAR |
54 | ![]() |
Number of days the archive log data sets are to be retained | ![]() |
NUMC |
55 | ![]() |
Primary space allocation | ![]() |
NUMC |
56 | ![]() |
Archive Logs RACF Protection | ![]() |
CHAR |
57 | ![]() |
Secondary space allocation | ![]() |
NUMC |
58 | ![]() |
Whether the archive datasets are cataloged in the IFC | CHAR | |
59 | ![]() |
The type of device for COPY2 archive logs | ![]() |
CHAR |
60 | ![]() |
Device type to which the archive log sets are written | ![]() |
CHAR |
61 | ![]() |
The type of device for COPY1 archive logs | ![]() |
CHAR |
62 | ![]() |
Issue WTOR Before Archive Mounts | ![]() |
CHAR |
63 | ![]() |
Extended timestamp indicator | ![]() |
CHAR |
64 | ![]() |
Indicates whether a timestamp is inserted in log datasets | ![]() |
CHAR |
65 | ![]() |
Max. time permitted for DB2 to attempt a full system quiesce | ![]() |
NUMC |
66 | ![]() |
Maximum time for DB2 to attempt a full system quiesce | ![]() |
INT2 |
67 | ![]() |
Mass storage system volume group 1 name | ![]() |
CHAR |
68 | ![]() |
Mass storage system volume group 2 name | ![]() |
CHAR |
69 | ![]() |
DSN prefix character string for copy-1 archive log dataset | ![]() |
CHAR |
70 | ![]() |
DSN prefix character string for copy-2 archive log dataset | ![]() |
CHAR |
71 | ![]() |
Number of days the archive log data sets are to be retained | ![]() |
INT2 |
72 | ![]() |
Primary space allocation | ![]() |
INT4 |
73 | ![]() |
Archive logs RACF protection | ![]() |
CHAR |
74 | ![]() |
Secondary space allocation | ![]() |
INT4 |
75 | ![]() |
Device type to which the archive log sets are written | ![]() |
CHAR |
76 | ![]() |
The type of device for COPY1 archive logs | ![]() |
CHAR |
77 | ![]() |
The type of device for COPY2 archive logs | ![]() |
CHAR |
78 | ![]() |
Issue WTOR before archive mounts | ![]() |
CHAR |
79 | ![]() |
Indicates whether autobind operations are allowed | ![]() |
CHAR |
80 | ![]() |
Whether explain is allowed during autobind | ![]() |
CHAR |
81 | ![]() |
The authorization ID of the system administrator 2 | ![]() |
CHAR |
82 | ![]() |
Indicates the size of the authorization cache | ![]() |
NUMC |
83 | ![]() |
DB2 authorization | ![]() |
CHAR |
84 | ![]() |
Indicates the authorities required to add a new package | ![]() |
CHAR |
85 | ![]() |
Cache prepared dynamic SQL statements | ![]() |
CHAR |
86 | ![]() |
Whether change data capture is enabled | ![]() |
CHAR |
87 | ![]() |
Default parallelism degree | ![]() |
CHAR |
88 | ![]() |
Cache prepared dynamic SQL statements | ![]() |
CHAR |
89 | ![]() |
Storage contraction | ![]() |
CHAR |
90 | ![]() |
Whether a DB2 subsystem can be a parallelism coordinator | ![]() |
CHAR |
91 | ![]() |
Storage Contraction Threshold (Commits) | ![]() |
INT2 |
92 | ![]() |
SMS Dataclass for tablespaces | ![]() |
CHAR |
93 | ![]() |
SMS Dataclass for indexspaces | ![]() |
CHAR |
94 | ![]() |
Asynchronous drain start | ![]() |
INT2 |
95 | ![]() |
The authorization ID of the system default user | ![]() |
CHAR |
96 | ![]() |
Minimum divide scale | ![]() |
CHAR |
97 | ![]() |
Maximum number of concurrently open datasets | ![]() |
NUMC |
98 | ![]() |
Maximum locks per table(space) before escalation | ![]() |
INT2 |
99 | ![]() |
If an SQLDA for describe is built during bind for static SQL | ![]() |
CHAR |
100 | ![]() |
Default index type | ![]() |
NUMC |
101 | ![]() |
Always use EDM Best Fit Algorithm | ![]() |
CHAR |
102 | ![]() |
EDM Pool Data Space Size (MB) | ![]() |
INT4 |
103 | ![]() |
DB2 for OS/390: EDM Pool Algorithm | ![]() |
CHAR |
104 | ![]() |
Max EDM Pool data space size (MB) | ![]() |
INT4 |
105 | ![]() |
Maximum Size of the EDM Pool (MB) | ![]() |
INT4 |
106 | ![]() |
Whether DPROP is supported | ![]() |
CHAR |
107 | ![]() |
The data definition escape character for ART and ORT search | ![]() |
CHAR |
108 | ![]() |
Max. log buffer size per job for fast log apply (10^6 bytes) | ![]() |
NUMC |
109 | ![]() |
Maximum number of tasks per job for fast log apply | ![]() |
NUMC |
110 | ![]() |
Whether access path hints are allowed | ![]() |
CHAR |
111 | ![]() |
Hop site authorization | ![]() |
CHAR |
112 | ![]() |
Indicates whether IRLM is started automatically by DB2 | ![]() |
CHAR |
113 | ![]() |
Autostart of IRLM | ![]() |
CHAR |
114 | ![]() |
Real-time statistics interval | ![]() |
INT4 |
115 | ![]() |
Name of IRLM procedure which DB2 uses to start IRLM | ![]() |
CHAR |
116 | ![]() |
Name of the IRLM subsystem by which IRLM is known to MVS | ![]() |
CHAR |
117 | ![]() |
Seconds DB2 will wait for IRLM start | ![]() |
INT4 |
118 | ![]() |
Max. no. of language environment tokens active at any time | ![]() |
INT2 |
119 | ![]() |
Maximum number of locks per tablespace | ![]() |
INT4 |
120 | ![]() |
Maximum number of locks per user | ![]() |
INT4 |
121 | ![]() |
Asynchronous drain stop | ![]() |
INT2 |
122 | ![]() |
Upper limit on the degree of parallelism | ![]() |
INT4 |
123 | ![]() |
Maximum number of prepared dynamic statements | ![]() |
INT4 |
124 | ![]() |
Maximum joined tables | ![]() |
INT4 |
125 | ![]() |
Active log disabled | ![]() |
CHAR |
126 | ![]() |
NPAGES threshold for index scan | ![]() |
INT4 |
127 | ![]() |
Outer join performance enhancement | ![]() |
CHAR |
128 | ![]() |
The authorization ID of the system operator 1 | ![]() |
CHAR |
129 | ![]() |
The authorization ID of the system operator 2 | ![]() |
CHAR |
130 | ![]() |
Optimizer index prefetch enhancement | ![]() |
CHAR |
131 | ![]() |
Package authorization cache | ![]() |
INT4 |
132 | ![]() |
Allow partitioning key update | ![]() |
CHAR |
133 | ![]() |
Utility cache option | ![]() |
CHAR |
134 | ![]() |
Routine authorization cache size | ![]() |
INT4 |
135 | ![]() |
If page or row locks for held cursors are released at commit | ![]() |
CHAR |
136 | ![]() |
Name of the application registration table | ![]() |
CHAR |
137 | ![]() |
Owner of the application registration table | ![]() |
CHAR |
138 | ![]() |
Whether only registered packages or plans can use DDL | ![]() |
CHAR |
139 | ![]() |
Whether data definition control support is to be used | ![]() |
CHAR |
140 | ![]() |
Name of the database containing the registration tables | ![]() |
CHAR |
141 | ![]() |
The name of the object registration table | ![]() |
CHAR |
142 | ![]() |
Whether two-part names are required for objects reg. in ORT | ![]() |
CHAR |
143 | ![]() |
Unregistered DDL default | ![]() |
CHAR |
144 | ![]() |
The name of the object registration table | ![]() |
CHAR |
145 | ![]() |
Maximum size of RID pool in the DB2 subsystem | ![]() |
NUMC |
146 | ![]() |
UPDATE lock for repeatable read or read stability | ![]() |
CHAR |
147 | ![]() |
REVOKE dependent privileges | CHAR | |
148 | ![]() |
The authorization ID of the system administrator 1 | ![]() |
CHAR |
149 | ![]() |
Sequential mode to read cached data from a 3990 controller | CHAR | |
150 | ![]() |
Security Admin 1 | CHAR | |
151 | ![]() |
Security Administrator 1 Type | CHAR | |
152 | ![]() |
Security Admin 2 | CHAR | |
153 | ![]() |
Security Administrator 2 Type | CHAR | |
154 | ![]() |
Separate security duties | CHAR | |
155 | ![]() |
Indicates whether the site is local or remote | ![]() |
CHAR |
156 | ![]() |
DB2 for OS/390: Star Join controls | CHAR | |
157 | ![]() |
DB2 for OS/390: Star Join controls | CHAR | |
158 | ![]() |
Minimum star join tables | ![]() |
INT4 |
159 | ![]() |
Maximum Size of the Sort Pool (MB) | ![]() |
INT4 |
160 | ![]() |
Storage Contraction Threshold (MB) | ![]() |
INT4 |
161 | ![]() |
Statistics history default | ![]() |
CHAR |
162 | ![]() |
Statistics rollup default | ![]() |
CHAR |
163 | ![]() |
Asynchronous drain start | ![]() |
NUMC |
164 | ![]() |
Maximum time DB2 waits for the release of a locked resource | ![]() |
INT4 |
165 | ![]() |
Agent local pool extension size (bytes) | ![]() |
NUMC |
166 | ![]() |
Maximum degree of utility parallelism | ![]() |
INT2 |
167 | ![]() |
REORG FASTSWITCH | ![]() |
CHAR |
168 | ![]() |
Utility timeout factor | ![]() |
INT2 |
169 | ![]() |
VARCHAR from index | ![]() |
CHAR |
170 | ![]() |
Evaluate uncommitted | ![]() |
CHAR |
171 | ![]() |
Multiplier for Determining Retained Lock Timeout | ![]() |
INT2 |
172 | ![]() |
Flag if X lock is used for searched update or delete | ![]() |
CHAR |
173 | ![]() |
Whether X lock is used for searched update or delete | ![]() |
CHAR |
174 | ![]() |
Deadlock cycle | ![]() |
INT2 |
175 | ![]() |
Deadlock time (seconds) | ![]() |
INT2 |
176 | ![]() |
![]() |
INT4 | |
177 | ![]() |
IRLM cross memory enabled | ![]() |
CHAR |
178 | ![]() |
Actual resource timeout | ![]() |
INT4 |
179 | ![]() |
High qualifier name for all DB2 system datasets | ![]() |
CHAR |
180 | ![]() |
Start database indicator | ![]() |
CHAR |
181 | ![]() |
Name of database to be automatically started | ![]() |
CHAR |
182 | ![]() |
Tablespace name or indexspace name | ![]() |
CHAR |
183 | ![]() |
Status of a DBAT | ![]() |
CHAR |
184 | ![]() |
Maximum type 1 inactive threads allowed by DB2 | ![]() |
INT4 |
185 | ![]() |
Resource limit facility error parameter | ![]() |
CHAR |
186 | ![]() |
Specifies the Limit in CPU Time Service Units | ![]() |
INT4 |
187 | ![]() |
Number of minutes between two resynchronization intervals | ![]() |
INT2 |
188 | ![]() |
The startup option for the distributed data facility (DDF) | ![]() |
CHAR |
189 | ![]() |
Whether verified conn. are accepted from TCP/IP clients | ![]() |
CHAR |
190 | ![]() |
Idle thread timeout | ![]() |
INT2 |
191 | ![]() |
Indicates whether this DB2 can assist parallel processing | ![]() |
CHAR |
192 | ![]() |
Whether a DB2 subsystem can be a parallelism coordinator | ![]() |
CHAR |
193 | ![]() |
Name of a DB2 data sharing group | ![]() |
CHAR |
194 | ![]() |
Immediate writes for GBPs | ![]() |
CHAR |
195 | ![]() |
Whether data sharing function is used or not | ![]() |
CHAR |
196 | ![]() |
Maximum Number of Members | ![]() |
INT4 |
197 | ![]() |
Name of a new or existing DB2 data sharing member | ![]() |
CHAR |
198 | ![]() |
Application encoding scheme | ![]() |
CHAR |
199 | ![]() |
CPU Service Unit Conversion Factor | ![]() |
INT4 |
200 | ![]() |
ASCII GBCS CCSID | ![]() |
INT4 |
201 | ![]() |
The ASCII mixed coded character set ID | INT4 | |
202 | ![]() |
Indicates the rules of precision for a decimal field | ![]() |
CHAR |
203 | ![]() |
The ASCII single-byte coded character set ID | INT4 | |
204 | ![]() |
The default character set, which can be ALPHANUM or KATAKANA | ![]() |
CHAR |
205 | ![]() |
The default output format for dates | ![]() |
CHAR |
206 | ![]() |
Whether the decimal contains a comma (,) or a period (.) | ![]() |
CHAR |
207 | ![]() |
Default delimiter | ![]() |
CHAR |
208 | ![]() |
Local date length | ![]() |
INT2 |
209 | ![]() |
Whether DSNHDECP values are used for dynamic SQL statements | ![]() |
CHAR |
210 | ![]() |
Distributed SQL string delimiter | ![]() |
CHAR |
211 | ![]() |
The default encoding scheme, which can be ASCII or EBCDIC. | ![]() |
CHAR |
212 | ![]() |
The EBCDIC graphic coded character set ID | INT4 | |
213 | ![]() |
Default mixed graphic | ![]() |
CHAR |
214 | ![]() |
The default programming language for your site | ![]() |
CHAR |
215 | ![]() |
Default locale LC_CTYPE | ![]() |
CHAR |
216 | ![]() |
The EBCDIC mixed coded character set ID | INT4 | |
217 | ![]() |
The string delimiter for SQL | ![]() |
CHAR |
218 | ![]() |
The EBCDIC single-byte coded character set ID | INT4 | |
219 | ![]() |
SQL language support level | ![]() |
CHAR |
220 | ![]() |
The default output format for times | ![]() |
CHAR |
221 | ![]() |
Local time length | ![]() |
INT2 |
222 | ![]() |
Work process ID | ![]() |
NUMC |
223 | ![]() |
Work process number | ![]() |
NUMC |
224 | ![]() |
Corresponding R/3 work process type | ![]() |
CHAR |
225 | ![]() |
Number of service class periods | ![]() |
INT2 |
226 | ![]() |
Work process ID | ![]() |
NUMC |
227 | ![]() |
Work process ID | ![]() |
CHAR |
228 | ![]() |
Work process ID | ![]() |
CHAR |
229 | ![]() |
Performance index | ![]() |
CHAR |
230 | ![]() |
Thread Storage Algorithm | ![]() |
CHAR |
231 | ![]() |
Work process number | ![]() |
NUMC |
232 | ![]() |
Adminitrator name | ![]() |
CHAR |
233 | ![]() |
Service policy description | ![]() |
CHAR |
234 | ![]() |
Policy name | ![]() |
CHAR |
235 | ![]() |
Corresponding R/3 work process type | ![]() |
CHAR |
236 | ![]() |
work process type | CHAR | |
237 | ![]() |
SQL TEXT | ![]() |
LCHR |
238 | ![]() |
Total 64-bit shared variable pool storage | ![]() |
DEC |
239 | ![]() |
Average response time | ![]() |
CHAR |
240 | ![]() |
Resource group name | ![]() |
CHAR |
241 | ![]() |
Write rate = ( Synchronous + async. writes ) / interval | ![]() |
DEC |
242 | ![]() |
Address space ID (ASID) of the address space | ![]() |
NUMC |
243 | ![]() |
Accumulated job step timer (TCB) value for address space | ![]() |
CHAR |
244 | ![]() |
Address space | ![]() |
CHAR |
245 | ![]() |
Accumulated SRB timer value for address space | ![]() |
CHAR |
246 | ![]() |
Service class description | ![]() |
CHAR |
247 | ![]() |
Service class name | ![]() |
CHAR |
248 | ![]() |
Number of checkpoints DB2 has taken since startup | ![]() |
INT4 |
249 | ![]() |
Count of IFI abends | ![]() |
NUMC |
250 | ![]() |
Count of IFI command requests | ![]() |
NUMC |
251 | ![]() |
Count of IFI READA requests | ![]() |
NUMC |
252 | ![]() |
Count of IFI READS requests | ![]() |
NUMC |
253 | ![]() |
Count of IFI unrecognized functions. | ![]() |
NUMC |
254 | ![]() |
Count of IFI WRITE requests | ![]() |
NUMC |
255 | ![]() |
Service class period duration | ![]() |
INT4 |
256 | ![]() |
Subsystem type | ![]() |
CHAR |
257 | ![]() |
System name | ![]() |
CHAR |
258 | ![]() |
Start or end time | ![]() |
TIMS |
259 | ![]() |
Transaction program name | ![]() |
CHAR |
260 | ![]() |
User ID | ![]() |
CHAR |
261 | ![]() |
Using samples | ![]() |
INT4 |
262 | ![]() |
Velocity | ![]() |
CHAR |
263 | ![]() |
Workload name | ![]() |
CHAR |
264 | ![]() |
Number of ALTER DATABASE statements executed | ![]() |
DEC |
265 | ![]() |
# of ALLOCATE CURSOR statements executed | ![]() |
DEC |
266 | ![]() |
# of ASSOCIATE LOCATOR statements executed | ![]() |
DEC |
267 | ![]() |
Number of ALTER PROCEDURE statements | ![]() |
DEC |
268 | ![]() |
alter trusted context | ![]() |
DEC |
269 | ![]() |
Number of ALTER INDEX statements executed | ![]() |
DEC |
270 | ![]() |
alter jar | ![]() |
DEC |
271 | ![]() |
Number of ALTER STORAGE GROUP statements executed | ![]() |
DEC |
272 | ![]() |
Number of ALTER TABLE statements executed | ![]() |
DEC |
273 | ![]() |
Number of ALTER TABLE SPACE statements executed | ![]() |
DEC |
274 | ![]() |
Number of ALTER FUNCTION statements | ![]() |
DEC |
275 | ![]() |
Number of SQL CALL statements executed | ![]() |
DEC |
276 | ![]() |
# of times a stored procedure ABENDed | ![]() |
DEC |
277 | ![]() |
# of times an SQL CALL statement was rejected | ![]() |
DEC |
278 | ![]() |
# of times an SQL CALL stmt timedout waiting to be scheduled | ![]() |
DEC |
279 | ![]() |
Maximum level of nested SQL cascading | ![]() |
DEC |
280 | ![]() |
Number of user-defined functions executed | ![]() |
DEC |
281 | ![]() |
Number of times a user-defined function abended | ![]() |
DEC |
282 | ![]() |
Number of times a user-defined function was rejected | ![]() |
DEC |
283 | ![]() |
No. of times a user-defined funct. timed out before sched. | ![]() |
DEC |
284 | ![]() |
Number of CREATE DISTINCT TYPE statements | ![]() |
DEC |
285 | ![]() |
Number of CLOSE CURSOR statements executed | ![]() |
DEC |
286 | ![]() |
Number of COMMENT ON statements executed | ![]() |
DEC |
287 | ![]() |
Number of CONNECT TYPE 1 statements executed | ![]() |
DEC |
288 | ![]() |
Number of CONNECT TYPE 2 statements executed | ![]() |
DEC |
289 | ![]() |
COORDINATOR setting mismatch | ![]() |
DEC |
290 | ![]() |
Number of CREATE ALIAS statements executed | ![]() |
DEC |
291 | ![]() |
Number of CREATE AUXILIARY TABLE statements | ![]() |
DEC |
292 | ![]() |
create trusted context | ![]() |
DEC |
293 | ![]() |
Number of CREATE DATABASE statements executed | ![]() |
DEC |
294 | ![]() |
# OF CREATE GLBL TEMP TABLE | ![]() |
DEC |
295 | ![]() |
Number of CREATE INDEX statements executed | ![]() |
DEC |
296 | ![]() |
Number of CREATE PROCEDURE statements | ![]() |
DEC |
297 | ![]() |
create role | ![]() |
DEC |
298 | ![]() |
Number of CREATE STORAGE GROUP statements executed | ![]() |
DEC |
299 | ![]() |
Number of CREATE SYNONYM statements executed | ![]() |
DEC |
300 | ![]() |
Number of CREATE TABLE statements executed | ![]() |
DEC |
301 | ![]() |
Number of CREATE FUNCTION statements | ![]() |
DEC |
302 | ![]() |
Number of CREATE TABLE SPACE statements executed | ![]() |
DEC |
303 | ![]() |
Number of SQL CREATE TRIGGER statements | ![]() |
DEC |
304 | ![]() |
Number of DROP DISTINCT TYPE statements | ![]() |
DEC |
305 | ![]() |
Number of CREATE VIEW statements executed | ![]() |
DEC |
306 | ![]() |
Parallel groups fell to sequential due to storage shortage | ![]() |
DEC |
307 | ![]() |
Parallel groups fell to sequential due to updatable cursor | ![]() |
DEC |
308 | ![]() |
Par.groups fell to sequ. due to unavailable enclave services | ![]() |
DEC |
309 | ![]() |
Par. groups fell to sequ. due to lack of ESA sort support | ![]() |
DEC |
310 | ![]() |
Number of DELETE statements executed | ![]() |
DEC |
311 | ![]() |
Number of DESCRIBE statements executed | ![]() |
DEC |
312 | ![]() |
Number of DROP ALIAS statements executed | ![]() |
DEC |
313 | ![]() |
drop trusted context | ![]() |
DEC |
314 | ![]() |
Number of DROP DATABASE statements executed | ![]() |
DEC |
315 | ![]() |
Number of DROP UDF statements | ![]() |
DEC |
316 | ![]() |
Number of DROP INDEX statements executed | ![]() |
DEC |
317 | ![]() |
Number of DROP PACKAGE statements executed | ![]() |
DEC |
318 | ![]() |
Number of DROP PROCEDURE statements | ![]() |
DEC |
319 | ![]() |
drop role | ![]() |
DEC |
320 | ![]() |
Number of DROP STORAGE GROUP statements executed | ![]() |
DEC |
321 | ![]() |
Number of DROP SYNONYM statements executed | ![]() |
DEC |
322 | ![]() |
Number of DROP TABLE statements executed | ![]() |
DEC |
323 | ![]() |
Number of SQL DROP TRIGGER statements | ![]() |
DEC |
324 | ![]() |
Number of DROP TABLE SPACE statements executed | ![]() |
DEC |
325 | ![]() |
Number of DROP VIEW statements executed | ![]() |
DEC |
326 | ![]() |
Number of DESCRIBE TABLE statements executed | ![]() |
DEC |
327 | ![]() |
Number of FETCH statements executed | ![]() |
DEC |
328 | ![]() |
Number of FREE LOCATOR statements | ![]() |
DEC |
329 | ![]() |
Number of GRANT statements executed | ![]() |
DEC |
330 | ![]() |
Number of HOLD LOCATOR statements | ![]() |
DEC |
331 | ![]() |
Number of INCREMENTAL BINDs executed | ![]() |
DEC |
332 | ![]() |
Number of INSERT statements executed | ![]() |
DEC |
333 | ![]() |
Isolation level RR or RS | ![]() |
DEC |
334 | ![]() |
Number of LABEL ON statements executed | ![]() |
DEC |
335 | ![]() |
Number of LOCK TABLE statements executed | ![]() |
DEC |
336 | ![]() |
Maximum parallelism degree | ![]() |
DEC |
337 | ![]() |
# of times merge sql statement was executed | ![]() |
DEC |
338 | ![]() |
Number of extents before last ALTER SECQTY | INT4 | |
339 | ![]() |
Number of extents before last ALTER SECQTY | ![]() |
INT2 |
340 | ![]() |
Number of times RID list processing is used | ![]() |
DEC |
341 | ![]() |
Date of last ALTER INDEX|TABLESPACE SECQTY | ![]() |
DATS |
342 | ![]() |
First part of name qualifiying the object that got ext.alert | ![]() |
CHAR |
343 | ![]() |
Sec. part of name qualifiying the object that got ext. alert | ![]() |
CHAR |
344 | ![]() |
RID list processing failed - limit exeeded | ![]() |
DEC |
345 | ![]() |
Severity of an extent alert | ![]() |
NUMC |
346 | ![]() |
Type of object that got an extent alert | ![]() |
CHAR |
347 | ![]() |
Parallel groups: executed as planned | ![]() |
DEC |
348 | ![]() |
RID list processing failed - no storage | ![]() |
DEC |
349 | ![]() |
Number of OPEN CURSOR statements executed | ![]() |
DEC |
350 | ![]() |
Number of PREPARE statements executed | ![]() |
DEC |
351 | ![]() |
Parallel groups: executed with reduced degree | ![]() |
DEC |
352 | ![]() |
Number of RELEASE statements executed | ![]() |
DEC |
353 | ![]() |
Total Number of Times Reoptimization Occurs | ![]() |
DEC |
354 | ![]() |
Parallel groups with reformulated access path (Sysplex conf) | ![]() |
DEC |
355 | ![]() |
Parallel groups with reformulated access path (buffer pool) | ![]() |
DEC |
356 | ![]() |
Number of REVOKE statements executed | ![]() |
DEC |
357 | ![]() |
rename index | ![]() |
DEC |
358 | ![]() |
RENAME TABLE | ![]() |
DEC |
359 | ![]() |
Direct row access attempted, but reverted to using index | ![]() |
DEC |
360 | ![]() |
Number of times DB2 used dir. row access to locate a record | ![]() |
DEC |
361 | ![]() |
Direct row access attempted, reverted to tablespace scan | ![]() |
DEC |
362 | ![]() |
Number of times a row trigger is activated | ![]() |
DEC |
363 | ![]() |
Number of SELECT statements executed | ![]() |
DEC |
364 | ![]() |
Number of SET CURRENT DEGREE statements executed | ![]() |
DEC |
365 | ![]() |
Number of SET CONNECTION statements executed | ![]() |
DEC |
366 | ![]() |
Number of SET CURRENT RULES statements executed | ![]() |
DEC |
367 | ![]() |
Number of SET HOST VARIABLE statements executed | ![]() |
DEC |
368 | ![]() |
Number of SQL SET CURRENT PATH statements | ![]() |
DEC |
369 | ![]() |
Number of SET CURRENT SQLID statements executed | ![]() |
DEC |
370 | ![]() |
MAXKEEPD parameter exceeded | ![]() |
DEC |
371 | ![]() |
Number of Times that DB2 Found the Statement in the Cache | ![]() |
DEC |
372 | ![]() |
Statement invalidated | ![]() |
DEC |
373 | ![]() |
Number of implicit prepares | ![]() |
DEC |
374 | ![]() |
Maximum storage used for LOB values (MB) | ![]() |
DEC |
375 | ![]() |
Number of times statement could not be found in cache | ![]() |
DEC |
376 | ![]() |
Number of avoided prepares | ![]() |
DEC |
377 | ![]() |
Number of times a statement trigger is activated | ![]() |
DEC |
378 | ![]() |
Parallel groups: total executed | ![]() |
DEC |
379 | ![]() |
No. of times an SQL error occurred during a triggered action | ![]() |
DEC |
380 | ![]() |
# of times truncate table stmt was exec. | ![]() |
DEC |
381 | ![]() |
Number of UPDATE statements executed | ![]() |
DEC |
382 | ![]() |
Average synchronous I/Os | ![]() |
DEC |
383 | ![]() |
Parallel groups: intended to run across data sharing group | ![]() |
DEC |
384 | ![]() |
Member bypasses due to storage shortage | ![]() |
DEC |
385 | ![]() |
Yes / NO Flag | CHAR | |
386 | ![]() |
DB2 ZPARM | CHAR | |
387 | ![]() |
ZPARM Value | CHAR | |
388 | ![]() |
Transaction name of caller of DSNACCOR / DSNACCOX | CHAR | |
389 | ![]() |
Line | ![]() |
CHAR |
390 | ![]() |
Name of application server belonging to a certain group | ![]() |
CHAR |
391 | ![]() |
Connection identifier | ![]() |
CHAR |
392 | ![]() |
Name of the connection | ![]() |
CHAR |
393 | ![]() |
host used for ftp | ![]() |
CHAR |
394 | ![]() |
Name of a CONNECT.INI group | ![]() |
CHAR |
395 | ![]() |
host name | ![]() |
CHAR |
396 | ![]() |
Line | ![]() |
CHAR |
397 | ![]() |
location | ![]() |
CHAR |
398 | ![]() |
Logical connection name | ![]() |
CHAR |
399 | ![]() |
member name of a data sharing group | ![]() |
CHAR |
400 | ![]() |
plan name | ![]() |
CHAR |
401 | ![]() |
port | ![]() |
CHAR |
402 | ![]() |
DB2 package set (collection) | ![]() |
CHAR |
403 | ![]() |
retry count for the connection | ![]() |
CHAR |
404 | ![]() |
sleep time before next retry | ![]() |
CHAR |
405 | ![]() |
subsystem id | ![]() |
CHAR |
406 | ![]() |
DB2 Encoding | CHAR | |
407 | ![]() |
Detectionflag for Holders(H) or Waiters(W) for DB2Resources | ![]() |
CHAR |
408 | ![]() |
RMF Host | ![]() |
CHAR |
409 | ![]() |
DB2 Job Profile Value of Variable Name | CHAR | |
410 | ![]() |
DB2 Job Profile Variable Name | CHAR | |
411 | ![]() |
SYSPLEX processor utilization by MVS image | DEC | |
412 | ![]() |
SYSPLEX processor utilization by MVS image | DEC | |
413 | ![]() |
LPAR Total physical utilization by partition | INT4 | |
414 | ![]() |
LPAR delay for processor by MVS image | DEC | |
415 | ![]() |
LPAR no of storage frames | DEC | |
416 | ![]() |
LPAR Start of local data collection | ![]() |
CHAR |
417 | ![]() |
LPAR name | ![]() |
CHAR |
418 | ![]() |
Name of the z/OS image in the LPAR | ![]() |
CHAR |
419 | ![]() |
RMF OS Type and Version | ![]() |
CHAR |
420 | ![]() |
LPAR pagein rate | DEC | |
421 | ![]() |
Subsystem ID of DB2 system | ![]() |
CHAR |
422 | ![]() |
LPAR TCP LPAR name | ![]() |
CHAR |
423 | ![]() |
LPAR Unreferenced Interval Count | DEC | |
424 | ![]() |
LPAR Weight | DEC | |
425 | ![]() |
WLM management enabled | CHAR | |
426 | ![]() |
message field | ![]() |
CHAR |
427 | ![]() |
DB2 message log ID | CHAR | |
428 | ![]() |
DB2 Node Name (RZ20) | ![]() |
CHAR |
429 | ![]() |
Object Type (TS or IX) | CHAR | |
430 | ![]() |
DB2 Partition Number | INT4 | |
431 | ![]() |
RMF Port | NUMC | |
432 | ![]() |
SQL Query Name | ![]() |
CHAR |
433 | ![]() |
SYSPLEX CPU Capacity | INT4 | |
434 | ![]() |
SYSPLEX CPU family | ![]() |
CHAR |
435 | ![]() |
SYSPLEX CPU Type | ![]() |
CHAR |
436 | ![]() |
SYSPLEX Name | CHAR | |
437 | ![]() |
SYSPLEX Number of processors | INT4 | |
438 | ![]() |
SYSPLEX Number of LPARS | INT4 | |
439 | ![]() |
SYSPLEX CPU Serial Number | ![]() |
CHAR |
440 | ![]() |
DB2 Table Profile Date created or updated | DATS | |
441 | ![]() |
DB2 Table Profile Text | STRG | |
442 | ![]() |
DB2 Table Profile Time created or updated | TIMS | |
443 | ![]() |
DB2 Table Profile Type | CHAR | |
444 | ![]() |
iSeries: Analysis Date | DATS | |
445 | ![]() |
iSeries: Avarage Growth (Rows) | DEC | |
446 | ![]() |
iSeries: Avarage Growth (KB) | DEC | |
447 | ![]() |
DB2/400: Exclusion Property of a Boundary Vector | ![]() |
CHAR |
448 | ![]() |
iSeries: Internal (Technical Field) | CHAR | |
449 | ![]() |
iSeries: Value of Profile Parameter as4/dbmon/enable | CHAR | |
450 | ![]() |
DB2/400: Boundary Value of a Single-Dimensional Value Area | ![]() |
CHAR |
451 | ![]() |
iSeries: Delta Rows | DEC | |
452 | ![]() |
iSeries: Delta Size of Table (KB) | DEC | |
453 | ![]() |
Index created as DB2/400 encoded vector index | ![]() |
CHAR |
454 | ![]() |
Number of values for DB2/400 encoded vector index | ![]() |
NUMC |
455 | ![]() |
Hostname | ![]() |
CHAR |
456 | ![]() |
iSeries: Time interval for history dump of database monitor | ![]() |
INT4 |
457 | ![]() |
DB2/400: Partition Property of an Index | ![]() |
CHAR |
458 | ![]() |
DB2/400: Partition Key Column | ![]() |
CHAR |
459 | ![]() |
iSeries: System name of server for DBMon dump execution | ![]() |
CHAR |
460 | ![]() |
DB2/400: NULL Value Sort Below RANGE Partitioning | ![]() |
CHAR |
461 | ![]() |
DB2/400: Number of Partitions of a Table | ![]() |
NUMC |
462 | ![]() |
iSeries: Object Name | ![]() |
CHAR |
463 | ![]() |
DB2/400: Partitioning Properties of a Table | ![]() |
CHAR |
464 | ![]() |
DB2/400: Name of a Table Partition | ![]() |
CHAR |
465 | ![]() |
DB2 UDB for iSeries: Percentage | INT4 | |
466 | ![]() |
DB2 UDB for iSeries: Record Length | INT4 | |
467 | ![]() |
iSeries: Number of Rows in Table | DEC | |
468 | ![]() |
iSeries: Time interval for regular dump and merge of DBMon | ![]() |
INT4 |
469 | ![]() |
Server | ![]() |
CHAR |
470 | ![]() |
Server Name | ![]() |
CHAR |
471 | ![]() |
DB2/400: Partition Property of the Basic Table | ![]() |
CHAR |
472 | ![]() |
iSeries: Object Size in Kbytes | DEC | |
473 | ![]() |
Dummy for DB4TS structure | ![]() |
CHAR |
474 | ![]() |
iSeries: Time unit for database monitor dump time interval | ![]() |
CHAR |
475 | ![]() |
iSeries: Text Field of Length 132 | CHAR | |
476 | ![]() |
DB2 UDB for iSeries: Unused Disk Space | DEC | |
477 | ![]() |
iSeries: Number of rows / object size | ![]() |
DEC |
478 | ![]() |
iSeries: Data Type CHAR(1) (Internal Use) | CHAR | |
479 | ![]() |
iSeries: Change Date | DATS | |
480 | ![]() |
iSeries: Number of available DB monitor history dumps | ![]() |
INT4 |
481 | ![]() |
iSeries: Date of DB monitor history dump ocurrence | ![]() |
DATS |
482 | ![]() |
iSeries: Execution Date | DATS | |
483 | ![]() |
iSeries: Execution Time | TIMS | |
484 | ![]() |
iSeries: Flag to determine if weekly info is available | ![]() |
CHAR |
485 | ![]() |
iSeries: Return Code | CHAR | |
486 | ![]() |
iSeries: Change Time | TIMS | |
487 | ![]() |
iSeries: User | CHAR | |
488 | ![]() |
DB6 CCMS: 4048 Character Text | CHAR | |
489 | ![]() |
DB6: Group ID | ![]() |
INT4 |
490 | ![]() |
DBA: ISO conform timestamp with ms precission | CHAR | |
491 | ![]() |
DBA: ISO conform timestamp with second precission | CHAR | |
492 | ![]() |
DB6: Key for Web Templates | CHAR | |
493 | ![]() |
DB6: Database Release Level | CHAR | |
494 | ![]() |
DB6 Bigint value | DEC | |
495 | ![]() |
DB6: signed decimal for integer64 data | ![]() |
DEC |
496 | ![]() |
Default values | ![]() |
RAW |
497 | ![]() |
PAGE_FETCH_PAIRS VARCHAR 254 | ![]() |
RAW |
498 | ![]() |
Field COLNAMES in SYSCAT.INDEXES | ![]() |
LCHR |
499 | ![]() |
DB6: General identifier | CHAR | |
500 | ![]() |
DB6: Long identifier | CHAR |