| QBST |
|
STRU |
0 |
0 |
|
DB2QBST
|
|
| QBSTPID |
Field type numc, length 10, integer |
INT4 |
10 |
0 |
|
DB2NUMC10
|
|
| QBSTGET |
Number of get page requests (conditional and unconditional) |
DEC |
19 |
0 |
|
DB2BSTGET
|
|
| QBSTRIO |
Number of synchronous read I/O operations |
DEC |
19 |
0 |
|
DB2BSTRIO
|
|
| QBSTDWV |
Number of times vertical deferred write threshold is reached |
DEC |
19 |
0 |
|
DB2BSTDWV
|
|
| QBSTXFL |
Number of times the virtual buffer pool was full |
DEC |
19 |
0 |
|
DB2BSTXFL
|
|
| QBSTXFV |
Total number of virtual buffer pool or hiperpool failures |
DEC |
19 |
0 |
|
DB2BSTXFV
|
|
| QBSTSWS |
Update intents against pages in the buffer pool |
DEC |
19 |
0 |
|
DB2BSTSWS
|
|
| QBSTPWS |
Number of pages written |
DEC |
19 |
0 |
|
DB2BSTPWS
|
|
| QBSTWIO |
Number of asynchronous writes |
DEC |
19 |
0 |
|
DB2BSTWIO
|
|
| QBSTCBA |
Number of currently active (non-stealable) buffers |
DEC |
19 |
0 |
|
DB2BSTCBA
|
|
| QBSTRPI |
Number of page inserts required for read I/O |
DEC |
19 |
0 |
|
DB2BSTRPI
|
|
| QBSTWPI |
Number of page inserts required for write I/O |
DEC |
19 |
0 |
|
DB2BSTWPI
|
|
| QBSTDSO |
Number of datasets successfully opened physically |
DEC |
19 |
0 |
|
DB2BSTDSO
|
|
| QBSTIMW |
Number of immediate writes |
DEC |
19 |
0 |
|
DB2BSTIMW
|
|
| QBSTSEQ |
Number of sequential prefetch requests |
DEC |
19 |
0 |
|
DB2BSTSEQ
|
|
| QBSTSPP |
Number of pages read because of normal sequential prefetch |
DEC |
19 |
0 |
|
DB2BSTSPP
|
|
| QBSTSPD |
Sequential prefetch disabled - no buffers available |
DEC |
19 |
0 |
|
DB2BSTSPD
|
|
| QBSTREE |
Sequential prefetch disabled - unavailable read engine |
DEC |
19 |
0 |
|
DB2BSTREE
|
|
| QBSTWEE |
A write engine is unavailable for asynchronous write I/O |
DEC |
10 |
0 |
|
DB2BSTWEE
|
|
| QBSTDWT |
Number of times the deferred write threshold was reached |
DEC |
19 |
0 |
|
DB2BSTDWT
|
|
| QBSTDMC |
Number of times the data manager threshold was reached |
DEC |
19 |
0 |
|
DB2BSTDMC
|
|
| QBSTMIG |
Number of times migrated datasets were encountered |
DEC |
19 |
0 |
|
DB2BSTMIG
|
|
| QBSTRTO |
Number of recall timeouts |
DEC |
19 |
0 |
|
DB2BSTRTO
|
|
| QBSTPIO |
Number of sequential prefetch reads |
DEC |
19 |
0 |
|
DB2BSTPIO
|
|
| QBSTWKPD |
Number of work prefetches not scheduled due to zero prefetch |
DEC |
19 |
0 |
|
DB2BSTWKPD
|
|
| QBSTMAX |
Number of times a work file could not be opened |
DEC |
19 |
0 |
|
DB2BSTMAX
|
|
| QBSTWFM |
Maximum number of work files concurrently used |
DEC |
19 |
0 |
|
DB2BSTWFM
|
|
| QBSTWDRP |
Number of pages for which destructive read was requested |
DEC |
19 |
0 |
|
DB2BSTWDRP
|
|
| QBSTWBVQ |
Number of Pages Removed from the DWQ for Destructive Read |
DEC |
19 |
0 |
|
DB2BSTWBVQ
|
|
| QBSTWFR |
Number of merge passes requested for DB2 sort activities |
DEC |
19 |
0 |
|
DB2BSTWFR
|
|
| QBSTWFT |
Number of merge passes requested for DB2 sort activities |
DEC |
19 |
0 |
|
DB2BSTWFT
|
|
| QBSTWFD |
Work file requests were rejected due to buffer pool shortage |
DEC |
19 |
0 |
|
DB2BSTWFD
|
|
| QBSTWFF |
Number of times a merge pass could not be performed |
DEC |
19 |
0 |
|
DB2BSTWFF
|
|
| QBSTLPF |
Number of list prefetch requests |
DEC |
19 |
0 |
|
DB2BSTLPF
|
|
| QBSTDPF |
Number of dynamic prefetch requests |
DEC |
19 |
0 |
|
DB2BSTDPF
|
|
| QBSTVPA |
Number of successful virtual buffer pool expans./contract. |
DEC |
19 |
0 |
|
DB2BSTVPA
|
|
| QBSTVPL |
Number of buffers allocated for virtual buffer pool |
DEC |
19 |
0 |
|
DB2BSTVPL
|
|
| QBSTDPP |
Number of pages read via dynamic prefetch read I/O |
DEC |
19 |
0 |
|
DB2BSTDPP
|
|
| QBSTLPP |
Number of pages read via list prefetch |
DEC |
19 |
0 |
|
DB2BSTLPP
|
|
| QBSTDIO |
Number of dynamic prefetch reads |
DEC |
19 |
0 |
|
DB2BSTDIO
|
|
| QBSTLIO |
Number of list prefetch reads |
DEC |
19 |
0 |
|
DB2BSTLIO
|
|
| QBSTSGT |
Number of get page requests issued by sequential access req. |
DEC |
19 |
0 |
|
DB2BSTSGT
|
|
| QBSTSIO |
Synchronous read requests issued by sequential access req. |
DEC |
19 |
0 |
|
DB2BSTSIO
|
|
| QBSTNGT |
# of unsuccessful GETPAGE due conditional GETPAGE request |
DEC |
19 |
0 |
|
DB2BSTNGT
|
|
| QBSTXIS |
Highest number of concurrent prefetch I/O streams |
DEC |
19 |
0 |
|
DB2BSTXIS
|
|
| QBSTJIS |
Total number of denied concurrent prefetch I/O streams |
DEC |
19 |
0 |
|
DB2BSTJIS
|
|
| QBSTPQO |
Total no. of requests for parallel query support |
DEC |
19 |
0 |
|
DB2BSTPQO
|
|
| QBSTPQF |
The parallel query went into reduced or degenerated mode |
DEC |
19 |
0 |
|
DB2BSTPQF
|
|
| QBSTPL1 |
Prefetch quantity is reduced from normal to 50% |
DEC |
19 |
0 |
|
DB2BSTPL1
|
|
| QBSTPL2 |
Number of occurrences of prefetch quantity reduced 1/4 |
DEC |
19 |
0 |
|
DB2BSTPL2
|
|
| QBSTHITR |
Buffer hit ratio |
CHAR |
7 |
0 |
|
DB2BSTHITR
|
|
| QBSTBPNM |
DB2 buffer pool name |
CHAR |
8 |
0 |
|
DB2BSTBPNM
|
|
| MARK |
Single-Character Flag |
CHAR |
1 |
0 |
|
CHAR1
|
|
| RANDHITR |
Random hit ratio |
DEC |
5 |
2 |
|
DB2RNDHITR
|
|
| READRATE |
Read rate per second |
DEC |
20 |
0 |
|
DB2READRAT
|
|
| UPPPWRIT |
Buffer update per pages written |
DEC |
19 |
2 |
|
DB2UPPPWRI
|
|
| PWPWIO |
Pages written per write I/O |
DEC |
19 |
2 |
|
DB2PWPWIO
|
|
| WRITERATE |
Write rate = ( Synchronous + async. writes ) / interval |
DEC |
20 |
0 |
|
DB2WRITRAT
|
|
| BPTYPE |
Type of virtual buffer pool |
CHAR |
1 |
0 |
|
DB2DBPVPTY
|
|
| CURRINUSE |
Percentage of buffers currently in use |
DEC |
5 |
2 |
|
DB2BINUSE
|
|
| VPSHORT |
Number of Virtual Pool Shortages |
DEC |
20 |
0 |
|
DB2VPSHORT
|
|
| PREFDIS |
Number of Times Sequential Prefetch Was Disabled |
DEC |
20 |
0 |
|
DB2PREFDIS
|
|
| PAGEIN |
Number of page-ins |
DEC |
20 |
0 |
|
DB2PAGEIN
|
|
| GETPRAND |
Number of Random Access Getpage Requests |
DEC |
20 |
0 |
|
DB2GETPRND
|
|
| GETPRATE |
Number of Getpage Requests per Second |
DEC |
19 |
0 |
|
DB2GETPRAT
|
|
| SYNRRAND |
Number of Random Access Synchronous Reads |
DEC |
20 |
0 |
|
DB2SYNRRND
|
|
| PG_SEQPREF |
Number of Pages Read per Sequential Prefetch Read |
CHAR |
19 |
0 |
|
DB2PGPSEQP
|
|
| PG_LISPREF |
Number of Pages Read per List Prefetch Read |
CHAR |
19 |
0 |
|
DB2PGPLISP
|
|
| PG_DYNPREF |
Number of Pages Read per Dynamic Prefetch Read |
CHAR |
19 |
0 |
|
DB2PGPDYNP
|
|
| BUPDRATE |
Buffer Update Rate |
DEC |
19 |
0 |
|
DB2BUPDRAT
|
|
| WF_MERGE |
Average Work Files per Merge Pass |
DEC |
19 |
0 |
|
DB2WFPMRGP
|
|
| WFN_DEGMP |
Average Work Files Not Given per Degraded Merge Pass |
DEC |
19 |
0 |
|
DB2WFNPDMP
|
|
| QBSTLPL |
Number of times one or more pages were added to LPL |
DEC |
19 |
0 |
|
DB2BSTLPL
|
|
| SIOPERSGT |
Sync. seq. reads / seq. getpages |
DEC |
19 |
6 |
|
DB2SIOSGT
|
|
| SWRTRATE |
Sync writes / ( sync writes + async writes) |
DEC |
5 |
2 |
|
DB2SWRTRATE
|
|
| QBSTSMIN |
dec 19 with sign |
DEC |
19 |
0 |
|
DB2DEC19V
|
|
| QBSTSMAX |
dec 19 with sign |
DEC |
19 |
0 |
|
DB2DEC19V
|
|
| QBSTHST |
dec 19 with sign |
DEC |
19 |
0 |
|
DB2DEC19V
|
|
| QBSTRHS |
dec 19 with sign |
DEC |
19 |
0 |
|
DB2DEC19V
|
|
| QBSTNSG |
dec 19 with sign |
DEC |
19 |
0 |
|
DB2DEC19V
|
|
| QDBP |
|
STRU |
0 |
0 |
|
DB2QDBP
|
|
| QDBPNM |
Name of buffer pool |
CHAR |
8 |
0 |
|
DB2DBPNM
|
|
| QDBPVPSZ |
The size of the virtual buffer pool |
INT4 |
10 |
0 |
|
DB2DBPVPSZ
|
|
| QDBPVPSH |
The sequential steal threshold for the virtual buffer pool |
INT4 |
10 |
0 |
|
DB2DBPVPSH
|
|
| QDBPDWQT |
The deferred write threshold for the virtual buffer pool |
INT4 |
10 |
0 |
|
DB2DBPDWQT
|
|
| QDBPVDQT |
The vertical deferred write threshold for the virtual BP |
INT4 |
10 |
0 |
|
DB2DBPVDQT
|
|
| QDBPPSQT |
Parallel I/O sequential steal threshold for virtual BP |
INT4 |
10 |
0 |
|
DB2DBPPSQT
|
|
| QDBPXSQT |
Assisting parallel sequential threshold |
INT4 |
10 |
0 |
|
DB2DBPXSQT
|
|
| QDBPVPTY |
Type of virtual buffer pool |
CHAR |
1 |
0 |
|
DB2DBPVPTY
|
|
| QDBPVDQB |
Pool vertical write threshold in number of buffers |
INT2 |
5 |
0 |
|
DB2DBPVDQB
|
|
| QDBPPGST |
Page stealing algorithm to be used for the virtual BP |
CHAR |
4 |
0 |
|
DB2DBPPGST
|
|
| QDBPPFIX |
|
CHAR |
3 |
0 |
|
|
|
| QDBPFRAM |
|
CHAR |
2 |
0 |
|
|
|
| QDBPVPMI |
Field Type DEC, Length 10 |
DEC |
10 |
0 |
|
DB2DEC10
|
|
| QDBPVPMA |
Field Type DEC, Length 10 |
DEC |
10 |
0 |
|
DB2DEC10
|
|
| QDBPASIZ |
|
CHAR |
3 |
0 |
|
|
|