Statistics table (DMRSTATA): sections Q3ST through QLES
The following table describes the columns in the DMRSTATA and DMRSTASM tables.
Performance report column name | SMF field name | Data type | Used in report | Description |
|---|---|---|---|---|
DMRTABLEVERSION |
| CHAR(8) | NO | Version of DMR that created this table |
DMRVERSION |
| CHAR(8) | NO | Version of DMR that created this record |
SYSTEMID | SM100SID | CHAR(4) | NO | SMF system ID |
SUBSYSTEM | SM100SSI | CHAR(4) | NO | Db2 subsystem ID |
QWHS - Standard Header | ||||
DB2VERSION | QWHSRN | CHAR(6) | NO | Version of Db2 that generated this data |
INTERVAL |
| INTEGER | NO | Interval - only for summary |
TRANSCNT |
| INTEGER | NO | Trans count - used for summary |
IFCIDSEQ# | QWHSISEQ | INTEGER | NO | IFCID sequence number |
LOCATION | QWHSLOCN | CHAR(16) | NO | Local location name |
LOCATION_L | QWHSLOCN_Var | VARCHAR(128) | NO | Local location name (varchar) |
DATETIME | QWHSSTCK | TIMESTAMP | NO | Date and time statistics written |
DATE | QWHSSTCK | DATE | NO | Date record was created |
YEAR | QWHSSTCK | CHAR(4) | NO | Year record was created |
MONTH | QWHSSTCK | CHAR(2) | NO | Month record was created |
DAY | QWHSSTCK | CHAR(2) | NO | Day record was created |
TIME | QWHSSTCK | TIME | NO | Time record was created |
HOUR | QWHSSTCK | CHAR(2) | NO | Hour record was created |
DAYOFWEEK# | QWHSSTCK | SMALLINT | NO | Relative day of week, 1 to 7, where Monday=1 and Sunday=7 |
DAYOFWEEK | QWHSSTCK | CHAR(3) | NO | Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, and Sunday |
WEEK# | QWHSSTCK | INTEGER | NO | Week number relative to the 1 January 1900 epoch |
QWHA - Data Sharing | ||||
GROUPNAME | QWHADSGN | CHAR(8) | NO | Data sharing group name |
MEMBERNAME | QWHAMEMN | CHAR(8) | NO | Data sharing member name |
TRACEMASK | QWHSMTNX | INTEGER | NO | Active trace number mask |
DMRACSHARE |
| INTEGER | NO | DMR column used as marker during autocust |
DMRAUTOCUST |
| INTEGER | NO | DMR autocust marker for column only |
DMRAUTOLONG |
| INTEGER | NO | DMR autocust marker for column only |
Q3ST - Subsystem Services | ||||
Q3STABRT | Q3STABRT | INTEGER | NO | Count of unit of recovery backed out |
Q3STCOMM | Q3STCOMM | INTEGER | NO | Successful requests for commit phase 2 |
Q3STCTHD | Q3STCTHD | INTEGER | NO | Number of threads created |
Q3STCTHW | Q3STCTHW | INTEGER | NO | Number of create thread requests queued |
Q3STEXIT | Q3STEXIT | INTEGER | NO | Number of exit requests |
Q3STHWCT | Q3STHWCT | INTEGER | NO | HMW - CTHREAD threads |
Q3STHWIB | Q3STHWIB | INTEGER | NO | HMW- IDBACK threads |
Q3STHWIF | Q3STHWIF | INTEGER | NO | HMW - IDFORE threads |
Q3STIDEN | Q3STIDEN | INTEGER | NO | Successful identify requests |
Q3STINDT | Q3STINDT | INTEGER | NO | Total number of indoubt units of recovery |
Q3STMEOM | Q3STMEOM | INTEGER | NO | Subsystem allied memory end of memory |
Q3STMEOT | Q3STMEOT | INTEGER | NO | Subsystem allied memory end of task |
Q3STPREP | Q3STPREP | INTEGER | NO | Successful requests for commit phase 1 |
Q3STRDON | Q3STRDON | INTEGER | NO | Number of read-only commits |
Q3STRIUR | Q3STRIUR | INTEGER | NO | Successful resolve indoubt units of recovery requests |
Q3STSIGN | Q3STSIGN | INTEGER | NO | Successful sign-on requests |
Q3STSSSI | Q3STSSSI | INTEGER | NO | Number of SSI calls processed |
Q3STSYNC | Q3STSYNC | INTEGER | NO | Successful requests for sync commit |
Q3STTERM | Q3STTERM | INTEGER | NO | Successful term thread requests |
Q9ST - Description | ||||
Q9STCDMD | Q9STCDMD | INTEGER | NO | Modify DDF commands |
Q9STCTAD | Q9STCTAD | INTEGER | NO | Number of access database commands |
Q9STCTDA | Q9STCTDA | INTEGER | NO | Display accelerate commands |
Q9STCTDQ | Q9STCTDQ | INTEGER | NO | Number of start DYNQUERYCAPTURE commands |
Q9STCTEN | Q9STCTEN | INTEGER | NO | Activate new function commands |
Q9STCTR0 | Q9STCTR0 | INTEGER | NO | Number of display database commands |
Q9STCTR1 | Q9STCTR1 | INTEGER | NO | Number of display thread commands |
Q9STCTR2 | Q9STCTR2 | INTEGER | NO | Number of display utility commands |
Q9STCTR3 | Q9STCTR3 | INTEGER | NO | Number of recover BSDS commands |
Q9STCTR4 | Q9STCTR4 | INTEGER | NO | Number of recover indoubt commands |
Q9STCTR5 | Q9STCTR5 | INTEGER | NO | Number of start database commands |
Q9STCTR6 | Q9STCTR6 | INTEGER | NO | Number of start trace commands |
Q9STCTR7 | Q9STCTR7 | INTEGER | NO | Number of start Db2 commands |
Q9STCTR8 | Q9STCTR8 | INTEGER | NO | Number of stop database commands |
Q9STCTR9 | Q9STCTR9 | INTEGER | NO | Number of stop trace commands |
Q9STCTRA | Q9STCTRA | INTEGER | NO | Number of stop Db2 commands |
Q9STCTRB | Q9STCTRB | INTEGER | NO | Number of term utility commands |
Q9STCTRC | Q9STCTRC | INTEGER | NO | Number of display trace commands |
Q9STCTRD | Q9STCTRD | INTEGER | NO | Reset GENERICLU commands |
Q9STCTRE | Q9STCTRE | INTEGER | NO | Number of start RLIMIT commands |
Q9STCTRF | Q9STCTRF | INTEGER | NO | Number of stop RLIMIT commands |
Q9STCTRG | Q9STCTRG | INTEGER | NO | Number of display RLIMIT commands |
Q9STCTRH | Q9STCTRH | INTEGER | NO | Number of modify trace commands |
Q9STCTRI | Q9STCTRI | INTEGER | NO | Number of start DDF commands |
Q9STCTRJ | Q9STCTRJ | INTEGER | NO | Number of stop DDF commands |
Q9STCTRK | Q9STCTRK | INTEGER | NO | Number of cancel DDF thread commands |
Q9STCTRL | Q9STCTRL | INTEGER | NO | Number of display location commands |
Q9STCTRM | Q9STCTRM | INTEGER | NO | Number of archive log commands |
Q9STCTRN | Q9STCTRN | INTEGER | NO | Number of alter Buffer Pool commands |
Q9STCTRO | Q9STCTRO | INTEGER | NO | Number of display Buffer Pool commands |
Q9STCTRP | Q9STCTRP | INTEGER | NO | Number of set archive commands |
Q9STCTRQ | Q9STCTRQ | INTEGER | NO | Number of display archive commands |
Q9STCTRR | Q9STCTRR | INTEGER | NO | Number of reset indoubt commands |
Q9STCTRS | Q9STCTRS | INTEGER | NO | Alter Group Buffer Pool commands |
Q9STCTRT | Q9STCTRT | INTEGER | NO | Display Group Buffer Pool commands |
Q9STCTRU | Q9STCTRU | INTEGER | NO | Display procedure commands |
Q9STCTRV | Q9STCTRV | INTEGER | NO | Start procedure commands |
Q9STCTRW | Q9STCTRW | INTEGER | NO | Stop procedure commands |
Q9STCTRX | Q9STCTRX | INTEGER | NO | Display group commands |
Q9STCTRY | Q9STCTRY | INTEGER | NO | Alter utility commands |
Q9STCTRZ | Q9STCTRZ | INTEGER | NO | Number of display function commands |
Q9STCTSA | Q9STCTSA | INTEGER | NO | Start accelerate commands |
Q9STCTSD | Q9STCTSD | INTEGER | NO | Display profile commands |
Q9STCTSQ | Q9STCTSQ | INTEGER | NO | Number of stop DYNQUERYCAPTURE commands |
Q9STCTSS | Q9STCTSS | INTEGER | NO | Number of start SYSP commands |
Q9STCTST | Q9STCTST | INTEGER | NO | Number of stop SYSP commands |
Q9STCTX0 | Q9STCTX0 | INTEGER | NO | Number of start function commands |
Q9STCTX1 | Q9STCTX1 | INTEGER | NO | Number of stop function commands |
Q9STCTX2 | Q9STCTX2 | INTEGER | NO | Number of set log commands |
Q9STCTX3 | Q9STCTX3 | INTEGER | NO | Number of display log commands |
Q9STCTX4 | Q9STCTX4 | INTEGER | NO | Number of set SYSPARM commands |
Q9STCTX5 | Q9STCTX5 | INTEGER | NO | Number of display DDF commands |
Q9STCTXA | Q9STCTXA | INTEGER | NO | Stop accelerate commands |
Q9STCTXQ | Q9STCTXQ | INTEGER | NO | Number of display DYNQUERYCAPTURE commands |
Q9STEROR | Q9STEROR | INTEGER | NO | Number of unrecognized commands |
QBGL - Group Buffer Pool | ||||
QBGL2D | QBGL2D | BIGINT | NO | Duplexing delete name list requests |
QBGL2F | QBGL2F | BIGINT | NO | Duplexing failed requests - storage |
QBGL2H | QBGL2H | BIGINT | NO | Number of asynchronous IXLACACHE invocations - secondary Group Buffer Pool |
QBGL2N | QBGL2N | BIGINT | NO | Duplexing delete name requests |
QBGL2R | QBGL2R | BIGINT | NO | Duplexing read-castout-stats requests |
QBGL2S | QBGL2S | BIGINT | NO | Duplexing suspended requests |
QBGLAC | QBGLAC | BIGINT | NO | Group Buffer Pool clean pages written async |
QBGLAS | QBGLAS | BIGINT | NO | Number of IXLAXISN suspends waiting for |
QBGLAW | QBGLAW | BIGINT | NO | Group Buffer Pool changed pages written async |
QBGLAX | QBGLAX | BIGINT | NO | Requests to register page list in coupling facility |
QBGLAY | QBGLAY | BIGINT | NO | Number of coupling facility reads for changed page |
QBGLCC | QBGLCC | BIGINT | NO | Number of coupling facility read castout class requests |
QBGLCK | QBGLCK | BIGINT | NO | Number of Group Buffer Pool check points this member |
QBGLCM | QBGLCM | BIGINT | NO | Number of read for castout multiple (RFCOM) requests |
QBGLCR | QBGLCR | BIGINT | NO | Number of read for castout (RFCO) requests |
QBGLCS | QBGLCS | BIGINT | NO | Number of coupling facility read castout stats requests |
QBGLCT | QBGLCT | BIGINT | NO | Group Buffer Pool castout - class threshold |
QBGLDG | QBGLDG | BIGINT | NO | Number coupling facility page unregister requests |
QBGLDN | QBGLDN | BIGINT | NO | Number of Group Buffer Pool delete direct/data requests |
QBGLEX | QBGLEX | BIGINT | NO | Number of explicit cross invalidates |
QBGLFLG | QBGLFLG | BINARY(1) | NO | QBGLFLG |
QBGLGG | QBGLGG | BIGINT | NO | Getpages for Group Buffer Pool dependent pages |
QBGLGT | QBGLGT | BIGINT | NO | Group Buffer Pool castout - GBP threshold |
QBGLHS | QBGLHS | BIGINT | NO | Number of asynch IXLCACHE invocations - primary GBP |
QBGLMD | QBGLMD | BIGINT | NO | SCF reads - no page with data |
QBGLMR | QBGLMR | BIGINT | NO | SCF reads - no page without data |
QBGLN1 | QBGLN1 | BIGINT | NO | Number of page P-lock lock negotiations - space map pages |
QBGLN2 | QBGLN2 | BIGINT | NO | Number of page P-lock lock negotiations - data pages |
QBGLN3 | QBGLN3 | BIGINT | NO | Number of page P-lock lock negotiations - index leaf pages |
QBGLOS | QBGLOS | BIGINT | NO | Number of coupling facility read storage statistics requests |
QBGLP1 | QBGLP1 | BIGINT | NO | Number of page P-lock lock requests - space map pages |
QBGLP2 | QBGLP2 | BIGINT | NO | Number of page P-lock lock requests - data pages |
QBGLP3 | QBGLP3 | BIGINT | NO | Number of page P-lock lock requests - index leaf pages |
QBGLRC | QBGLRC | BIGINT | NO | Castout operations performed |
QBGLRD | QBGLRD | BIGINT | NO | Number of coupling facility read direct requests |
QBGLRG | QBGLRG | BIGINT | NO | Number of coupling facility page register requests |
QBGLS1 | QBGLS1 | BIGINT | NO | Number of page p-lock lock suspensions - space map pages |
QBGLS2 | QBGLS2 | BIGINT | NO | Number of page p-lock lock suspensions - data pages |
QBGLS3 | QBGLS3 | BIGINT | NO | Number of page p-lock lock suspensions - index leaf pages |
QBGLSU | QBGLSU | BIGINT | NO | Number of IXLAXISN synch-up calls |
QBGLSW | QBGLSW | BIGINT | NO | Group Buffer Pool changed pages written sync |
QBGLU1 | QBGLU1 | BIGINT | NO | Number of page p-lock unlock requests |
QBGLUN | QBGLUN | BIGINT | NO | Number of coupling facility unlock castout requests |
QBGLWA | QBGLWA | BIGINT | NO | Pages written in write around |
QBGLWC | QBGLWC | BIGINT | NO | Group Buffer Pool clean pages written sync |
QBGLWF | QBGLWF | BIGINT | NO | Coupling facility write not complete |
QBGLWM | QBGLWM | BIGINT | NO | Number of write and register multiple (warm) requests |
QBGLWP | QBGLWP | BIGINT | NO | Number of pages written via warm |
QBGLWS | QBGLWS | BIGINT | NO | Number of write and register (war) requests |
QBGLWX | QBGLWX | BIGINT | NO | Number of IXLCACHE requests with asynch |
QBGLXD | QBGLXD | BIGINT | NO | SCF reads - invalid buffer with data |
QBGLXR | QBGLXR | BIGINT | NO | SCF reads - invalid buffer without data |
QBST - Buffer Manager | ||||
QBSTAGET | QBSTAGET | BIGINT | NO | Overflow of total random getpages |
QBSTASGE | QBSTASGE | BIGINT | NO | Overflow of total sequential getpages |
QBSTASSE | QBSTASSE | BIGINT | NO | Overflow of total sync sequence read I/O |
QBSTASYN | QBSTASYN | BIGINT | NO | Overflow of total sync random read I/O |
QBSTCBA | QBSTCBA | BIGINT | NO | Number of current active buffers |
QBSTCIO | QBSTCIO | BIGINT | NO | Number of I/O on castout |
QBSTDIO | QBSTDIO | BIGINT | NO | Number of dynamic prefetch read I/O |
QBSTDMC | QBSTDMC | BIGINT | NO | Count data manager critical threshold. |
QBSTDPF | QBSTDPF | BIGINT | NO | Number of dynamic prefetch requested |
QBSTDPP | QBSTDPP | BIGINT | NO | Number of pages read - dynamic prefetch |
QBSTDSO | QBSTDSO | BIGINT | NO | Number of successful opens |
QBSTDWT | QBSTDWT | BIGINT | NO | Count of deferred write threshold |
QBSTDWV | QBSTDWV | BIGINT | NO | Vertical deferred write threshold reached |
QBSTGET | QBSTGET | BIGINT | NO | Number of get pages |
QBSTHST | QBSTHST | BIGINT | NO | Number of times length of sequential LRU chain reached sequential steal threshold (VPSEQT) |
QBSTIMW | QBSTIMW | BIGINT | NO | Number of sync writes |
QBSTJIS | QBSTJIS | BIGINT | NO | Prefetch I/O streams denied - buffer shortage |
QBSTLIO | QBSTLIO | BIGINT | NO | Number of list prefetch read I/O |
QBSTLPF | QBSTLPF | BIGINT | NO | List of prefetch requests |
QBSTLPL | QBSTLPL | BIGINT | NO | Number of times one or more pages added to LPL |
QBSTLPP | QBSTLPP | BIGINT | NO | Number of pages read - list prefetch |
QBSTMAX | QBSTMAX | BIGINT | NO | Maximum concurrent work file |
QBSTMIG | QBSTMIG | BIGINT | NO | Number of migrated data sets |
QBSTNGT | QBSTNGT | BIGINT | NO | Unsuccessful get page - conditional get page |
QBSTPCO | QBSTPCO | BIGINT | NO | Number of pages on unlock castout |
QBSTPIO | QBSTPIO | BIGINT | NO | Number of sequence prefetch read I/O |
QBSTPL1 | QBSTPL1 | BIGINT | NO | Occurrences of prefetch quantity decreased to half |
QBSTPL2 | QBSTPL2 | BIGINT | NO | Occurrences of prefetch quantity decreased to quarter |
QBSTPQF | QBSTPQF | BIGINT | NO | Number of I/O parallelism down graded - buffer shortage |
QBSTPQO | QBSTPQO | BIGINT | NO | Number BM/RDS negotiations for I/O parallelism |
QBSTPWS | QBSTPWS | BIGINT | NO | Number of pages written |
QBSTREE | QBSTREE | BIGINT | NO | Prefetch disabled, no read engine. |
QBSTRHS | QBSTRHS | BIGINT | NO | Number of random getpage buffer hits |
QBSTRIO | QBSTRIO | BIGINT | NO | Number of sync read I/O |
QBSTRPI | QBSTRPI | BIGINT | NO | Reads with paging |
QBSTRTO | QBSTRTO | BIGINT | NO | Number of recall timeout |
QBSTSEQ | QBSTSEQ | BIGINT | NO | Number of prefetch requests |
QBSTSGT | QBSTSGT | BIGINT | NO | Number of get page by sequential request |
QBSTSIO | QBSTSIO | BIGINT | NO | Number of sync read I/O by sequential request |
QBSTSMAX | QBSTSMIN | BIGINT | NO | Maximum number of buffers on sequential request |
QBSTSMIN | QBSTSMIN | BIGINT | NO | Minimum number of buffers on sequential request |
QBSTSPD | QBSTSPD | BIGINT | NO | Prefetch disabled, no buffers |
QBSTSPP | QBSTSPP | BIGINT | NO | Number of pages read for prefetch |
QBSTSWS | QBSTSWS | BIGINT | NO | Number of page updates |
QBSTVPA | QBSTVPA | BIGINT | NO | Number of successful virtual pool expansion/contraction |
QBSTVPL | QBSTVPL | BIGINT | NO | Number of buffers allocated for virtual pool |
QBSTWBVQ | QBSTWBVQ | BIGINT | NO | Number of pages dequeued from dataset deferred write queue destructive read request |
QBSTWDRP | QBSTWDRP | BIGINT | NO | Pages for destructive read |
QBSTWEE | QBSTWEE | BIGINT | NO | No write engine. Async write |
QBSTWFD | QBSTWFD | BIGINT | NO | Work files rejected no buffer |
QBSTWFF | QBSTWFF | BIGINT | NO | Merge passes with insufficient buffer |
QBSTWFM | QBSTWFM | BIGINT | NO | Maximum work file in merge |
QBSTWFR | QBSTWFR | BIGINT | NO | Number of merge passes |
QBSTWFT | QBSTWFT | BIGINT | NO | Total work files in merge |
QBSTWIO | QBSTWIO | BIGINT | NO | Number of async write I/O |
QBSTWKPD | QBSTWKPD | BIGINT | NO | Prefetch disabled, work file |
QBSTWPI | QBSTWPI | BIGINT | NO | Writes with paging |
QBSTXFL | QBSTXFL | BIGINT | NO | Number of get page failures due to Vpool full |
QBSTXFV | QBSTXFV | BIGINT | NO | Number of expansion failures due to shortage of virtual storage |
QBSTXIS | QBSTXIS | BIGINT | NO | Highest prefetch I/O streams allocated |
QDST - Distributed Data Facility | ||||
QDSTCIN2 | QDSTCIN2 | INTEGER | NO | Current number of type 2 inactive threads |
QDSTCNAT | QDSTCNAT | INTEGER | NO | Current active DBATs |
QDSTCSTR | QDSTCSTR | INTEGER | NO | Number of cold start connections |
QDSTHWAT | QDSTHWAT | INTEGER | NO | Maximum number of active DBATs |
QDSTHWDT | QDSTNITC | INTEGER | NO | Connections terminated - maximum type 1 inactive thread |
QDSTMADS | QDSTMADS | INTEGER | NO | Maximum active DBAT slots not in use |
QDSTMARD | QDSTMARD | INTEGER | NO | Maximum DBAT with release(deallocate) |
QDSTMIN2 | QDSTMIN2 | INTEGER | NO | Maximum number of type 2 inactive threads |
QDSTMQR2 | QDSTMQR2 | INTEGER | NO | Maximum type2 inactive threads queued |
QDSTNADS | QDSTNADS | INTEGER | NO | Number of Active DBATs slots not in use |
QDSTNARD | QDSTNARD | INTEGER | NO | Current DBATs with release (deallocate) |
QDSTNCCW | QDSTNCCW | INTEGER | NO | Number of queued client sockets closed (FACMCONQW) |
QDSTNCQC | QDSTNCQC | INTEGER | NO | Number of queued client sockets closed (MAXDBAT) |
QDSTNDBA | QDSTNDBA | INTEGER | NO | Number of DBATs created since DDF was started |
QDSTNITC | QDSTHWDT | INTEGER | NO | Maximum number of total DBATs |
QDSTNQAV | QDSTNQAV | DECIMAL(15, 6) | NO | Average queued connection wait time |
QDSTNQMN | QDSTNQMN | DECIMAL(15, 6) | NO | Minimum queued DBATs wait time |
QDSTNQMX | QDSTNQMX | DECIMAL(15, 6) | NO | Maximum queued DBATs wait time |
QDSTNQR2 | QDSTNQR2 | INTEGER | NO | Number of Type2 inactive threads queued |
QDSTPOOL | QDSTPOOL | INTEGER | NO | Number of request satisfied by assigning disconnected (pool) DBAT |
QDSTQCIT | QDSTQCIT | INTEGER | NO | Current number of DBAT |
QDSTQCRT | QDSTQCRT | INTEGER | NO | Number of conversations deallocated |
QDSTQDBT | QDSTQDBT | INTEGER | NO | Number of DBAT queued (Maximum reached) |
QDSTQIN2 | QDSTQIN2 | INTEGER | NO | Number of queued receive requests for type 2 inactive threads |
QDSTQMIT | QDSTQMIT | INTEGER | NO | Maximum number of inactive threads |
QDSTRSAT | QDSTRSAT | INTEGER | NO | Number of resync attempts |
QDSTRSSU | QDSTRSSU | INTEGER | NO | Number of resync succeeded |
QDSTWSTR | QDSTWSTR | INTEGER | NO | Number of warm start connections |
QISE - Description | ||||
QISECFAL | QISECFAL | INTEGER | NO | EDM pool statement cache below bar full |
QISECFRE | QISECFRE | INTEGER | NO | EDM pool statement cache below bar free pages |
QISECPGE | QISECPGE | INTEGER | NO | EDM pool statement cache below bar total pages |
QISECT | QISECT | INTEGER | NO | Number of pages used for CT below bar |
QISECTA | QISECTA | INTEGER | NO | Number of pages used for CT above bar |
QISECTG | QISECTG | INTEGER | NO | Number of requests for CT sections |
QISECTL | QISECTL | INTEGER | NO | Number of CT section loads |
QISEDBD | QISEDBD | INTEGER | NO | Number of pages used for DBD |
QISEDBDG | QISEDBDG | INTEGER | NO | Number of requests for DBD |
QISEDBDL | QISEDBDL | INTEGER | NO | Number of DBD loads |
QISEDFAL | QISEDFAL | INTEGER | NO | EDM DBD pool full |
QISEDFRE | QISEDFRE | INTEGER | NO | EDM DBD pool free pages |
QISEDLRU | QISEDLRU | INTEGER | NO | Total stealable DBD pages |
QISEDPGE | QISEDPGE | INTEGER | NO | EDM DBD pool total pages |
QISEDPSC | QISEDPSC | BIGINT | NO | Number of times possible row found |
QISEDPSF | QISEDPSF | BIGINT | NO | Number of times match found |
QISEDPSL | QISEDPSL | BIGINT | NO | Number of requests to look for DPS |
QISEDPSM | QISEDPSM | BIGINT | NO | Number of times match through text/bind opt |
QISEDSG | QISEDSG | INTEGER | NO | Number of requests to dynamic statement cache |
QISEDSI | QISEDSI | INTEGER | NO | Number of inserts into the dynamic statement cache |
QISEDYLRU | QISEDYLRU | INTEGER | NO | Total stealable DSC pages |
QISEDYNP | QISEDYNP | INTEGER | NO | EDM pool statement cache used pages |
QISEFAIL | QISEFAIL | INTEGER | NO | Number of failures - pool full |
QISEFREE | QISEFREE | INTEGER | NO | Number of EDM free pages |
QISEKFAL | QISECFAL | INTEGER | NO | Skeleton pool statement cache full |
QISEKFRE | QISEKFRE | INTEGER | NO | Skeleton pool statement cache free pages |
QISEKLRU | QISEKLRU | INTEGER | NO | Total stealable skeleton pages |
QISEKNFA | QISEKNFA | INTEGER | NO | Number of not-found record added to cache |
QISEKNFM | QISEKNFM | BIGINT | NO | Number of cached not-found record located |
QISEKNFR | QISEKNFR | INTEGER | NO | Number of not-found record removed from cache |
QISEKPGE | QISECPGE | INTEGER | NO | Skeleton pool statement cache total pages |
QISEKSPA | QISEKSPA | INTEGER | NO | Reserved |
QISEKSPA8 | QISEKSPA8 | BIGINT | NO | Storage allocated - shareable static SQL statements |
QISEKSPG | QISEKSPG | INTEGER | NO | Shareable static SQL requests |
QISEKT | QISEKTA | INTEGER | NO | Pages for package table below bar |
QISEKTA | QISEKTA | INTEGER | NO | Number of pages used in PT above bar |
QISEKTG | QISEKTG | INTEGER | NO | Package requests |
QISEKTL | QISEKTL | INTEGER | NO | Package loads |
QISESFAL | QISESFAL | INTEGER | NO | EDM pool statement cache above bar full |
QISESFRE | QISECFRE | INTEGER | NO | EDM pool statement cache above bar free pages |
QISESKCT | QISESKCT | INTEGER | NO | Number of pages used for SKCT |
QISESKPT | QISESKPT | INTEGER | NO | Skeleton package table pages |
QISESPGE | QISECPGE | INTEGER | NO | EDM pool statement cache above bar total pages |
QISESQCA | QISESQCA | BIGINT | NO | Storage allocated to plan ATB |
QISESQCB | QISESQCB | INTEGER | NO | Storage allocated to plan BTB |
QISESQKA | QISESQKA | BIGINT | NO | Storage allocated to package ATB |
QISESQKB | QISESQKB | INTEGER | NO | Storage allocated to package BTB |
QISESTMT | QISESTMT | INTEGER | NO | Number of statements in EDM pool |
QISJ - Star Join Pool | ||||
QISJFAIL | QISJFAIL | INTEGER | NO | Star join pool allocation failures |
QISJMAX | QISJMAX | INTEGER | NO | Star join pool maximum size |
QISJSIZE | QISJSIZE | INTEGER | NO | Star join pool size |
QISJTRY | QISJTRY | INTEGER | NO | Star join pool allocation requests |
QIST - Data Manager Control | ||||
QISTAMXU | QISTAMXU | BIGINT | NO | HWM work file database storage used by a thread |
QISTASTH | QISTASTH | INTEGER | NO | Agent work file database space usage alert threshold pct |
QISTCOLS | QISTCOLS | INTEGER | NO | Number of Columns invalid select encountered |
QISTCONDLKF | QISTCONDLKF | BIGINT | NO | Number of failed conditional lock req at insert |
QISTDGTTCTO | QISTDGTTCTO | BIGINT | NO | Total preferred storage for DGTTs in the work file database (KB) |
QISTDGTTMXU | QISTDGTTMXU | BIGINT | NO | HWM total DGTT agent storage (KB) |
QISTDGTTSTG | QISTDGTTSTG | BIGINT | NO | Total preferred storage for DGTTs in the work file database (KB) |
QISTFTBCAN | QISTFTBCAN | INTEGER | NO | Number of FTB index traverse count above thread |
QISTFTBCANT | QISTFTBCANT | INTEGER | NO | Number of index meeting FTB criteria |
QISTFTBNUMC | QISTFTBNUMC | INTEGER | NO | Number of FTB index current run memory optimization |
QISTFTBNUMP | QISTFTBNUMP | INTEGER | NO | Number of FTB index previous run memory optimization |
QISTFTBSIZE | QISTFTBSIZE | INTEGER | NO | Total memory allocated for FTB |
QISTI2AC | QISTI2AC | BIGINT | NO | Non-sort memory work files currently active |
QISTI2AH | QISTI2AH | BIGINT | NO | HWM non-sort memory work files active |
QISTI2OF | QISTI2OF | BIGINT | NO | Type 2 in memory work files overflowed |
QISTIMAC | QISTIMAC | BIGINT | NO | Current dm in memory work files active |
QISTIMAH | QISTIMAH | BIGINT | NO | HWM dm in memory work files active |
QISTIMNC | QISTIMNC | BIGINT | NO | In memory work files not created due to storage |
QISTIMSC | QISTIMSC | BIGINT | NO | Total space used for current in memory work files |
QISTIMSH | QISTIMSH | BIGINT | NO | HWM space used for current in memory work files |
QISTINPA | QISTINPA | BIGINT | NO | Number of fast insert pipes allocated |
QISTINPD | QISTINPD | BIGINT | NO | Number of fast insert pipes disabled |
QISTINPE | QISTINPE | INTEGER | NO | Number of times IAG2 pipe re-enable was successful |
QISTINPR | QISTINPR | INTEGER | NO | Number of times IAG2 pipe re-enable was attempted |
QISTLRCP | QISTLRCP | BIGINT | NO | CPU time |
QISTLRZE | QISTLRZE | BIGINT | NO | ZIIP eligible time |
QISTLRZI | QISTLRZI | BIGINT | NO | ZIIP time |
QISTRCCD | QISTRCCD | INTEGER | NO | Read currently committed delete |
QISTRCCI | QISTRCCI | INTEGER | NO | Read currently committed insert |
QISTRCCU | QISTRCCU | INTEGER | NO | Read currently committed update |
QISTRCUR | QISTRCUR | INTEGER | NO | Read current blocks allocated |
QISTRETRYLK | QISTRETRYLK | BIGINT | NO | Number of failed conditional lock request retired |
QISTRHIG | QISTRHIG | INTEGER | NO | RID high blocks allocated |
QISTRLLM | QISTRLLM | INTEGER | NO | RID term, greater RDS limit |
QISTRMAX | QISTRMAX | INTEGER | NO | RID term, too many at once |
QISTRPLM | QISTRPLM | INTEGER | NO | RID term, greater dm limit |
QISTRSTG | QISTRSTG | INTEGER | NO | RID term, no storage |
QISTSIAC | QISTSIAC | BIGINT | NO | Sort in memory work files currently active |
QISTSIAH | QISTSIAH | BIGINT | NO | HWM sort in memory work files currently active |
QISTSISC | QISTSISC | BIGINT | NO | Space used for sort in memory work files currently active |
QISTSISH | QISTSISH | BIGINT | NO | HWM space used for sort in memory work files |
QISTSSTH | QISTSSTH | INTEGER | NO | System work file database space usage alert threshold pct |
QISTTRAVMIN | QISTTRAVMIN | INTEGER | NO | Minimum FTB threshold |
QISTW04K | QISTW04K | INTEGER | NO | Total 4k tablespace storage used (KB) |
QISTW32K | QISTW32K | BIGINT | NO | Total 32k tablespace storage used (KB) |
QISTW4K | QISTW4K | BIGINT | NO | Current storage use in work file database |
QISTWCTO | QISTWCTO | BIGINT | NO | Current storage use in work file database |
QISTWF04 | QISTWF04 | INTEGER | NO | Total 4k tablespace storage used (MB) |
QISTWF32 | QISTWF32 | INTEGER | NO | Total 32k tablespace storage used (MB) |
QISTWFCK | QISTWFCK | INTEGER | NO | Work file Db current total storage used (KB) |
QISTWFCTO | QISTWFCTO | BIGINT | NO | Total system work file agent storage (KB) |
QISTWFCU | QISTWFCU | INTEGER | NO | Work file Db current total storage used (MB) |
QISTWFMU | QISTWFMU | INTEGER | NO | Work file Db maximum storage used (MB) |
QISTWFMX | QISTWFMX | INTEGER | NO | Maximum allowable storage per agent (MB) |
QISTWFMXU | QISTWFMXU | BIGINT | NO | HWM system work file agent storage (KB) |
QISTWFNE | QISTWFNE | INTEGER | NO | Number of times maximum allow storage per agent exceeded |
QISTWFP1 | QISTWFP1 | INTEGER | NO | Number of times 32k table space used when 4k preferred |
QISTWFP2 | QISTWFP2 | INTEGER | NO | Number of times 4k table space used when 32k preferred |
QISTWFRCUR | QISTWFRCUR | BIGINT | NO | Current RIDs stored in work files |
QISTWFRHIG | QISTWFRHIG | BIGINT | NO | HWM RIDs stored in work files |
QISTWFSTG | QISTWFSTG | BIGINT | NO | Total preferred work file storage in work file database (KB) |
QISTWMXA | QISTWMXA | BIGINT | NO | Maximum storage use per agent |
QISTWMXU | QISTWMXU | BIGINT | NO | Maximum storage use in work file database |
QISTWSTG | QISTWSTG | BIGINT | NO | Current total work file database storage used (KB) |
QJST - Log Manager | ||||
QJSTALR | QJSTALR | INTEGER | NO | Number of archive log read allocated |
QJSTALW | QJSTALW | INTEGER | NO | Number of archive log write allocated |
QJSTBFFL | QJSTBFFL | INTEGER | NO | Number of active log CI-s created |
QJSTBFWR | QJSTBFWR | INTEGER | NO | Number of calls to log write routine |
QJSTBPAG | QJSTBPAG | INTEGER | NO | Number of log write buffer paged-in before use |
QJSTBSDS | QJSTBSDS | INTEGER | NO | Number of BSDS access requests |
QJSTCIOF | QJSTCIOF | INTEGER | NO | Count of control intervals offloaded |
QJSTCIWR | QJSTCIWR | INTEGER | NO | Number of log CI-s written |
QJSTDPXN | QJSTDPXN | INTEGER | NO | Number of XES log writer suspends |
QJSTDPXT | QJSTDPXT | BIGINT | NO | XES log writer susp time (microseconds) |
QJSTLAMA | QJSTLAMA | INTEGER | NO | Number of look-ahead tape mounts attempted |
QJSTLAMS | QJSTLAMS | INTEGER | NO | Number of successful look-ahead tape mounts |
QJSTLOGW | QJSTLOGW | INTEGER | NO | Number of Log write I/O requests |
QJSTLSUS | QJSTLSUS | INTEGER | NO | (*) Serviceability |
QJSTRACT | QJSTRACT | INTEGER | NO | Number of log reads from active log |
QJSTRARH | QJSTRARH | INTEGER | NO | Number of log reads from archive log |
QJSTRBUF | QJSTRBUF | INTEGER | NO | Number of log reads from buffer |
QJSTSERW | QJSTSERW | INTEGER | NO | Number of serial log write request - CI rewrites when dual logging |
QJSTTHRW | QJSTTHRW | INTEGER | NO | Number of write request scheduled - log write threshold reached |
QJSTTVC | QJSTTVC | INTEGER | NO | Number of read accesses delayed / tape volume contention |
QJSTWRF | QJSTWRF | INTEGER | NO | Number of log write requests, force |
QJSTWRNW | QJSTWRNW | INTEGER | NO | Number of log write requests, nowait |
QJSTWTB | QJSTWTB | INTEGER | NO | Number of waits unavailable log buffer |
QJSTWUR | QJSTWUR | INTEGER | NO | Number of Read accesses delayed / unavailable resources |
QLES - Description | ||||
QLECREAT | QLECREAT | INTEGER | NO | (S) Number of LE token created |
QLELOW1M | QLELOW1M | INTEGER | NO | (S) Maximum storage below line committed LE token |
QLELOWEC | QLELOWEC | INTEGER | NO | (S) Storage below line committed - LE token |
QLELOWEM | QLELOWEM | INTEGER | NO | (S) Maximum storage below line - startup |
QLELOWIC | QLELOWIC | INTEGER | NO | (S) Storage below line committed - idle LE token |
QLELOWIM | QLELOWIM | INTEGER | NO | (S) Maximum storage below line committed idle LE token |
QLENTRDY | QLENTRDY | CHAR(16) | NO | (S) Number of time LE token not available |
QLENUMEC | QLENUMEC | INTEGER | NO | (S) Current number of LE tokens |
QLENUMEM | QLENUMEM | INTEGER | NO | (S) Maximum Number of LE tokens - startup |
QLENUMIC | QLENUMIC | INTEGER | NO | (S) Reserved |
QLENUMIM | QLENUMIM | INTEGER | NO | (S) Reserved |
QLESTG1M | QLESTG1M | INTEGER | NO | (S) Maximum storage above line committed LE token |
QLESTGEC | QLESTGEC | INTEGER | NO | (S) Storage above the line committed to LE token |
QLESTGEM | QLESTGEM | INTEGER | NO | (S) Maximum storage above the line - startup |
QLESTGIC | QLESTGIC | INTEGER | NO | (S) Storage above the line - committed |
QLESTGIM | QLESTGIM | INTEGER | NO | (S) Maximum storage above the line committed - LE token |
QLETIME | QLETIME | CHAR(16) | NO | (S) Time used for acquiring LE token - startup |
QLETIMEI | QLETIMEI | CHAR(16) | NO | (S) Time used for creating LE token |
QLETIMEM | QLETIMEM | CHAR(16) | NO | (S) Maximum time single token acquired - startup |
QLETIMET | QLETIMET | CHAR(16) | NO | (S) Time used for terminating LE token |
QLETIMEW | QLETIMEW | CHAR(16) | NO | (S) Serviceability |
QLETRMDL | QLETRMDL | INTEGER | NO | (S) Reserved |
QLETRMER | QLETRMER | INTEGER | NO | (S) Reserved |
QLETRMST | QLETRMST | INTEGER | NO | (S) Number of LE token terminated |
QLEUSED | QLEUSED | CHAR(16) | NO | (S) Number of times LE token acquired - startup |