Where Used List (Data Element) for SAP ABAP Domain DB2DEC19V (Field type DEC, length 19, with sign)
SAP ABAP Domain
DB2DEC19V (Field type DEC, length 19, with sign) is used by
# | Object Type | Object Name | Object Description | Package | Structure Package | Software Component |
---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
||
1 | ![]() |
DB2225HVG_PAGES_IN_REAL | High water mark for # of real 4K frames in use for 64-bit | ![]() |
![]() |
![]() |
2 | ![]() |
DB2AUXSTORBP | Aux. storage in use for 64-bit - used by DB2 buffer pools | ![]() |
![]() |
![]() |
3 | ![]() |
DB2AVGTHDSZ64 | Average DB2 thread size (64 bit) | ![]() |
![]() |
![]() |
4 | ![]() |
DB2BGL2D | Number of requests to delete a list of pages (secondary GBP) | ![]() |
![]() |
![]() |
5 | ![]() |
DB2BGL2F | Number of write requests to the secondary GBP that failed | ![]() |
![]() |
![]() |
6 | ![]() |
DB2BGL2H | # Asynch IXLCACHE invocations for secondary GBP | ![]() |
![]() |
![]() |
7 | ![]() |
DB2BGL2N | Number of requests to delete a page from the secondary GBP | ![]() |
![]() |
![]() |
8 | ![]() |
DB2BGL2R | Number of requests to read the castout statistics (sec. GBP) | ![]() |
![]() |
![]() |
9 | ![]() |
DB2BGLAC | Clean pages written asynchronously | ![]() |
![]() |
![]() |
10 | ![]() |
DB2BGLAW | Changed pages written asynchronously | ![]() |
![]() |
![]() |
11 | ![]() |
DB2BGLAX | Register page list request | ![]() |
![]() |
![]() |
12 | ![]() |
DB2BGLAY | Changed pages - Read after register page list | ![]() |
![]() |
![]() |
13 | ![]() |
DB2BGLCC | Read castout class | ![]() |
![]() |
![]() |
14 | ![]() |
DB2BGLCK | GBP checkpoints triggered | ![]() |
![]() |
![]() |
15 | ![]() |
DB2BGLCS | Read castout statistics | ![]() |
![]() |
![]() |
16 | ![]() |
DB2BGLCT | Castout class threshold | ![]() |
![]() |
![]() |
17 | ![]() |
DB2BGLDG | Unregister page | ![]() |
![]() |
![]() |
18 | ![]() |
DB2BGLDN | Delete data and directory entries in GBP | ![]() |
![]() |
![]() |
19 | ![]() |
DB2BGLEX | Number of explicit cross-invalidations | ![]() |
![]() |
![]() |
20 | ![]() |
DB2BGLGT | Group buffer pool castout threshold | ![]() |
![]() |
![]() |
21 | ![]() |
DB2BGLHS | # Asynch IXLCACHE invocations for primary GBP | ![]() |
![]() |
![]() |
22 | ![]() |
DB2BGLMD | Synchronous read (not found) - Data returned | ![]() |
![]() |
![]() |
23 | ![]() |
DB2BGLMR | Synchronous Read (Not Found) - No Data Returned (Dir. Entry) | ![]() |
![]() |
![]() |
24 | ![]() |
DB2BGLN1 | # page P-lock lock negotiations for space map pages | ![]() |
![]() |
![]() |
25 | ![]() |
DB2BGLN2 | # page P-lock lock negotiations for data pages | ![]() |
![]() |
![]() |
26 | ![]() |
DB2BGLN3 | # page P-lock lock negotiations for index leaf pages | ![]() |
![]() |
![]() |
27 | ![]() |
DB2BGLOS | CF requests to read storage statistics | ![]() |
![]() |
![]() |
28 | ![]() |
DB2BGLP1 | # page P-lock lock requests for space map pages | ![]() |
![]() |
![]() |
29 | ![]() |
DB2BGLP2 | # page P-lock lock requests for data pages | ![]() |
![]() |
![]() |
30 | ![]() |
DB2BGLP3 | # page P-lock lock requests for index leaf pages | ![]() |
![]() |
![]() |
31 | ![]() |
DB2BGLRC | Pages cast out from GBP to DASD | ![]() |
![]() |
![]() |
32 | ![]() |
DB2BGLRD | Read directory info | ![]() |
![]() |
![]() |
33 | ![]() |
DB2BGLRG | Register page | ![]() |
![]() |
![]() |
34 | ![]() |
DB2BGLS1 | # page P-lock lock suspensions for space map pages | ![]() |
![]() |
![]() |
35 | ![]() |
DB2BGLS2 | # page P-lock lock suspensions for data pages | ![]() |
![]() |
![]() |
36 | ![]() |
DB2BGLS3 | # page P-lock lock suspensions for index leaf pages | ![]() |
![]() |
![]() |
37 | ![]() |
DB2BGLSW | Changed pages written synchronously to GBP | ![]() |
![]() |
![]() |
38 | ![]() |
DB2BGLU1 | # page P-lock unlock requests | ![]() |
![]() |
![]() |
39 | ![]() |
DB2BGLUN | Unlock castout | ![]() |
![]() |
![]() |
40 | ![]() |
DB2BGLWC | Clean pages written synchronously | ![]() |
![]() |
![]() |
41 | ![]() |
DB2BGLWF | Write failed - no storage | ![]() |
![]() |
![]() |
42 | ![]() |
DB2BGLXD | Synchronous read (cross invalidation) - data returned | ![]() |
![]() |
![]() |
43 | ![]() |
DB2BGLXR | Synchronous Read (Cross Invalidation) - No Data Returned | ![]() |
![]() |
![]() |
44 | ![]() |
DB2BSTCBA | Number of currently active (non-stealable) buffers | ![]() |
![]() |
![]() |
45 | ![]() |
DB2BSTDIO | Number of dynamic prefetch reads | ![]() |
![]() |
![]() |
46 | ![]() |
DB2BSTDMC | Number of times the data manager threshold was reached | ![]() |
![]() |
![]() |
47 | ![]() |
DB2BSTDPF | Number of dynamic prefetch requests | ![]() |
![]() |
![]() |
48 | ![]() |
DB2BSTDPP | Number of pages read via dynamic prefetch read I/O | ![]() |
![]() |
![]() |
49 | ![]() |
DB2BSTDSO | Number of datasets successfully opened physically | ![]() |
![]() |
![]() |
50 | ![]() |
DB2BSTDWT | Number of times the deferred write threshold was reached | ![]() |
![]() |
![]() |
51 | ![]() |
DB2BSTDWV | Number of times vertical deferred write threshold is reached | ![]() |
![]() |
![]() |
52 | ![]() |
DB2BSTGET | Number of get page requests (conditional and unconditional) | ![]() |
![]() |
![]() |
53 | ![]() |
DB2BSTIMW | Number of immediate writes | ![]() |
![]() |
![]() |
54 | ![]() |
DB2BSTJIS | Total number of denied concurrent prefetch I/O streams | ![]() |
![]() |
![]() |
55 | ![]() |
DB2BSTLIO | Number of list prefetch reads | ![]() |
![]() |
![]() |
56 | ![]() |
DB2BSTLPF | Number of list prefetch requests | ![]() |
![]() |
![]() |
57 | ![]() |
DB2BSTLPL | Number of times one or more pages were added to LPL | ![]() |
![]() |
![]() |
58 | ![]() |
DB2BSTLPP | Number of pages read via list prefetch | ![]() |
![]() |
![]() |
59 | ![]() |
DB2BSTMAX | Number of times a work file could not be opened | ![]() |
![]() |
![]() |
60 | ![]() |
DB2BSTMIG | Number of times migrated datasets were encountered | ![]() |
![]() |
![]() |
61 | ![]() |
DB2BSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | ![]() |
![]() |
![]() |
62 | ![]() |
DB2BSTPIO | Number of sequential prefetch reads | ![]() |
![]() |
![]() |
63 | ![]() |
DB2BSTPL1 | Prefetch quantity is reduced from normal to 50% | ![]() |
![]() |
![]() |
64 | ![]() |
DB2BSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | ![]() |
![]() |
![]() |
65 | ![]() |
DB2BSTPQF | The parallel query went into reduced or degenerated mode | ![]() |
![]() |
![]() |
66 | ![]() |
DB2BSTPQO | Total no. of requests for parallel query support | ![]() |
![]() |
![]() |
67 | ![]() |
DB2BSTPWS | Number of pages written | ![]() |
![]() |
![]() |
68 | ![]() |
DB2BSTREE | Sequential prefetch disabled - unavailable read engine | ![]() |
![]() |
![]() |
69 | ![]() |
DB2BSTRIO | Number of synchronous read I/O operations | ![]() |
![]() |
![]() |
70 | ![]() |
DB2BSTRPI | Number of page inserts required for read I/O | ![]() |
![]() |
![]() |
71 | ![]() |
DB2BSTRTO | Number of recall timeouts | ![]() |
![]() |
![]() |
72 | ![]() |
DB2BSTSEQ | Number of sequential prefetch requests | ![]() |
![]() |
![]() |
73 | ![]() |
DB2BSTSGT | Number of get page requests issued by sequential access req. | ![]() |
![]() |
![]() |
74 | ![]() |
DB2BSTSIO | Synchronous read requests issued by sequential access req. | ![]() |
![]() |
![]() |
75 | ![]() |
DB2BSTSPD | Sequential prefetch disabled - no buffers available | ![]() |
![]() |
![]() |
76 | ![]() |
DB2BSTSPP | Number of pages read because of normal sequential prefetch | ![]() |
![]() |
![]() |
77 | ![]() |
DB2BSTSWS | Update intents against pages in the buffer pool | ![]() |
![]() |
![]() |
78 | ![]() |
DB2BSTVPA | Number of successful virtual buffer pool expans./contract. | ![]() |
![]() |
![]() |
79 | ![]() |
DB2BSTVPL | Number of buffers allocated for virtual buffer pool | ![]() |
![]() |
![]() |
80 | ![]() |
DB2BSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | ![]() |
![]() |
![]() |
81 | ![]() |
DB2BSTWDRP | Number of pages for which destructive read was requested | ![]() |
![]() |
![]() |
82 | ![]() |
DB2BSTWFD | Work file requests were rejected due to buffer pool shortage | ![]() |
![]() |
![]() |
83 | ![]() |
DB2BSTWFF | Number of times a merge pass could not be performed | ![]() |
![]() |
![]() |
84 | ![]() |
DB2BSTWFM | Maximum number of work files concurrently used | ![]() |
![]() |
![]() |
85 | ![]() |
DB2BSTWFR | Number of merge passes requested for DB2 sort activities | ![]() |
![]() |
![]() |
86 | ![]() |
DB2BSTWFT | Number of merge passes requested for DB2 sort activities | ![]() |
![]() |
![]() |
87 | ![]() |
DB2BSTWIO | Number of asynchronous writes | ![]() |
![]() |
![]() |
88 | ![]() |
DB2BSTWKPD | Number of work prefetches not scheduled due to zero prefetch | ![]() |
![]() |
![]() |
89 | ![]() |
DB2BSTWPI | Number of page inserts required for write I/O | ![]() |
![]() |
![]() |
90 | ![]() |
DB2BSTXFL | Number of times the virtual buffer pool was full | ![]() |
![]() |
![]() |
91 | ![]() |
DB2BSTXFV | Total number of virtual buffer pool or hiperpool failures | ![]() |
![]() |
![]() |
92 | ![]() |
DB2BSTXIS | Highest number of concurrent prefetch I/O streams | ![]() |
![]() |
![]() |
93 | ![]() |
DB2BUPDRAT | Buffer Update Rate | ![]() |
![]() |
![]() |
94 | ![]() |
DB2DEC19V | dec 19 with sign | ![]() |
![]() |
![]() |
95 | ![]() |
DB2FULLP | Total number of prepares: full prepares + short prepares | ![]() |
![]() |
![]() |
96 | ![]() |
DB2GETPRAT | Number of Getpage Requests per Second | ![]() |
![]() |
![]() |
97 | ![]() |
DB2PREPR | Number of Prepare Requests | ![]() |
![]() |
![]() |
98 | ![]() |
DB2QSTEROW | Rows examined (Only data rows are taken into account) | ![]() |
![]() |
![]() |
99 | ![]() |
DB2QSTEXEC | Number of executions of the statement | ![]() |
![]() |
![]() |
100 | ![]() |
DB2QSTGPAG | Getpages | ![]() |
![]() |
![]() |
101 | ![]() |
DB2QSTINDX | Number of index scans performed for statement | ![]() |
![]() |
![]() |
102 | ![]() |
DB2QSTPLGP | Number of parallel groups created for statement | ![]() |
![]() |
![]() |
103 | ![]() |
DB2QSTPROW | Rows Processed | ![]() |
![]() |
![]() |
104 | ![]() |
DB2QSTRBUF | Synchronous Reads | ![]() |
![]() |
![]() |
105 | ![]() |
DB2QSTSORT | Number of sorts performed for statement | ![]() |
![]() |
![]() |
106 | ![]() |
DB2QSTTSCN | Number of tablespace scans performed for statement | ![]() |
![]() |
![]() |
107 | ![]() |
DB2QSTUSE | Current Copies | ![]() |
![]() |
![]() |
108 | ![]() |
DB2QSTWRIT | Synchronous Writes | ![]() |
![]() |
![]() |
109 | ![]() |
DB2QW316RS | RID List Not Used due to Insufficient Storage | ![]() |
![]() |
![]() |
110 | ![]() |
DB2QW316RT | RID List Not Used due to DB2 Limits Exceeded | ![]() |
![]() |
![]() |
111 | ![]() |
DB2REALSTORBP | Real storage in use for 64-bit - used by DB2 buffer pools | ![]() |
![]() |
![]() |
112 | ![]() |
DB2SHPREP | Number of Short Prepares | ![]() |
![]() |
![]() |
113 | ![]() |
DB2W225ALG | Total agent local storage (64-bit shared variable pools) | ![]() |
![]() |
![]() |
114 | ![]() |
DB2W225ASG | Total system agent storage (64-bit shared variable pools) | ![]() |
![]() |
![]() |
115 | ![]() |
DB2W225AX | Number of auxiliary slots (4k) in use | ![]() |
![]() |
![]() |
116 | ![]() |
DB2W225BB | Total buffer manager storage blocks (31-bit DBM1) | ![]() |
![]() |
![]() |
117 | ![]() |
DB2W225CD | TOTAL STORAGE FOR COMPRESSION DICTIONARY | ![]() |
![]() |
![]() |
118 | ![]() |
DB2W225COMSTG_AUX | # of real 4K aux slots in use for 64- bit common storage | ![]() |
![]() |
![]() |
119 | ![]() |
DB2W225COMSTG_REAL | # of real 4K frames in use for 64- bit common storage | ![]() |
![]() |
![]() |
120 | ![]() |
DB2W225FA | private fixed pool storage | ![]() |
![]() |
![]() |
121 | ![]() |
DB2W225FCG | Total 64-bit common fixed pool storage | ![]() |
![]() |
![]() |
122 | ![]() |
DB2W225GA | private getmained storage | ![]() |
![]() |
![]() |
123 | ![]() |
DB2W225GCG | Total 64-bit common getmained storage | ![]() |
![]() |
![]() |
124 | ![]() |
DB2W225GSG | Total 64-bit shared non-system agent stack | ![]() |
![]() |
![]() |
125 | ![]() |
DB2W225GSG_SYS | Total 64-bit shared system agent stack | ![]() |
![]() |
![]() |
126 | ![]() |
DB2W225H2 | High water mark for alloc. stmt cache storage in 64-bit pool | ![]() |
![]() |
![]() |
127 | ![]() |
DB2W225HVG_AUX_SLOTS | High water mark for 4K aux. slots in use for 64-bit private | ![]() |
![]() |
![]() |
128 | ![]() |
DB2W225HVG_PAGES_IN_REAL | High water mark for # of real 4K frames in use for 64-bit | ![]() |
![]() |
![]() |
129 | ![]() |
DB2W225HV_AUX_SLOTS | Number of 4K auxiliary slots in use for 64-bit private | ![]() |
![]() |
![]() |
130 | ![]() |
DB2W225HV_PAGES_IN_REAL | Number of real 4K frames in use for 64-bit private | ![]() |
![]() |
![]() |
131 | ![]() |
DB2W225L2 | Allocated statement cache storage in 64-bit agent local pool | ![]() |
![]() |
![]() |
132 | ![]() |
DB2W225PRISTG_AUX | # of real 4 K aux slots in use for 64-bit priv. storage | ![]() |
![]() |
![]() |
133 | ![]() |
DB2W225PRISTG_REAL | # of real 4 K frames in use for 64-bit priv. storage | ![]() |
![]() |
![]() |
134 | ![]() |
DB2W225RL | Number of real frames (4K) in use | ![]() |
![]() |
![]() |
135 | ![]() |
DB2W225RP | TOTAL STORAGE FOR RID POOL | ![]() |
![]() |
![]() |
136 | ![]() |
DB2W225S2 | Total 64-bit STMT CACHE BLOCKS 2G storage | ![]() |
![]() |
![]() |
137 | ![]() |
DB2W225SF | Total fixed shared 64-bit storage | ![]() |
![]() |
![]() |
138 | ![]() |
DB2W225SG | Total GETMAINed shared 64-bit storage | ![]() |
![]() |
![]() |
139 | ![]() |
DB2W225SHRAUXSLOTS | Number of auxiliary slots used for 64-bit shared storage | ![]() |
![]() |
![]() |
140 | ![]() |
DB2W225SHRGBYTES | High water mark for # of 64-bit shared bytes for this MVS L. | ![]() |
![]() |
![]() |
141 | ![]() |
DB2W225SHRINREAL | # of 64-bit shared pages backed in real storage (4K pages) | ![]() |
![]() |
![]() |
142 | ![]() |
DB2W225SHRPAGEINS | Number of 64-bit shared pages paged in from aux. storage | ![]() |
![]() |
![]() |
143 | ![]() |
DB2W225SHRPAGEOUTS | Number of 64-bit shared pages paged out to auxiliary storage | ![]() |
![]() |
![]() |
144 | ![]() |
DB2W225SHRPAGES | # of 64-bit shared memory pages alloc. for this MVS LPAR | ![]() |
![]() |
![]() |
145 | ![]() |
DB2W225SHRSTG_AUX | # of real 4 K aux slots in use for 64- bit shared storage | ![]() |
![]() |
![]() |
146 | ![]() |
DB2W225SHRSTG_REAL | # of real 4K frames in use for 64- bit shared storage | ![]() |
![]() |
![]() |
147 | ![]() |
DB2W225SHRSTKSTG_AUX | # of real 4K aux slots in use f 64- bit shared stack storage | ![]() |
![]() |
![]() |
148 | ![]() |
DB2W225SHRSTKSTG_REAL | # of real 4K frames in use for 64- bit shared stack storage | ![]() |
![]() |
![]() |
149 | ![]() |
DB2W225SM | Total 64-bit private storage f. stor. manager control struct | ![]() |
![]() |
![]() |
150 | ![]() |
DB2W225SMC | Total 64-bit common storage f.storage manager control struct | ![]() |
![]() |
![]() |
151 | ![]() |
DB2W225SU | Total 31-bit stack storage in use | ![]() |
![]() |
![]() |
152 | ![]() |
DB2W225SUG | Total 64-bit shared non-system agent stack in use | ![]() |
![]() |
![]() |
153 | ![]() |
DB2W225SUG_SYS | Total 64-bit shared system agent stack in use | ![]() |
![]() |
![]() |
154 | ![]() |
DB2W225SV | Total variable shared 64-bit storage | ![]() |
![]() |
![]() |
155 | ![]() |
DB2W225VA | private variable pool storage | ![]() |
![]() |
![]() |
156 | ![]() |
DB2W225VCG | Total 64-bit common variable pool storage | ![]() |
![]() |
![]() |
157 | ![]() |
DB2WFNPDMP | Average Work Files Not Given per Degraded Merge Pass | ![]() |
![]() |
![]() |
158 | ![]() |
DB2WFPMRGP | Average Work Files per Merge Pass | ![]() |
![]() |
![]() |
159 | ![]() |
DB2WQW0225SV | Total 64-bit shared variable pool storage | ![]() |
![]() |
![]() |
160 | ![]() |
DB2XALDAB | Number of ALTER DATABASE statements executed | ![]() |
![]() |
![]() |
161 | ![]() |
DB2XALOCC | # of ALLOCATE CURSOR statements executed | ![]() |
![]() |
![]() |
162 | ![]() |
DB2XALOCL | # of ASSOCIATE LOCATOR statements executed | ![]() |
![]() |
![]() |
163 | ![]() |
DB2XALPRO | Number of ALTER PROCEDURE statements | ![]() |
![]() |
![]() |
164 | ![]() |
DB2XALTCTX | alter trusted context | ![]() |
![]() |
![]() |
165 | ![]() |
DB2XALTIX | Number of ALTER INDEX statements executed | ![]() |
![]() |
![]() |
166 | ![]() |
DB2XALTJR | alter jar | ![]() |
![]() |
![]() |
167 | ![]() |
DB2XALTST | Number of ALTER STORAGE GROUP statements executed | ![]() |
![]() |
![]() |
168 | ![]() |
DB2XALTTA | Number of ALTER TABLE statements executed | ![]() |
![]() |
![]() |
169 | ![]() |
DB2XALTTS | Number of ALTER TABLE SPACE statements executed | ![]() |
![]() |
![]() |
170 | ![]() |
DB2XALUDF | Number of ALTER FUNCTION statements | ![]() |
![]() |
![]() |
171 | ![]() |
DB2XCALL | Number of SQL CALL statements executed | ![]() |
![]() |
![]() |
172 | ![]() |
DB2XCALLAB | # of times a stored procedure ABENDed | ![]() |
![]() |
![]() |
173 | ![]() |
DB2XCALLRJ | # of times an SQL CALL statement was rejected | ![]() |
![]() |
![]() |
174 | ![]() |
DB2XCALLTO | # of times an SQL CALL stmt timedout waiting to be scheduled | ![]() |
![]() |
![]() |
175 | ![]() |
DB2XCASCDP | Maximum level of nested SQL cascading | ![]() |
![]() |
![]() |
176 | ![]() |
DB2XCAUD | Number of user-defined functions executed | ![]() |
![]() |
![]() |
177 | ![]() |
DB2XCAUDAB | Number of times a user-defined function abended | ![]() |
![]() |
![]() |
178 | ![]() |
DB2XCAUDRJ | Number of times a user-defined function was rejected | ![]() |
![]() |
![]() |
179 | ![]() |
DB2XCAUDTO | No. of times a user-defined funct. timed out before sched. | ![]() |
![]() |
![]() |
180 | ![]() |
DB2XCDIST | Number of CREATE DISTINCT TYPE statements | ![]() |
![]() |
![]() |
181 | ![]() |
DB2XCLOSE | Number of CLOSE CURSOR statements executed | ![]() |
![]() |
![]() |
182 | ![]() |
DB2XCMTON | Number of COMMENT ON statements executed | ![]() |
![]() |
![]() |
183 | ![]() |
DB2XCON1 | Number of CONNECT TYPE 1 statements executed | ![]() |
![]() |
![]() |
184 | ![]() |
DB2XCON2 | Number of CONNECT TYPE 2 statements executed | ![]() |
![]() |
![]() |
185 | ![]() |
DB2XCOORNO | COORDINATOR setting mismatch | ![]() |
![]() |
![]() |
186 | ![]() |
DB2XCRALS | Number of CREATE ALIAS statements executed | ![]() |
![]() |
![]() |
187 | ![]() |
DB2XCRATB | Number of CREATE AUXILIARY TABLE statements | ![]() |
![]() |
![]() |
188 | ![]() |
DB2XCRCTX | create trusted context | ![]() |
![]() |
![]() |
189 | ![]() |
DB2XCRDAB | Number of CREATE DATABASE statements executed | ![]() |
![]() |
![]() |
190 | ![]() |
DB2XCRGTT | # OF CREATE GLBL TEMP TABLE | ![]() |
![]() |
![]() |
191 | ![]() |
DB2XCRINX | Number of CREATE INDEX statements executed | ![]() |
![]() |
![]() |
192 | ![]() |
DB2XCRPRO | Number of CREATE PROCEDURE statements | ![]() |
![]() |
![]() |
193 | ![]() |
DB2XCRROL | create role | ![]() |
![]() |
![]() |
194 | ![]() |
DB2XCRSTG | Number of CREATE STORAGE GROUP statements executed | ![]() |
![]() |
![]() |
195 | ![]() |
DB2XCRSYN | Number of CREATE SYNONYM statements executed | ![]() |
![]() |
![]() |
196 | ![]() |
DB2XCRTAB | Number of CREATE TABLE statements executed | ![]() |
![]() |
![]() |
197 | ![]() |
DB2XCRUDF | Number of CREATE FUNCTION statements | ![]() |
![]() |
![]() |
198 | ![]() |
DB2XCTABS | Number of CREATE TABLE SPACE statements executed | ![]() |
![]() |
![]() |
199 | ![]() |
DB2XCTRIG | Number of SQL CREATE TRIGGER statements | ![]() |
![]() |
![]() |
200 | ![]() |
DB2XDDIST | Number of DROP DISTINCT TYPE statements | ![]() |
![]() |
![]() |
201 | ![]() |
DB2XDEFVU | Number of CREATE VIEW statements executed | ![]() |
![]() |
![]() |
202 | ![]() |
DB2XDEGBUF | Parallel groups fell to sequential due to storage shortage | ![]() |
![]() |
![]() |
203 | ![]() |
DB2XDEGCUR | Parallel groups fell to sequential due to updatable cursor | ![]() |
![]() |
![]() |
204 | ![]() |
DB2XDEGENC | Par.groups fell to sequ. due to unavailable enclave services | ![]() |
![]() |
![]() |
205 | ![]() |
DB2XDEGESA | Par. groups fell to sequ. due to lack of ESA sort support | ![]() |
![]() |
![]() |
206 | ![]() |
DB2XDELET | Number of DELETE statements executed | ![]() |
![]() |
![]() |
207 | ![]() |
DB2XDESC | Number of DESCRIBE statements executed | ![]() |
![]() |
![]() |
208 | ![]() |
DB2XDRPAL | Number of DROP ALIAS statements executed | ![]() |
![]() |
![]() |
209 | ![]() |
DB2XDRPCTX | drop trusted context | ![]() |
![]() |
![]() |
210 | ![]() |
DB2XDRPDB | Number of DROP DATABASE statements executed | ![]() |
![]() |
![]() |
211 | ![]() |
DB2XDRPFN | Number of DROP UDF statements | ![]() |
![]() |
![]() |
212 | ![]() |
DB2XDRPIX | Number of DROP INDEX statements executed | ![]() |
![]() |
![]() |
213 | ![]() |
DB2XDRPPKG | Number of DROP PACKAGE statements executed | ![]() |
![]() |
![]() |
214 | ![]() |
DB2XDRPPR | Number of DROP PROCEDURE statements | ![]() |
![]() |
![]() |
215 | ![]() |
DB2XDRPROL | drop role | ![]() |
![]() |
![]() |
216 | ![]() |
DB2XDRPST | Number of DROP STORAGE GROUP statements executed | ![]() |
![]() |
![]() |
217 | ![]() |
DB2XDRPSY | Number of DROP SYNONYM statements executed | ![]() |
![]() |
![]() |
218 | ![]() |
DB2XDRPTA | Number of DROP TABLE statements executed | ![]() |
![]() |
![]() |
219 | ![]() |
DB2XDRPTR | Number of SQL DROP TRIGGER statements | ![]() |
![]() |
![]() |
220 | ![]() |
DB2XDRPTS | Number of DROP TABLE SPACE statements executed | ![]() |
![]() |
![]() |
221 | ![]() |
DB2XDRPVU | Number of DROP VIEW statements executed | ![]() |
![]() |
![]() |
222 | ![]() |
DB2XDSCRTB | Number of DESCRIBE TABLE statements executed | ![]() |
![]() |
![]() |
223 | ![]() |
DB2XFETCH | Number of FETCH statements executed | ![]() |
![]() |
![]() |
224 | ![]() |
DB2XFREEL | Number of FREE LOCATOR statements | ![]() |
![]() |
![]() |
225 | ![]() |
DB2XGRANT | Number of GRANT statements executed | ![]() |
![]() |
![]() |
226 | ![]() |
DB2XHOLDL | Number of HOLD LOCATOR statements | ![]() |
![]() |
![]() |
227 | ![]() |
DB2XINCRB | Number of INCREMENTAL BINDs executed | ![]() |
![]() |
![]() |
228 | ![]() |
DB2XINSRT | Number of INSERT statements executed | ![]() |
![]() |
![]() |
229 | ![]() |
DB2XISORR | Isolation level RR or RS | ![]() |
![]() |
![]() |
230 | ![]() |
DB2XLABON | Number of LABEL ON statements executed | ![]() |
![]() |
![]() |
231 | ![]() |
DB2XLOCK | Number of LOCK TABLE statements executed | ![]() |
![]() |
![]() |
232 | ![]() |
DB2XMAXDEG | Maximum parallelism degree | ![]() |
![]() |
![]() |
233 | ![]() |
DB2XMERGE | # of times merge sql statement was executed | ![]() |
![]() |
![]() |
234 | ![]() |
DB2XMIAP | Number of times RID list processing is used | ![]() |
![]() |
![]() |
235 | ![]() |
DB2XMRMIAP | RID list processing failed - limit exeeded | ![]() |
![]() |
![]() |
236 | ![]() |
DB2XNORGRP | Parallel groups: executed as planned | ![]() |
![]() |
![]() |
237 | ![]() |
DB2XNSMIAP | RID list processing failed - no storage | ![]() |
![]() |
![]() |
238 | ![]() |
DB2XOPEN | Number of OPEN CURSOR statements executed | ![]() |
![]() |
![]() |
239 | ![]() |
DB2XPREP | Number of PREPARE statements executed | ![]() |
![]() |
![]() |
240 | ![]() |
DB2XREDGRP | Parallel groups: executed with reduced degree | ![]() |
![]() |
![]() |
241 | ![]() |
DB2XREL | Number of RELEASE statements executed | ![]() |
![]() |
![]() |
242 | ![]() |
DB2XREOP | Total Number of Times Reoptimization Occurs | ![]() |
![]() |
![]() |
243 | ![]() |
DB2XREPOP1 | Parallel groups with reformulated access path (Sysplex conf) | ![]() |
![]() |
![]() |
244 | ![]() |
DB2XREPOP2 | Parallel groups with reformulated access path (buffer pool) | ![]() |
![]() |
![]() |
245 | ![]() |
DB2XREVOK | Number of REVOKE statements executed | ![]() |
![]() |
![]() |
246 | ![]() |
DB2XRNIX | rename index | ![]() |
![]() |
![]() |
247 | ![]() |
DB2XRNTAB | RENAME TABLE | ![]() |
![]() |
![]() |
248 | ![]() |
DB2XROIIDX | Direct row access attempted, but reverted to using index | ![]() |
![]() |
![]() |
249 | ![]() |
DB2XROIMAT | Number of times DB2 used dir. row access to locate a record | ![]() |
![]() |
![]() |
250 | ![]() |
DB2XROITS | Direct row access attempted, reverted to tablespace scan | ![]() |
![]() |
![]() |
251 | ![]() |
DB2XROWTRG | Number of times a row trigger is activated | ![]() |
![]() |
![]() |
252 | ![]() |
DB2XSELECT | Number of SELECT statements executed | ![]() |
![]() |
![]() |
253 | ![]() |
DB2XSETCDG | Number of SET CURRENT DEGREE statements executed | ![]() |
![]() |
![]() |
254 | ![]() |
DB2XSETCON | Number of SET CONNECTION statements executed | ![]() |
![]() |
![]() |
255 | ![]() |
DB2XSETCRL | Number of SET CURRENT RULES statements executed | ![]() |
![]() |
![]() |
256 | ![]() |
DB2XSETHV | Number of SET HOST VARIABLE statements executed | ![]() |
![]() |
![]() |
257 | ![]() |
DB2XSETPTH | Number of SQL SET CURRENT PATH statements | ![]() |
![]() |
![]() |
258 | ![]() |
DB2XSETSQL | Number of SET CURRENT SQLID statements executed | ![]() |
![]() |
![]() |
259 | ![]() |
DB2XSTDEXP | MAXKEEPD parameter exceeded | ![]() |
![]() |
![]() |
260 | ![]() |
DB2XSTFND | Number of Times that DB2 Found the Statement in the Cache | ![]() |
![]() |
![]() |
261 | ![]() |
DB2XSTINV | Statement invalidated | ![]() |
![]() |
![]() |
262 | ![]() |
DB2XSTIRP | Number of implicit prepares | ![]() |
![]() |
![]() |
263 | ![]() |
DB2XSTLOBV | Maximum storage used for LOB values (MB) | ![]() |
![]() |
![]() |
264 | ![]() |
DB2XSTNFND | Number of times statement could not be found in cache | ![]() |
![]() |
![]() |
265 | ![]() |
DB2XSTNPRP | Number of avoided prepares | ![]() |
![]() |
![]() |
266 | ![]() |
DB2XSTTRG | Number of times a statement trigger is activated | ![]() |
![]() |
![]() |
267 | ![]() |
DB2XTOTGRP | Parallel groups: total executed | ![]() |
![]() |
![]() |
268 | ![]() |
DB2XTRGERR | No. of times an SQL error occurred during a triggered action | ![]() |
![]() |
![]() |
269 | ![]() |
DB2XTRTBL | # of times truncate table stmt was exec. | ![]() |
![]() |
![]() |
270 | ![]() |
DB2XUPDTE | Number of UPDATE statements executed | ![]() |
![]() |
![]() |
271 | ![]() |
DB2XXCBPNX | Parallel groups: intended to run across data sharing group | ![]() |
![]() |
![]() |
272 | ![]() |
DB2XXCSKIP | Member bypasses due to storage shortage | ![]() |
![]() |
![]() |