Data Element list used by SAP ABAP Table DB2QBST (Buffer Manager Statistics Block)
SAP ABAP Table 
DB2QBST (Buffer Manager Statistics Block) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
 |
|
|||
| 1 |  Data Element |
CHAR1 | Single-Character Flag | |
| 2 | Data Element |
DB2BINUSE | Percentage of buffers currently in use | |
| 3 | Data Element |
DB2BSTBPNM | DB2 buffer pool name | |
| 4 | Data Element |
DB2BSTCBA | Number of currently active (non-stealable) buffers | |
| 5 | Data Element |
DB2BSTDIO | Number of dynamic prefetch reads | |
| 6 | Data Element |
DB2BSTDMC | Number of times the data manager threshold was reached | |
| 7 | Data Element |
DB2BSTDPF | Number of dynamic prefetch requests | |
| 8 | Data Element |
DB2BSTDPP | Number of pages read via dynamic prefetch read I/O | |
| 9 | Data Element |
DB2BSTDSO | Number of datasets successfully opened physically | |
| 10 | Data Element |
DB2BSTDWT | Number of times the deferred write threshold was reached | |
| 11 | Data Element |
DB2BSTDWV | Number of times vertical deferred write threshold is reached | |
| 12 | Data Element |
DB2BSTGET | Number of get page requests (conditional and unconditional) | |
| 13 | Data Element |
DB2BSTHITR | Buffer hit ratio | |
| 14 | Data Element |
DB2BSTIMW | Number of immediate writes | |
| 15 | Data Element |
DB2BSTJIS | Total number of denied concurrent prefetch I/O streams | |
| 16 | Data Element |
DB2BSTLIO | Number of list prefetch reads | |
| 17 | Data Element |
DB2BSTLPF | Number of list prefetch requests | |
| 18 | Data Element |
DB2BSTLPL | Number of times one or more pages were added to LPL | |
| 19 | Data Element |
DB2BSTLPP | Number of pages read via list prefetch | |
| 20 | Data Element |
DB2BSTMAX | Number of times a work file could not be opened | |
| 21 | Data Element |
DB2BSTMIG | Number of times migrated datasets were encountered | |
| 22 | Data Element |
DB2BSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | |
| 23 | Data Element |
DB2BSTPIO | Number of sequential prefetch reads | |
| 24 | Data Element |
DB2BSTPL1 | Prefetch quantity is reduced from normal to 50% | |
| 25 | Data Element |
DB2BSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | |
| 26 | Data Element |
DB2BSTPQF | The parallel query went into reduced or degenerated mode | |
| 27 | Data Element |
DB2BSTPQO | Total no. of requests for parallel query support | |
| 28 | Data Element |
DB2BSTPWS | Number of pages written | |
| 29 | Data Element |
DB2BSTREE | Sequential prefetch disabled - unavailable read engine | |
| 30 | Data Element |
DB2BSTRIO | Number of synchronous read I/O operations | |
| 31 | Data Element |
DB2BSTRPI | Number of page inserts required for read I/O | |
| 32 | Data Element |
DB2BSTRTO | Number of recall timeouts | |
| 33 | Data Element |
DB2BSTSEQ | Number of sequential prefetch requests | |
| 34 | Data Element |
DB2BSTSGT | Number of get page requests issued by sequential access req. | |
| 35 | Data Element |
DB2BSTSIO | Synchronous read requests issued by sequential access req. | |
| 36 | Data Element |
DB2BSTSPD | Sequential prefetch disabled - no buffers available | |
| 37 | Data Element |
DB2BSTSPP | Number of pages read because of normal sequential prefetch | |
| 38 | Data Element |
DB2BSTSWS | Update intents against pages in the buffer pool | |
| 39 | Data Element |
DB2BSTVPA | Number of successful virtual buffer pool expans./contract. | |
| 40 | Data Element |
DB2BSTVPL | Number of buffers allocated for virtual buffer pool | |
| 41 | Data Element |
DB2BSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | |
| 42 | Data Element |
DB2BSTWDRP | Number of pages for which destructive read was requested | |
| 43 | Data Element |
DB2BSTWEE | A write engine is unavailable for asynchronous write I/O | |
| 44 | Data Element |
DB2BSTWFD | Work file requests were rejected due to buffer pool shortage | |
| 45 | Data Element |
DB2BSTWFF | Number of times a merge pass could not be performed | |
| 46 | Data Element |
DB2BSTWFM | Maximum number of work files concurrently used | |
| 47 | Data Element |
DB2BSTWFR | Number of merge passes requested for DB2 sort activities | |
| 48 | Data Element |
DB2BSTWFT | Number of merge passes requested for DB2 sort activities | |
| 49 | Data Element |
DB2BSTWIO | Number of asynchronous writes | |
| 50 | Data Element |
DB2BSTWKPD | Number of work prefetches not scheduled due to zero prefetch | |
| 51 | Data Element |
DB2BSTWPI | Number of page inserts required for write I/O | |
| 52 | Data Element |
DB2BSTXFL | Number of times the virtual buffer pool was full | |
| 53 | Data Element |
DB2BSTXFV | Total number of virtual buffer pool or hiperpool failures | |
| 54 | Data Element |
DB2BSTXIS | Highest number of concurrent prefetch I/O streams | |
| 55 | Data Element |
DB2BUPDRAT | Buffer Update Rate | |
| 56 | Data Element |
DB2DBPVPTY | Type of virtual buffer pool | |
| 57 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 58 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 59 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 60 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 61 | Data Element |
DB2DEC19V | dec 19 with sign | |
| 62 | Data Element |
DB2GETPRAT | Number of Getpage Requests per Second | |
| 63 | Data Element |
DB2GETPRND | Number of Random Access Getpage Requests | |
| 64 | Data Element |
DB2NUMC10 | Field type numc, length 10, integer | |
| 65 | Data Element |
DB2PAGEIN | Number of page-ins | |
| 66 | Data Element |
DB2PGPDYNP | Number of Pages Read per Dynamic Prefetch Read | |
| 67 | Data Element |
DB2PGPLISP | Number of Pages Read per List Prefetch Read | |
| 68 | Data Element |
DB2PGPSEQP | Number of Pages Read per Sequential Prefetch Read | |
| 69 | Data Element |
DB2PREFDIS | Number of Times Sequential Prefetch Was Disabled | |
| 70 | Data Element |
DB2PWPWIO | Pages written per write I/O | |
| 71 | Data Element |
DB2READRAT | Read rate per second | |
| 72 | Data Element |
DB2RNDHITR | Random hit ratio | |
| 73 | Data Element |
DB2SIOSGT | Sync. seq. reads / seq. getpages | |
| 74 | Data Element |
DB2SWRTRATE | Sync writes / ( sync writes + async writes) | |
| 75 | Data Element |
DB2SYNRRND | Number of Random Access Synchronous Reads | |
| 76 | Data Element |
DB2UPPPWRI | Buffer update per pages written | |
| 77 | Data Element |
DB2VPSHORT | Number of Virtual Pool Shortages | |
| 78 | Data Element |
DB2WFNPDMP | Average Work Files Not Given per Degraded Merge Pass | |
| 79 | Data Element |
DB2WFPMRGP | Average Work Files per Merge Pass | |
| 80 | Data Element |
DB2WRITRAT | Write rate = ( Synchronous + async. writes ) / interval |
