Table/Structure Field list used by SAP ABAP Program LSDB2CCMS_ANALYSISSUB (DB2 z/OS: DB2 Subsystem Activity)
SAP ABAP Program 
LSDB2CCMS_ANALYSISSUB (DB2 z/OS: DB2 Subsystem Activity) is using
-
Class (17)
-
Data Element (7)
-
Table/Structure Field (619)
-
Function Module (25)
-
Message Class (2)
-
Message Number (52)
-
Class Method (24)
-
Program (1)
-
Table (61)
pages: 1 2
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 | Table/Structure Field |
ALV_S_FCAT - COL_OPT | Entry for Optional Column Optimization | |
| 2 | Table/Structure Field |
ALV_S_FCAT - COL_POS | ALV control: Output column | |
| 3 | Table/Structure Field |
ALV_S_FCAT - FIELDNAME | ALV control: Field name of internal table field | |
| 4 | Table/Structure Field |
ALV_S_FCAT - INTTYPE | ABAP data type (C,D,N,...) | |
| 5 | Table/Structure Field |
ALV_S_FCAT - JUST | ALV control: Alignment | |
| 6 | Table/Structure Field |
ALV_S_FCAT - KEY | ALV control: Key field | |
| 7 | Table/Structure Field |
ALV_S_FCAT - LOWERCASE | Lowercase letters allowed/not allowed | |
| 8 | Table/Structure Field |
ALV_S_FCAT - NO_OUT | ALV control: Column is not output | |
| 9 | Table/Structure Field |
ALV_S_FCAT - OUTPUTLEN | ALV control: Column width in characters | |
| 10 | Table/Structure Field |
ALV_S_FCAT - ROLLNAME | ALV control: Data element for F1 help | |
| 11 | Table/Structure Field |
ALV_S_FCAT - SELTEXT | ALV control: Column identifier for dialog functions | |
| 12 | Table/Structure Field |
DB2DSMEM - MEMB_NAME | DB2DSMEM-MEMB_NAME | |
| 13 | Table/Structure Field |
DB2DSMEM - SSID | DB2DSMEM-SSID | |
| 14 | Table/Structure Field |
DB2LOCKS - ABAPREP | ABAP Program: Current Main Program | |
| 15 | Table/Structure Field |
DB2LOCKS - ABORT | Total number of rollback requests | |
| 16 | Table/Structure Field |
DB2LOCKS - ACE | Field type raw, length 8, 4 bytes | |
| 17 | Table/Structure Field |
DB2LOCKS - ACTTIME | Activity time (Class 1 elapsed time) | |
| 18 | Table/Structure Field |
DB2LOCKS - ADTHRSTA | Status of the thread | |
| 19 | Table/Structure Field |
DB2LOCKS - ASHOST | Application server host name | |
| 20 | Table/Structure Field |
DB2LOCKS - AUTHID | The authorization ID under which the transaction is running | |
| 21 | Table/Structure Field |
DB2LOCKS - CONNID | The connection ID of the thread | |
| 22 | Table/Structure Field |
DB2LOCKS - CONNNAME | DB2LOCKS-CONNNAME | |
| 23 | Table/Structure Field |
DB2LOCKS - CORRID | The correlation ID of the thread (IP address) | |
| 24 | Table/Structure Field |
DB2LOCKS - CPUTIME | The accumulated home CPU time a thread spent in DB2 | |
| 25 | Table/Structure Field |
DB2LOCKS - DBCOMMIT | The number of successful phase 2 or single-phase commits | |
| 26 | Table/Structure Field |
DB2LOCKS - DBOWNER | The name of the DB2 database | |
| 27 | Table/Structure Field |
DB2LOCKS - DBPLAN | DB2 plan name | |
| 28 | Table/Structure Field |
DB2LOCKS - DS_MEMBER | DB2LOCKS-DS_MEMBER | |
| 29 | Table/Structure Field |
DB2LOCKS - DURATION | Lock duration of the thread holding the resource | |
| 30 | Table/Structure Field |
DB2LOCKS - ELTIME | Time elapsed since DB2 thread was started | |
| 31 | Table/Structure Field |
DB2LOCKS - ENDUSER | DB2LOCKS-ENDUSER | |
| 32 | Table/Structure Field |
DB2LOCKS - FILLER | Field type char, length 8 | |
| 33 | Table/Structure Field |
DB2LOCKS - GETPAGE | Number of Getpage Requests | |
| 34 | Table/Structure Field |
DB2LOCKS - HDATDAT | Date when sampling is taken | |
| 35 | Table/Structure Field |
DB2LOCKS - HDATTIM | Time when sampling is taken | |
| 36 | Table/Structure Field |
DB2LOCKS - HDLRESTIME | Time of last reset | |
| 37 | Table/Structure Field |
DB2LOCKS - HDSUBSYSID | DB2 subsystem ID | |
| 38 | Table/Structure Field |
DB2LOCKS - HOLD_WAIT | Detectionflag for Holders(H) or Waiters(W) for DB2Resources | |
| 39 | Table/Structure Field |
DB2LOCKS - J2EESERV | DB2LOCKS-J2EESERV | |
| 40 | Table/Structure Field |
DB2LOCKS - JOBNAME | The job name of the thread. | |
| 41 | Table/Structure Field |
DB2LOCKS - LOCKATRI | Lock attribute (logical lock or physical lock) | |
| 42 | Table/Structure Field |
DB2LOCKS - LOCKID | Small integer (2 bytes) | |
| 43 | Table/Structure Field |
DB2LOCKS - LOCKMOD | The mode of the lock held on the resource | |
| 44 | Table/Structure Field |
DB2LOCKS - LOCKMOD_DB | The mode of the lock held on the resource | |
| 45 | Table/Structure Field |
DB2LOCKS - LOCKS | The total number of currently hold locks. | |
| 46 | Table/Structure Field |
DB2LOCKS - LOCKTYPE | State of lock | |
| 47 | Table/Structure Field |
DB2LOCKS - NQW1503H | Natural number | |
| 48 | Table/Structure Field |
DB2LOCKS - NQW1503W | Natural number | |
| 49 | Table/Structure Field |
DB2LOCKS - PAGESET | Object name | |
| 50 | Table/Structure Field |
DB2LOCKS - PRCINDB2 | Thread activity: % processing in DB2 | |
| 51 | Table/Structure Field |
DB2LOCKS - PROCINDB2 | Percentage of time spent processing in DB2 | |
| 52 | Table/Structure Field |
DB2LOCKS - QMDAPLAT | DB2LOCKS-QMDAPLAT | |
| 53 | Table/Structure Field |
DB2LOCKS - QWACPARR | DB2LOCKS-QWACPARR | |
| 54 | Table/Structure Field |
DB2LOCKS - QWHDRQNM | DB2LOCKS-QWHDRQNM | |
| 55 | Table/Structure Field |
DB2LOCKS - RESTYPE | The type of resource held by a lock | |
| 56 | Table/Structure Field |
DB2LOCKS - SAPSID | DB2LOCKS-SAPSID | |
| 57 | Table/Structure Field |
DB2LOCKS - SAPSYS | DB2LOCKS-SAPSYS | |
| 58 | Table/Structure Field |
DB2LOCKS - SQLCNT | The total number of executed SQL statements | |
| 59 | Table/Structure Field |
DB2LOCKS - SSPINDB2 | Prozent der Zeit für die DB2-Verarbeitung (CPU-Zeit) | |
| 60 | Table/Structure Field |
DB2LOCKS - THDMLOCKS | DB2LOCKS-THDMLOCKS | |
| 61 | Table/Structure Field |
DB2LOCKS - THDREQ | Number of Requests Sent to DB2 | |
| 62 | Table/Structure Field |
DB2LOCKS - THDSTAT | The status of the thread | |
| 63 | Table/Structure Field |
DB2LOCKS - TIMEINDB2 | Percentage of time spent in DB2 | |
| 64 | Table/Structure Field |
DB2LOCKS - TXCODE | transaction / thread name | |
| 65 | Table/Structure Field |
DB2LOCKS - UPDPAGE | The number of times a buffer update occurs for the agent | |
| 66 | Table/Structure Field |
DB2LOCKS - USERID | DB2/OS390: Unique counter | |
| 67 | Table/Structure Field |
DB2LOCKS - WPID | Work process ID | |
| 68 | Table/Structure Field |
DB2LOCKS - WPNUMBER | process ID | |
| 69 | Table/Structure Field |
DB2LOCKS - WPTYPE | process type | |
| 70 | Table/Structure Field |
DB2LOCKSH - LOCKMOD | The mode of the lock held on the resource | |
| 71 | Table/Structure Field |
DB2NQW03 - NQW1503H | Natural number | |
| 72 | Table/Structure Field |
DB2NQW03 - NQW1503W | Natural number | |
| 73 | Table/Structure Field |
DB2Q3ST - Q3STABRT | Units of recovery were backed out successfully | |
| 74 | Table/Structure Field |
DB2Q3ST - Q3STCOMM | Commit phase 2 requests in a two-phase commit environment | |
| 75 | Table/Structure Field |
DB2Q3ST - Q3STCTHD | Number of successful create thread requests | |
| 76 | Table/Structure Field |
DB2Q3ST - Q3STCTHW | Number of create thread requests queued | |
| 77 | Table/Structure Field |
DB2Q3ST - Q3STEXIT | Field Type INT, Length 4 | |
| 78 | Table/Structure Field |
DB2Q3ST - Q3STIDEN | Successful connections to DB2 from an allied address space | |
| 79 | Table/Structure Field |
DB2Q3ST - Q3STINDT | Number of indoubts units of recovery | |
| 80 | Table/Structure Field |
DB2Q3ST - Q3STMEOM | Non-DB2 address space deleted by MVS while connected to DB2 | |
| 81 | Table/Structure Field |
DB2Q3ST - Q3STMEOT | Number of times non-DB2 tasks abended while connected to DB2 | |
| 82 | Table/Structure Field |
DB2Q3ST - Q3STPREP | Commit phase 1 requests in a two-phase environment | |
| 83 | Table/Structure Field |
DB2Q3ST - Q3STRDON | Number of read-only commits | |
| 84 | Table/Structure Field |
DB2Q3ST - Q3STRIUR | Number of indoubts unit of recovery successfully resolved | |
| 85 | Table/Structure Field |
DB2Q3ST - Q3STSIGN | Successful signon requests to identify a new user for CICS | |
| 86 | Table/Structure Field |
DB2Q3ST - Q3STSSSI | Field Type INT, Length 4 | |
| 87 | Table/Structure Field |
DB2Q3ST - Q3STSYNC | Number of commits in a single-phase environment | |
| 88 | Table/Structure Field |
DB2Q3ST - Q3STTERM | Number of times threads were terminated successfully | |
| 89 | Table/Structure Field |
DB2Q9ST - Q9STCTR6 | Field Type DEC, Length 10 | |
| 90 | Table/Structure Field |
DB2Q9ST - Q9STCTRN | Field Type DEC, Length 10 | |
| 91 | Table/Structure Field |
DB2Q9ST - Q9STCTRS | Field Type DEC, Length 10 | |
| 92 | Table/Structure Field |
DB2QBAC - BPNAME | DB2 buffer pool name | |
| 93 | Table/Structure Field |
DB2QBGB - QBGBGN | Group buffer pool ID | |
| 94 | Table/Structure Field |
DB2QBGL - QBGL2D | Number of requests to delete a list of pages (secondary GBP) | |
| 95 | Table/Structure Field |
DB2QBGL - QBGL2F | Number of write requests to the secondary GBP that failed | |
| 96 | Table/Structure Field |
DB2QBGL - QBGL2H | # Asynch IXLCACHE invocations for secondary GBP | |
| 97 | Table/Structure Field |
DB2QBGL - QBGL2N | Number of requests to delete a page from the secondary GBP | |
| 98 | Table/Structure Field |
DB2QBGL - QBGL2R | Number of requests to read the castout statistics (sec. GBP) | |
| 99 | Table/Structure Field |
DB2QBGL - QBGLAC | Clean pages written asynchronously | |
| 100 | Table/Structure Field |
DB2QBGL - QBGLAW | Changed pages written asynchronously | |
| 101 | Table/Structure Field |
DB2QBGL - QBGLAX | Register page list request | |
| 102 | Table/Structure Field |
DB2QBGL - QBGLAY | Changed pages - Read after register page list | |
| 103 | Table/Structure Field |
DB2QBGL - QBGLCC | Read castout class | |
| 104 | Table/Structure Field |
DB2QBGL - QBGLCK | GBP checkpoints triggered | |
| 105 | Table/Structure Field |
DB2QBGL - QBGLCS | Read castout statistics | |
| 106 | Table/Structure Field |
DB2QBGL - QBGLCT | Castout class threshold | |
| 107 | Table/Structure Field |
DB2QBGL - QBGLDG | Unregister page | |
| 108 | Table/Structure Field |
DB2QBGL - QBGLDN | Delete data and directory entries in GBP | |
| 109 | Table/Structure Field |
DB2QBGL - QBGLEX | Number of explicit cross-invalidations | |
| 110 | Table/Structure Field |
DB2QBGL - QBGLGN | Group buffer pool ID | |
| 111 | Table/Structure Field |
DB2QBGL - QBGLGT | Group buffer pool castout threshold | |
| 112 | Table/Structure Field |
DB2QBGL - QBGLHS | # Asynch IXLCACHE invocations for primary GBP | |
| 113 | Table/Structure Field |
DB2QBGL - QBGLMD | Synchronous read (not found) - Data returned | |
| 114 | Table/Structure Field |
DB2QBGL - QBGLMR | Synchronous Read (Not Found) - No Data Returned (Dir. Entry) | |
| 115 | Table/Structure Field |
DB2QBGL - QBGLN1 | # page P-lock lock negotiations for space map pages | |
| 116 | Table/Structure Field |
DB2QBGL - QBGLN2 | # page P-lock lock negotiations for data pages | |
| 117 | Table/Structure Field |
DB2QBGL - QBGLN3 | # page P-lock lock negotiations for index leaf pages | |
| 118 | Table/Structure Field |
DB2QBGL - QBGLOS | CF requests to read storage statistics | |
| 119 | Table/Structure Field |
DB2QBGL - QBGLP1 | # page P-lock lock requests for space map pages | |
| 120 | Table/Structure Field |
DB2QBGL - QBGLP2 | # page P-lock lock requests for data pages | |
| 121 | Table/Structure Field |
DB2QBGL - QBGLP3 | # page P-lock lock requests for index leaf pages | |
| 122 | Table/Structure Field |
DB2QBGL - QBGLRC | Pages cast out from GBP to DASD | |
| 123 | Table/Structure Field |
DB2QBGL - QBGLRD | Read directory info | |
| 124 | Table/Structure Field |
DB2QBGL - QBGLRG | Register page | |
| 125 | Table/Structure Field |
DB2QBGL - QBGLS1 | # page P-lock lock suspensions for space map pages | |
| 126 | Table/Structure Field |
DB2QBGL - QBGLS2 | # page P-lock lock suspensions for data pages | |
| 127 | Table/Structure Field |
DB2QBGL - QBGLS3 | # page P-lock lock suspensions for index leaf pages | |
| 128 | Table/Structure Field |
DB2QBGL - QBGLSW | Changed pages written synchronously to GBP | |
| 129 | Table/Structure Field |
DB2QBGL - QBGLU1 | # page P-lock unlock requests | |
| 130 | Table/Structure Field |
DB2QBGL - QBGLUN | Unlock castout | |
| 131 | Table/Structure Field |
DB2QBGL - QBGLWC | Clean pages written synchronously | |
| 132 | Table/Structure Field |
DB2QBGL - QBGLWF | Write failed - no storage | |
| 133 | Table/Structure Field |
DB2QBGL - QBGLXD | Synchronous read (cross invalidation) - data returned | |
| 134 | Table/Structure Field |
DB2QBGL - QBGLXR | Synchronous Read (Cross Invalidation) - No Data Returned | |
| 135 | Table/Structure Field |
DB2QBST - BUPDRATE | Buffer Update Rate | |
| 136 | Table/Structure Field |
DB2QBST - CURRINUSE | Percentage of buffers currently in use | |
| 137 | Table/Structure Field |
DB2QBST - GETPRAND | Number of Random Access Getpage Requests | |
| 138 | Table/Structure Field |
DB2QBST - GETPRATE | Number of Getpage Requests per Second | |
| 139 | Table/Structure Field |
DB2QBST - MARK | Single-Character Flag | |
| 140 | Table/Structure Field |
DB2QBST - PAGEIN | Number of page-ins | |
| 141 | Table/Structure Field |
DB2QBST - PG_DYNPREF | Number of Pages Read per Dynamic Prefetch Read | |
| 142 | Table/Structure Field |
DB2QBST - PG_LISPREF | Number of Pages Read per List Prefetch Read | |
| 143 | Table/Structure Field |
DB2QBST - PG_SEQPREF | Number of Pages Read per Sequential Prefetch Read | |
| 144 | Table/Structure Field |
DB2QBST - PREFDIS | Number of Times Sequential Prefetch Was Disabled | |
| 145 | Table/Structure Field |
DB2QBST - PWPWIO | Pages written per write I/O | |
| 146 | Table/Structure Field |
DB2QBST - QBSTBPNM | DB2 buffer pool name | |
| 147 | Table/Structure Field |
DB2QBST - QBSTCBA | Number of currently active (non-stealable) buffers | |
| 148 | Table/Structure Field |
DB2QBST - QBSTDIO | Number of dynamic prefetch reads | |
| 149 | Table/Structure Field |
DB2QBST - QBSTDMC | Number of times the data manager threshold was reached | |
| 150 | Table/Structure Field |
DB2QBST - QBSTDPF | Number of dynamic prefetch requests | |
| 151 | Table/Structure Field |
DB2QBST - QBSTDPP | Number of pages read via dynamic prefetch read I/O | |
| 152 | Table/Structure Field |
DB2QBST - QBSTDSO | Number of datasets successfully opened physically | |
| 153 | Table/Structure Field |
DB2QBST - QBSTDWT | Number of times the deferred write threshold was reached | |
| 154 | Table/Structure Field |
DB2QBST - QBSTDWV | Number of times vertical deferred write threshold is reached | |
| 155 | Table/Structure Field |
DB2QBST - QBSTGET | Number of get page requests (conditional and unconditional) | |
| 156 | Table/Structure Field |
DB2QBST - QBSTHITR | Buffer hit ratio | |
| 157 | Table/Structure Field |
DB2QBST - QBSTIMW | Number of immediate writes | |
| 158 | Table/Structure Field |
DB2QBST - QBSTJIS | Total number of denied concurrent prefetch I/O streams | |
| 159 | Table/Structure Field |
DB2QBST - QBSTLIO | Number of list prefetch reads | |
| 160 | Table/Structure Field |
DB2QBST - QBSTLPF | Number of list prefetch requests | |
| 161 | Table/Structure Field |
DB2QBST - QBSTLPP | Number of pages read via list prefetch | |
| 162 | Table/Structure Field |
DB2QBST - QBSTMAX | Number of times a work file could not be opened | |
| 163 | Table/Structure Field |
DB2QBST - QBSTMIG | Number of times migrated datasets were encountered | |
| 164 | Table/Structure Field |
DB2QBST - QBSTPID | Field type numc, length 10, integer | |
| 165 | Table/Structure Field |
DB2QBST - QBSTPIO | Number of sequential prefetch reads | |
| 166 | Table/Structure Field |
DB2QBST - QBSTPL1 | Prefetch quantity is reduced from normal to 50% | |
| 167 | Table/Structure Field |
DB2QBST - QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | |
| 168 | Table/Structure Field |
DB2QBST - QBSTPQF | The parallel query went into reduced or degenerated mode | |
| 169 | Table/Structure Field |
DB2QBST - QBSTPQO | Total no. of requests for parallel query support | |
| 170 | Table/Structure Field |
DB2QBST - QBSTPWS | Number of pages written | |
| 171 | Table/Structure Field |
DB2QBST - QBSTREE | Sequential prefetch disabled - unavailable read engine | |
| 172 | Table/Structure Field |
DB2QBST - QBSTRIO | Number of synchronous read I/O operations | |
| 173 | Table/Structure Field |
DB2QBST - QBSTRPI | Number of page inserts required for read I/O | |
| 174 | Table/Structure Field |
DB2QBST - QBSTRTO | Number of recall timeouts | |
| 175 | Table/Structure Field |
DB2QBST - QBSTSEQ | Number of sequential prefetch requests | |
| 176 | Table/Structure Field |
DB2QBST - QBSTSGT | Number of get page requests issued by sequential access req. | |
| 177 | Table/Structure Field |
DB2QBST - QBSTSIO | Synchronous read requests issued by sequential access req. | |
| 178 | Table/Structure Field |
DB2QBST - QBSTSPD | Sequential prefetch disabled - no buffers available | |
| 179 | Table/Structure Field |
DB2QBST - QBSTSPP | Number of pages read because of normal sequential prefetch | |
| 180 | Table/Structure Field |
DB2QBST - QBSTSWS | Update intents against pages in the buffer pool | |
| 181 | Table/Structure Field |
DB2QBST - QBSTVPA | Number of successful virtual buffer pool expans./contract. | |
| 182 | Table/Structure Field |
DB2QBST - QBSTVPL | Number of buffers allocated for virtual buffer pool | |
| 183 | Table/Structure Field |
DB2QBST - QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | |
| 184 | Table/Structure Field |
DB2QBST - QBSTWDRP | Number of pages for which destructive read was requested | |
| 185 | Table/Structure Field |
DB2QBST - QBSTWEE | A write engine is unavailable for asynchronous write I/O | |
| 186 | Table/Structure Field |
DB2QBST - QBSTWFD | Work file requests were rejected due to buffer pool shortage | |
| 187 | Table/Structure Field |
DB2QBST - QBSTWFF | Number of times a merge pass could not be performed | |
| 188 | Table/Structure Field |
DB2QBST - QBSTWFM | Maximum number of work files concurrently used | |
| 189 | Table/Structure Field |
DB2QBST - QBSTWFR | Number of merge passes requested for DB2 sort activities | |
| 190 | Table/Structure Field |
DB2QBST - QBSTWFT | Number of merge passes requested for DB2 sort activities | |
| 191 | Table/Structure Field |
DB2QBST - QBSTWIO | Number of asynchronous writes | |
| 192 | Table/Structure Field |
DB2QBST - QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | |
| 193 | Table/Structure Field |
DB2QBST - QBSTWPI | Number of page inserts required for write I/O | |
| 194 | Table/Structure Field |
DB2QBST - QBSTXFL | Number of times the virtual buffer pool was full | |
| 195 | Table/Structure Field |
DB2QBST - QBSTXFV | Total number of virtual buffer pool or hiperpool failures | |
| 196 | Table/Structure Field |
DB2QBST - QBSTXIS | Highest number of concurrent prefetch I/O streams | |
| 197 | Table/Structure Field |
DB2QBST - RANDHITR | Random hit ratio | |
| 198 | Table/Structure Field |
DB2QBST - READRATE | Read rate per second | |
| 199 | Table/Structure Field |
DB2QBST - SIOPERSGT | Sync. seq. reads / seq. getpages | |
| 200 | Table/Structure Field |
DB2QBST - SWRTRATE | Sync writes / ( sync writes + async writes) | |
| 201 | Table/Structure Field |
DB2QBST - SYNRRAND | Number of Random Access Synchronous Reads | |
| 202 | Table/Structure Field |
DB2QBST - UPPPWRIT | Buffer update per pages written | |
| 203 | Table/Structure Field |
DB2QBST - VPSHORT | Number of Virtual Pool Shortages | |
| 204 | Table/Structure Field |
DB2QBST - WFN_DEGMP | Average Work Files Not Given per Degraded Merge Pass | |
| 205 | Table/Structure Field |
DB2QBST - WF_MERGE | Average Work Files per Merge Pass | |
| 206 | Table/Structure Field |
DB2QBST - WRITERATE | Write rate = ( Synchronous + async. writes ) / interval | |
| 207 | Table/Structure Field |
DB2QCLREQ - DSECNPROCD | DB2QCLREQ-DSECNPROCD | |
| 208 | Table/Structure Field |
DB2QCLREQ - DSECPROCD | DB2QCLREQ-DSECPROCD | |
| 209 | Table/Structure Field |
DB2QCLREQ - RETRY | DB2QCLREQ-RETRY | |
| 210 | Table/Structure Field |
DB2QDBP - QDBPNM | Name of buffer pool | |
| 211 | Table/Structure Field |
DB2QDBP - QDBPVPSZ | The size of the virtual buffer pool | |
| 212 | Table/Structure Field |
DB2QISE - QISECTG | Number of requests for cursor table sections | |
| 213 | Table/Structure Field |
DB2QISE - QISECTL | Number of CT sections not found in EDM pool | |
| 214 | Table/Structure Field |
DB2QISE - QISEDBD | Current number of pages in EDM pool used for DB descriptor | |
| 215 | Table/Structure Field |
DB2QISE - QISEDBDG | Number of requests for database descriptor | |
| 216 | Table/Structure Field |
DB2QISE - QISEDBDL | Number of DB descriptors not found in EDM pool | |
| 217 | Table/Structure Field |
DB2QISE - QISEDFRE | Number of free pages in the data space free chain | |
| 218 | Table/Structure Field |
DB2QISE - QISEDPGE | Number of pages in the data space used by the EDM pool | |
| 219 | Table/Structure Field |
DB2QISE - QISEDSC | Number of pages used for DSC | |
| 220 | Table/Structure Field |
DB2QISE - QISEDSG | Number of requests for DSC sections | |
| 221 | Table/Structure Field |
DB2QISE - QISEDSI | Number of inserts into EDM pool for dynamic statement cache | |
| 222 | Table/Structure Field |
DB2QISE - QISEFAIL | Field type numc, length 10, integer | |
| 223 | Table/Structure Field |
DB2QISE - QISEFREE | Current number of free pages in the free chain | |
| 224 | Table/Structure Field |
DB2QISE - QISEKTG | Number of requests for package table sections | |
| 225 | Table/Structure Field |
DB2QISE - QISEKTL | Number of times a PT section was not found in EDM pool | |
| 226 | Table/Structure Field |
DB2QISE - QISEPAGE | Current number of pages in the EDM pool | |
| 227 | Table/Structure Field |
DB2QISJ - QISJFAIL | Field Type DEC, Length 10 | |
| 228 | Table/Structure Field |
DB2QISJ - QISJTRY | Field Type DEC, Length 10 | |
| 229 | Table/Structure Field |
DB2QIST - QISTRLLM | RDS limit exceeded | |
| 230 | Table/Structure Field |
DB2QIST - QISTRMAX | Process limit exceeded | |
| 231 | Table/Structure Field |
DB2QIST - QISTRPLM | Physical limit reached | |
| 232 | Table/Structure Field |
DB2QIST - QISTRSTG | RID list processing exhausted virtual storage | |
| 233 | Table/Structure Field |
DB2QJST - QJSTALR | Number of archive log read allocations | |
| 234 | Table/Structure Field |
DB2QJST - QJSTALW | Number of archive log write allocations | |
| 235 | Table/Structure Field |
DB2QJST - QJSTBFFL | Number of Active Log Output Control Intervals Created | |
| 236 | Table/Structure Field |
DB2QJST - QJSTBFWR | Number of calls to the log write routine | |
| 237 | Table/Structure Field |
DB2QJST - QJSTBSDS | Number of BSDS Access Requests | |
| 238 | Table/Structure Field |
DB2QJST - QJSTCIOF | Count of Control Intervals Offloaded | |
| 239 | Table/Structure Field |
DB2QJST - QJSTLAMA | Check Tape Mounts Attempted | |
| 240 | Table/Structure Field |
DB2QJST - QJSTLAMS | Successful "look ahead" (tape volume) mounts attempted | |
| 241 | Table/Structure Field |
DB2QJST - QJSTRACT | Number of Log Reads Satisfied from Active Log Data Set | |
| 242 | Table/Structure Field |
DB2QJST - QJSTRARH | Number of Log Reads Satisfied from Archive Log Data Set | |
| 243 | Table/Structure Field |
DB2QJST - QJSTRBUF | Number of Log Reads Satisfied from Output Buffer | |
| 244 | Table/Structure Field |
DB2QJST - QJSTTVC | Read accesses delayed due to tape volume contention | |
| 245 | Table/Structure Field |
DB2QJST - QJSTWRNW | Number of Write-No-Wait Requests | |
| 246 | Table/Structure Field |
DB2QJST - QJSTWRNWD | Number of Write-No-Wait Requests | |
| 247 | Table/Structure Field |
DB2QJST - QJSTWTB | Unavailable output log buffers | |
| 248 | Table/Structure Field |
DB2QJST - QJSTWUR | Read accesses delayed due to unavailable resource | |
| 249 | Table/Structure Field |
DB2QTGS - QTGSCHNP | P-Lock Change Request During P-Lock Negotiation | |
| 250 | Table/Structure Field |
DB2QTGS - QTGSCPLK | Number of Change Requests for P-Locks | |
| 251 | Table/Structure Field |
DB2QTGS - QTGSCSLM | No. of Change Requests Propagated to MVS XES Synchronously | |
| 252 | Table/Structure Field |
DB2QTGS - QTGSDRTA | Incompatible retained lock | |
| 253 | Table/Structure Field |
DB2QTGS - QTGSFLMG | False contention on z/OS image | |
| 254 | Table/Structure Field |
DB2QTGS - QTGSFLSE | Number of suspends because of false contentions | |
| 255 | Table/Structure Field |
DB2QTGS - QTGSIGLO | Number of suspends caused by IRLM global resource contention | |
| 256 | Table/Structure Field |
DB2QTGS - QTGSKIDS | Number of resources propagated by IRLM to MVS XES async. | |
| 257 | Table/Structure Field |
DB2QTGS - QTGSLPLK | Number of lock requests for P-locks | |
| 258 | Table/Structure Field |
DB2QTGS - QTGSLSLM | Number of lock requests propagated to MVS XES synchronously | |
| 259 | Table/Structure Field |
DB2QTGS - QTGSNTFR | Number of Notification Messages Received from Other Members | |
| 260 | Table/Structure Field |
DB2QTGS - QTGSNTFY | Number of Notification Messages Sent to Other Members | |
| 261 | Table/Structure Field |
DB2QTGS - QTGSOTPE | Other P-Lock Negotiation | |
| 262 | Table/Structure Field |
DB2QTGS - QTGSPEQW | Engines Unavailable for P-Lock/Notify Exits | |
| 263 | Table/Structure Field |
DB2QTGS - QTGSPGPE | Page P-Lock Negotiation | |
| 264 | Table/Structure Field |
DB2QTGS - QTGSPPPE | Page Set/Partition P-Lock Negotiation | |
| 265 | Table/Structure Field |
DB2QTGS - QTGSSGLO | Suspends caused by MVS XES global resource contention | |
| 266 | Table/Structure Field |
DB2QTGS - QTGSUPLK | Number of unlock requests for P-locks | |
| 267 | Table/Structure Field |
DB2QTGS - QTGSUSLM | Number of IRLM unlock requests propagated to MVS XES synch. | |
| 268 | Table/Structure Field |
DB2QTHDDSC - MEMBNM | DB2 member name in data sharing environment | |
| 269 | Table/Structure Field |
DB2QTST - QTABIND | Field Type INT, Length 4 | |
| 270 | Table/Structure Field |
DB2QTST - QTABINDA | Field Type INT, Length 4 | |
| 271 | Table/Structure Field |
DB2QTST - QTALLOC | Field Type INT, Length 4 | |
| 272 | Table/Structure Field |
DB2QTST - QTALLOCA | Field Type INT, Length 4 | |
| 273 | Table/Structure Field |
DB2QTST - QTAUCCH | Field Type INT, Length 4 | |
| 274 | Table/Structure Field |
DB2QTST - QTAUCHK | Field Type INT, Length 4 | |
| 275 | Table/Structure Field |
DB2QTST - QTAUPUB | Field Type INT, Length 4 | |
| 276 | Table/Structure Field |
DB2QTST - QTAUSUC | Field Type INT, Length 4 | |
| 277 | Table/Structure Field |
DB2QTST - QTAUTOBA | Field Type INT, Length 4 | |
| 278 | Table/Structure Field |
DB2QTST - QTBINDA | Field Type INT, Length 4 | |
| 279 | Table/Structure Field |
DB2QTST - QTBINDPA | Field Type INT, Length 4 | |
| 280 | Table/Structure Field |
DB2QTST - QTBINDPR | Field Type INT, Length 4 | |
| 281 | Table/Structure Field |
DB2QTST - QTBINDR | Field Type INT, Length 4 | |
| 282 | Table/Structure Field |
DB2QTST - QTDSDRN | Number of datasets that were closed via the DRAIN process | |
| 283 | Table/Structure Field |
DB2QTST - QTDSOPN | Number of datasets open concurrently | |
| 284 | Table/Structure Field |
DB2QTST - QTFREE | Field Type INT, Length 4 | |
| 285 | Table/Structure Field |
DB2QTST - QTFREEA | Field Type INT, Length 4 | |
| 286 | Table/Structure Field |
DB2QTST - QTFREEAP | Field Type INT, Length 4 | |
| 287 | Table/Structure Field |
DB2QTST - QTFREEP | Field Type INT, Length 4 | |
| 288 | Table/Structure Field |
DB2QTST - QTINVRID | Field Type INT, Length 4 | |
| 289 | Table/Structure Field |
DB2QTST - QTPCCT | No. of infrequently updated datasets conv. from R/W to R/O | |
| 290 | Table/Structure Field |
DB2QTST - QTPKABND | Field Type INT, Length 4 | |
| 291 | Table/Structure Field |
DB2QTST - QTPKALL | Field Type INT, Length 4 | |
| 292 | Table/Structure Field |
DB2QTST - QTPKALLA | Field Type INT, Length 4 | |
| 293 | Table/Structure Field |
DB2QTST - QTPKGBD | Field Type INT, Length 4 | |
| 294 | Table/Structure Field |
DB2QTST - QTPKGFRD | Field Type INT, Length 4 | |
| 295 | Table/Structure Field |
DB2QTST - QTPKGRBD | Field Type INT, Length 4 | |
| 296 | Table/Structure Field |
DB2QTST - QTPLNBD | Field Type INT, Length 4 | |
| 297 | Table/Structure Field |
DB2QTST - QTPLNFRD | Field Type INT, Length 4 | |
| 298 | Table/Structure Field |
DB2QTST - QTPLNRBD | Field Type INT, Length 4 | |
| 299 | Table/Structure Field |
DB2QTST - QTRBINDA | Field Type INT, Length 4 | |
| 300 | Table/Structure Field |
DB2QTST - QTRBNDPA | Field Type INT, Length 4 | |
| 301 | Table/Structure Field |
DB2QTST - QTREBIND | Field Type INT, Length 4 | |
| 302 | Table/Structure Field |
DB2QTST - QTREOPN | Number of times a previously unused dataset was used | |
| 303 | Table/Structure Field |
DB2QTST - QTSLWDD | Datasets not used, but not closed due to deferred close | |
| 304 | Table/Structure Field |
DB2QTST - QTTESTB | Field Type INT, Length 4 | |
| 305 | Table/Structure Field |
DB2QTXA - QTXACHG | Number of change requests | |
| 306 | Table/Structure Field |
DB2QTXA - QTXACLNO | Number of claim requests | |
| 307 | Table/Structure Field |
DB2QTXA - QTXACLUN | Number of claim requests that were unsuccessful | |
| 308 | Table/Structure Field |
DB2QTXA - QTXADEA | Number of deadlocks | |
| 309 | Table/Structure Field |
DB2QTXA - QTXADRNO | Number of drain requests | |
| 310 | Table/Structure Field |
DB2QTXA - QTXADRUN | Number of drain requests that were unsuccessful | |
| 311 | Table/Structure Field |
DB2QTXA - QTXAIRLM | Number of other requests | |
| 312 | Table/Structure Field |
DB2QTXA - QTXALES | Number of lock escalations (shared) | |
| 313 | Table/Structure Field |
DB2QTXA - QTXALEX | Number of lock escalations (exclusive) | |
| 314 | Table/Structure Field |
DB2QTXA - QTXALOCK | Number of lock requests | |
| 315 | Table/Structure Field |
DB2QTXA - QTXAQRY | Number of query requests | |
| 316 | Table/Structure Field |
DB2QTXA - QTXASLAT | Number of latch suspensions | |
| 317 | Table/Structure Field |
DB2QTXA - QTXASLOC | Number of lock suspensions | |
| 318 | Table/Structure Field |
DB2QTXA - QTXASOTH | Number of other suspensions | |
| 319 | Table/Structure Field |
DB2QTXA - QTXATIM | Number of timeouts | |
| 320 | Table/Structure Field |
DB2QTXA - QTXAUNLK | Number of unlock requests | |
| 321 | Table/Structure Field |
DB2QW0225 - STRGDATE | Field of type DATS | |
| 322 | Table/Structure Field |
DB2QW0225 - STRGTIME | Field of type TIMS | |
| 323 | Table/Structure Field |
DB2QWHS - QWHSSSID | Field type char, length 4 | |
| 324 | Table/Structure Field |
DB2QWP4 - QWP4DSMX | Field Type INT, Length 4 | |
| 325 | Table/Structure Field |
DB2QWP9 - QWP9CMST | Status of a DBAT | |
| 326 | Table/Structure Field |
DB2QWSD - QWSDARIR | DB2QWSD-QWSDARIR | |
| 327 | Table/Structure Field |
DB2QWSD - QWSDARSG | DB2QWSD-QWSDARSG | |
| 328 | Table/Structure Field |
DB2QWSD - QWSDARST | DB2QWSD-QWSDARST | |
| 329 | Table/Structure Field |
DB2QWSD - QWSDARTH | DB2QWSD-QWSDARTH | |
| 330 | Table/Structure Field |
DB2QWSD - QWSDCKPT | Number of checkpoints DB2 has taken since startup | |
| 331 | Table/Structure Field |
DB2QXST - GHITRATIO | Dynamic Statement Cache Global Hit Ratio | |
| 332 | Table/Structure Field |
DB2QXST - LHITRATIO | Dynamic Statement Cache Local Hit Ratio | |
| 333 | Table/Structure Field |
DB2QXST - PREPREQ | Number of Prepare Requests | |
| 334 | Table/Structure Field |
DB2QXST - QXALDAB | Number of ALTER DATABASE statements executed | |
| 335 | Table/Structure Field |
DB2QXST - QXALOCC | # of ALLOCATE CURSOR statements executed | |
| 336 | Table/Structure Field |
DB2QXST - QXALOCL | # of ASSOCIATE LOCATOR statements executed | |
| 337 | Table/Structure Field |
DB2QXST - QXALPRO | Number of ALTER PROCEDURE statements | |
| 338 | Table/Structure Field |
DB2QXST - QXALTCTX | alter trusted context | |
| 339 | Table/Structure Field |
DB2QXST - QXALTIX | Number of ALTER INDEX statements executed | |
| 340 | Table/Structure Field |
DB2QXST - QXALTST | Number of ALTER STORAGE GROUP statements executed | |
| 341 | Table/Structure Field |
DB2QXST - QXALTTA | Number of ALTER TABLE statements executed | |
| 342 | Table/Structure Field |
DB2QXST - QXALTTS | Number of ALTER TABLE SPACE statements executed | |
| 343 | Table/Structure Field |
DB2QXST - QXALUDF | Number of ALTER FUNCTION statements | |
| 344 | Table/Structure Field |
DB2QXST - QXCALL | Number of SQL CALL statements executed | |
| 345 | Table/Structure Field |
DB2QXST - QXCDIST | Number of CREATE DISTINCT TYPE statements | |
| 346 | Table/Structure Field |
DB2QXST - QXCLOSE | Number of CLOSE CURSOR statements executed | |
| 347 | Table/Structure Field |
DB2QXST - QXCMTON | Number of COMMENT ON statements executed | |
| 348 | Table/Structure Field |
DB2QXST - QXCON1 | Number of CONNECT TYPE 1 statements executed | |
| 349 | Table/Structure Field |
DB2QXST - QXCON2 | Number of CONNECT TYPE 2 statements executed | |
| 350 | Table/Structure Field |
DB2QXST - QXCRALS | Number of CREATE ALIAS statements executed | |
| 351 | Table/Structure Field |
DB2QXST - QXCRATB | Number of CREATE AUXILIARY TABLE statements | |
| 352 | Table/Structure Field |
DB2QXST - QXCRCTX | create trusted context | |
| 353 | Table/Structure Field |
DB2QXST - QXCRDAB | Number of CREATE DATABASE statements executed | |
| 354 | Table/Structure Field |
DB2QXST - QXCRGTT | # OF CREATE GLBL TEMP TABLE | |
| 355 | Table/Structure Field |
DB2QXST - QXCRINX | Number of CREATE INDEX statements executed | |
| 356 | Table/Structure Field |
DB2QXST - QXCRPRO | Number of CREATE PROCEDURE statements | |
| 357 | Table/Structure Field |
DB2QXST - QXCRROL | create role | |
| 358 | Table/Structure Field |
DB2QXST - QXCRSTG | Number of CREATE STORAGE GROUP statements executed | |
| 359 | Table/Structure Field |
DB2QXST - QXCRSYN | Number of CREATE SYNONYM statements executed | |
| 360 | Table/Structure Field |
DB2QXST - QXCRTAB | Number of CREATE TABLE statements executed | |
| 361 | Table/Structure Field |
DB2QXST - QXCRUDF | Number of CREATE FUNCTION statements | |
| 362 | Table/Structure Field |
DB2QXST - QXCTABS | Number of CREATE TABLE SPACE statements executed | |
| 363 | Table/Structure Field |
DB2QXST - QXCTRIG | Number of SQL CREATE TRIGGER statements | |
| 364 | Table/Structure Field |
DB2QXST - QXDDIST | Number of DROP DISTINCT TYPE statements | |
| 365 | Table/Structure Field |
DB2QXST - QXDEFVU | Number of CREATE VIEW statements executed | |
| 366 | Table/Structure Field |
DB2QXST - QXDEGBUF | Parallel groups fell to sequential due to storage shortage | |
| 367 | Table/Structure Field |
DB2QXST - QXDEGCUR | Parallel groups fell to sequential due to updatable cursor | |
| 368 | Table/Structure Field |
DB2QXST - QXDEGENC | Par.groups fell to sequ. due to unavailable enclave services | |
| 369 | Table/Structure Field |
DB2QXST - QXDEGESA | Par. groups fell to sequ. due to lack of ESA sort support | |
| 370 | Table/Structure Field |
DB2QXST - QXDELET | Number of DELETE statements executed | |
| 371 | Table/Structure Field |
DB2QXST - QXDESC | Number of DESCRIBE statements executed | |
| 372 | Table/Structure Field |
DB2QXST - QXDRPAL | Number of DROP ALIAS statements executed | |
| 373 | Table/Structure Field |
DB2QXST - QXDRPCTX | drop trusted context | |
| 374 | Table/Structure Field |
DB2QXST - QXDRPDB | Number of DROP DATABASE statements executed | |
| 375 | Table/Structure Field |
DB2QXST - QXDRPFN | Number of DROP UDF statements | |
| 376 | Table/Structure Field |
DB2QXST - QXDRPIX | Number of DROP INDEX statements executed | |
| 377 | Table/Structure Field |
DB2QXST - QXDRPPKG | Number of DROP PACKAGE statements executed | |
| 378 | Table/Structure Field |
DB2QXST - QXDRPPR | Number of DROP PROCEDURE statements | |
| 379 | Table/Structure Field |
DB2QXST - QXDRPROL | drop role | |
| 380 | Table/Structure Field |
DB2QXST - QXDRPST | Number of DROP STORAGE GROUP statements executed | |
| 381 | Table/Structure Field |
DB2QXST - QXDRPSY | Number of DROP SYNONYM statements executed | |
| 382 | Table/Structure Field |
DB2QXST - QXDRPTA | Number of DROP TABLE statements executed | |
| 383 | Table/Structure Field |
DB2QXST - QXDRPTR | Number of SQL DROP TRIGGER statements | |
| 384 | Table/Structure Field |
DB2QXST - QXDRPTS | Number of DROP TABLE SPACE statements executed | |
| 385 | Table/Structure Field |
DB2QXST - QXDRPVU | Number of DROP VIEW statements executed | |
| 386 | Table/Structure Field |
DB2QXST - QXDSCRTB | Number of DESCRIBE TABLE statements executed | |
| 387 | Table/Structure Field |
DB2QXST - QXFETCH | Number of FETCH statements executed | |
| 388 | Table/Structure Field |
DB2QXST - QXFREEL | Number of FREE LOCATOR statements | |
| 389 | Table/Structure Field |
DB2QXST - QXFULLP | Total number of prepares: full prepares + short prepares | |
| 390 | Table/Structure Field |
DB2QXST - QXGRANT | Number of GRANT statements executed | |
| 391 | Table/Structure Field |
DB2QXST - QXHOLDL | Number of HOLD LOCATOR statements | |
| 392 | Table/Structure Field |
DB2QXST - QXINSRT | Number of INSERT statements executed | |
| 393 | Table/Structure Field |
DB2QXST - QXLABON | Number of LABEL ON statements executed | |
| 394 | Table/Structure Field |
DB2QXST - QXLOCK | Number of LOCK TABLE statements executed | |
| 395 | Table/Structure Field |
DB2QXST - QXMERGE | # of times merge sql statement was executed | |
| 396 | Table/Structure Field |
DB2QXST - QXOPEN | Number of OPEN CURSOR statements executed | |
| 397 | Table/Structure Field |
DB2QXST - QXPREP | Number of PREPARE statements executed | |
| 398 | Table/Structure Field |
DB2QXST - QXREDGRP | Parallel groups: executed with reduced degree | |
| 399 | Table/Structure Field |
DB2QXST - QXREL | Number of RELEASE statements executed | |
| 400 | Table/Structure Field |
DB2QXST - QXREVOK | Number of REVOKE statements executed | |
| 401 | Table/Structure Field |
DB2QXST - QXRNIX | rename index | |
| 402 | Table/Structure Field |
DB2QXST - QXRNTAB | RENAME TABLE | |
| 403 | Table/Structure Field |
DB2QXST - QXSELECT | Number of SELECT statements executed | |
| 404 | Table/Structure Field |
DB2QXST - QXSETCDG | Number of SET CURRENT DEGREE statements executed | |
| 405 | Table/Structure Field |
DB2QXST - QXSETCON | Number of SET CONNECTION statements executed | |
| 406 | Table/Structure Field |
DB2QXST - QXSETCRL | Number of SET CURRENT RULES statements executed | |
| 407 | Table/Structure Field |
DB2QXST - QXSETHV | Number of SET HOST VARIABLE statements executed | |
| 408 | Table/Structure Field |
DB2QXST - QXSETPTH | Number of SQL SET CURRENT PATH statements | |
| 409 | Table/Structure Field |
DB2QXST - QXSETSQL | Number of SET CURRENT SQLID statements executed | |
| 410 | Table/Structure Field |
DB2QXST - QXSTDEXP | MAXKEEPD parameter exceeded | |
| 411 | Table/Structure Field |
DB2QXST - QXSTDINV | Statement invalidated | |
| 412 | Table/Structure Field |
DB2QXST - QXSTFND | Number of Times that DB2 Found the Statement in the Cache | |
| 413 | Table/Structure Field |
DB2QXST - QXSTIPRP | Number of implicit prepares | |
| 414 | Table/Structure Field |
DB2QXST - QXSTNFND | Number of times statement could not be found in cache | |
| 415 | Table/Structure Field |
DB2QXST - QXSTNPRP | Number of avoided prepares | |
| 416 | Table/Structure Field |
DB2QXST - QXTRTBL | # of times truncate table stmt was exec. | |
| 417 | Table/Structure Field |
DB2QXST - QXUPDTE | Number of UPDATE statements executed | |
| 418 | Table/Structure Field |
DB2QXST - REPREPRAT | Reprepare Ratio | |
| 419 | Table/Structure Field |
DB2QXST - SHORTPREP | Number of Short Prepares | |
| 420 | Table/Structure Field |
DB2RDI - QW0124ST | Statement ID | |
| 421 | Table/Structure Field |
DB2SUSCRN - REFDATE | Last refresh date | |
| 422 | Table/Structure Field |
DB2SUSCRN - REFTIME | Last refresh time | |
| 423 | Table/Structure Field |
DB2SUSCRN - RESDATE | Last reset date | |
| 424 | Table/Structure Field |
DB2SUSCRN - RESTIME | Time of last reset | |
| 425 | Table/Structure Field |
DB2SUSCRN - SAMPDATE | Date when sampling is taken | |
| 426 | Table/Structure Field |
DB2SUSCRN - SAMPMODUS | DB2 sample mode | |
| 427 | Table/Structure Field |
DB2SUSCRN - SAMPTIME | Time when sampling is taken | |
| 428 | Table/Structure Field |
DB2SUSCRN - SUBSYSID | DB2 subsystem ID | |
| 429 | Table/Structure Field |
DB2SUSCRN - TINTERVAL | Time interval of the data | |
| 430 | Table/Structure Field |
DB2SWPARM - BPACTPG | Maximum active pages across all the active buffer pools | |
| 431 | Table/Structure Field |
DB2SWPARM - BPACTPGNM | Buffer pool with maximum active pages | |
| 432 | Table/Structure Field |
DB2SWPARM - BPHITRAT | Random hit ratio | |
| 433 | Table/Structure Field |
DB2SWPARM - BPHITRATNM | Buffer pool which has the minimum hit ratio | |
| 434 | Table/Structure Field |
DB2SWPARM - BPHPCONC | Hiper pool concerns for any of the active buffer pools | |
| 435 | Table/Structure Field |
DB2SWPARM - BPNAME | Selected buffer pool | |
| 436 | Table/Structure Field |
DB2SWPARM - BPSHORT | Buffer pool shortage in any of the active buffer pools | |
| 437 | Table/Structure Field |
DB2SWPARM - BPSHORTNM | Buffer pool which has a buffer pool shortage | |
| 438 | Table/Structure Field |
DB2SWPARM - EPCTREQ | (CT requests - CT not in EDM pool) / CT requests | |
| 439 | Table/Structure Field |
DB2SWPARM - EPDBDREQ | (DBD requests - DBD not in EDM pool) / DBD requests | |
| 440 | Table/Structure Field |
DB2SWPARM - EPFULL | Total number of failures due to EDM pool being full | |
| 441 | Table/Structure Field |
DB2SWPARM - EPPGINUSE | Percentage of EDM pool pages currently in use | |
| 442 | Table/Structure Field |
DB2SWPARM - EPPTREQ | (PT requests - PT not in EDM pool) / PT requests | |
| 443 | Table/Structure Field |
DB2SWPARM - FCONTRATE | False contention rate | |
| 444 | Table/Structure Field |
DB2SWPARM - GCONTRATE | Global contention rate | |
| 445 | Table/Structure Field |
DB2SWPARM - HDSUBSYSID | DB2 subsystem ID | |
| 446 | Table/Structure Field |
DB2SWPARM - LGBUFWRACT | Output log buffer writes per active log control interval | |
| 447 | Table/Structure Field |
DB2SWPARM - LGLOGWRAT | Number of bytes in KB written for active log per sec | |
| 448 | Table/Structure Field |
DB2SWPARM - LKDEADLOCK | No. of deadlocks | |
| 449 | Table/Structure Field |
DB2SWPARM - LKSUSPENS | Number of suspensions of all kinds | |
| 450 | Table/Structure Field |
DB2SWPARM - LKTIMEOUT | Number of timeouts | |
| 451 | Table/Structure Field |
DB2SWPARM - LOCKESCAL | Total number of lock escalations | |
| 452 | Table/Structure Field |
DB2SWPARM - MAXKEEPEX | MAXKEEPD parameter exceeded | |
| 453 | Table/Structure Field |
DB2SWPARM - MCALTERCMD | Alter Bufferpool/Alter Group Bufferpool commands are issued | |
| 454 | Table/Structure Field |
DB2SWPARM - MCPARALRED | Degree of parallelism lower than planned | |
| 455 | Table/Structure Field |
DB2SWPARM - MCRIDLIST | Any of the RID list limits is reached | |
| 456 | Table/Structure Field |
DB2SWPARM - MCSTARTTRC | Start Trace command was issued | |
| 457 | Table/Structure Field |
DB2SWPARM - OCCUROPEDS | Percentage of currently open datasets | |
| 458 | Table/Structure Field |
DB2SWPARM - OCDEFCLOSE | Datasets closed because deferred close threshold is reached | |
| 459 | Table/Structure Field |
DB2SWPARM - OCDSINUSE | Number of datasets currently in use | |
| 460 | Table/Structure Field |
DB2SWPARM - PAGEINS | Page-ins per pages read | |
| 461 | Table/Structure Field |
DB2SWPARM - SATOTALDCL | Total number of Data Control Language statements | |
| 462 | Table/Structure Field |
DB2SWPARM - SATOTALDDL | Total number of Data Definition Language statements | |
| 463 | Table/Structure Field |
DB2SWPARM - SATOTALDML | Total number of Data Manipulation Language statements | |
| 464 | Table/Structure Field |
DB2SWPARM - SSCHECKPNT | No. of checkpoints | |
| 465 | Table/Structure Field |
DB2SWPARM - SSCOMMIT | The number of commits | |
| 466 | Table/Structure Field |
DB2SWPARM - SSROLLBACK | Number of rollbacks | |
| 467 | Table/Structure Field |
DB2SWPARM - TLOPTRATE | Locking optimization rate | |
| 468 | Table/Structure Field |
DB2SYSPARM - TOTPBP | Total primary buffer pools size (MB) | |
| 469 | Table/Structure Field |
DB2THREADS - ABAPREP | ABAP Program: Current Main Program | |
| 470 | Table/Structure Field |
DB2THREADS - ABORT | Total number of rollback requests | |
| 471 | Table/Structure Field |
DB2THREADS - ACE | Field type raw, length 8, 4 bytes | |
| 472 | Table/Structure Field |
DB2THREADS - ACTTIME | Activity time (Class 1 elapsed time) | |
| 473 | Table/Structure Field |
DB2THREADS - ADTHRSTA | Status of the thread | |
| 474 | Table/Structure Field |
DB2THREADS - ASHOST | Application server host name | |
| 475 | Table/Structure Field |
DB2THREADS - AUTHID | The authorization ID under which the transaction is running | |
| 476 | Table/Structure Field |
DB2THREADS - CONNID | The connection ID of the thread | |
| 477 | Table/Structure Field |
DB2THREADS - CONNNAME | DB2THREADS-CONNNAME | |
| 478 | Table/Structure Field |
DB2THREADS - CORRID | The correlation ID of the thread (IP address) | |
| 479 | Table/Structure Field |
DB2THREADS - CPUTIME | The accumulated home CPU time a thread spent in DB2 | |
| 480 | Table/Structure Field |
DB2THREADS - DBCOMMIT | The number of successful phase 2 or single-phase commits | |
| 481 | Table/Structure Field |
DB2THREADS - DBPLAN | DB2 plan name | |
| 482 | Table/Structure Field |
DB2THREADS - DS_MEMBER | DB2THREADS-DS_MEMBER | |
| 483 | Table/Structure Field |
DB2THREADS - ELTIME | Time elapsed since DB2 thread was started | |
| 484 | Table/Structure Field |
DB2THREADS - ENDUSER | DB2THREADS-ENDUSER | |
| 485 | Table/Structure Field |
DB2THREADS - FILLER | Field type char, length 8 | |
| 486 | Table/Structure Field |
DB2THREADS - GETPAGE | Number of Getpage Requests | |
| 487 | Table/Structure Field |
DB2THREADS - HDATDAT | Date when sampling is taken | |
| 488 | Table/Structure Field |
DB2THREADS - HDATTIM | Time when sampling is taken | |
| 489 | Table/Structure Field |
DB2THREADS - HDLRESTIME | Time of last reset | |
| 490 | Table/Structure Field |
DB2THREADS - HDSUBSYSID | DB2 subsystem ID | |
| 491 | Table/Structure Field |
DB2THREADS - J2EESERV | DB2THREADS-J2EESERV | |
| 492 | Table/Structure Field |
DB2THREADS - JOBNAME | The job name of the thread. | |
| 493 | Table/Structure Field |
DB2THREADS - LOCKMOD | The mode of the lock held on the resource | |
| 494 | Table/Structure Field |
DB2THREADS - LOCKS | The total number of currently hold locks. | |
| 495 | Table/Structure Field |
DB2THREADS - PRCINDB2 | Thread activity: % processing in DB2 | |
| 496 | Table/Structure Field |
DB2THREADS - PROCINDB2 | Percentage of time spent processing in DB2 | |
| 497 | Table/Structure Field |
DB2THREADS - QMDAPLAT | DB2THREADS-QMDAPLAT | |
| 498 | Table/Structure Field |
DB2THREADS - QWACPARR | DB2THREADS-QWACPARR | |
| 499 | Table/Structure Field |
DB2THREADS - QWHDRQNM | DB2THREADS-QWHDRQNM | |
| 500 | Table/Structure Field |
DB2THREADS - SAPSID | DB2THREADS-SAPSID |
