SAP Table DB2QBSTT
DB2 CL - Buffer manager statitics block
DB2QBSTT (DB2 CL - Buffer manager statitics block) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB2QBSTT to other SAP tables.
DB2QBSTT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MEMBNM | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | 0 | |||
| QBSTBPNM | DB2 buffer pool name | DB2BSTBPNM | CHAR | 8 | 0 | |||
| QBSTPID | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 10 | 0 | |||
| QBSTGET | Number of get page requests (conditional and unconditional) | DB2BSTGET | DEC | 19 | 0 | |||
| QBSTRIO | Number of synchronous read I/O operations | DB2BSTRIO | DEC | 19 | 0 | |||
| QBSTDWV | Number of times vertical deferred write threshold is reached | DB2BSTDWV | DEC | 19 | 0 | |||
| QBSTXFL | Number of times the virtual buffer pool was full | DB2BSTXFL | DEC | 19 | 0 | |||
| QBSTXFV | Total number of virtual buffer pool or hiperpool failures | DB2BSTXFV | DEC | 19 | 0 | |||
| QBSTSWS | Update intents against pages in the buffer pool | DB2BSTSWS | DEC | 19 | 0 | |||
| QBSTPWS | Number of pages written | DB2BSTPWS | DEC | 19 | 0 | |||
| QBSTWIO | Number of asynchronous writes | DB2BSTWIO | DEC | 19 | 0 | |||
| QBSTCBA | Number of currently active (non-stealable) buffers | DB2BSTCBA | DEC | 19 | 0 | |||
| QBSTRPI | Number of page inserts required for read I/O | DB2BSTRPI | DEC | 19 | 0 | |||
| QBSTWPI | Number of page inserts required for write I/O | DB2BSTWPI | DEC | 19 | 0 | |||
| QBSTDSO | Number of datasets successfully opened physically | DB2BSTDSO | DEC | 19 | 0 | |||
| QBSTIMW | Number of immediate writes | DB2BSTIMW | DEC | 19 | 0 | |||
| QBSTSEQ | Number of sequential prefetch requests | DB2BSTSEQ | DEC | 19 | 0 | |||
| QBSTSPP | Number of pages read because of normal sequential prefetch | DB2BSTSPP | DEC | 19 | 0 | |||
| QBSTSPD | Sequential prefetch disabled - no buffers available | DB2BSTSPD | DEC | 19 | 0 | |||
| QBSTREE | Sequential prefetch disabled - unavailable read engine | DB2BSTREE | DEC | 19 | 0 | |||
| QBSTWEE | A write engine is unavailable for asynchronous write I/O | DB2BSTWEE | DEC | 10 | 0 | |||
| QBSTDWT | Number of times the deferred write threshold was reached | DB2BSTDWT | DEC | 19 | 0 | |||
| QBSTDMC | Number of times the data manager threshold was reached | DB2BSTDMC | DEC | 19 | 0 | |||
| QBSTMIG | Number of times migrated datasets were encountered | DB2BSTMIG | DEC | 19 | 0 | |||
| QBSTRTO | Number of recall timeouts | DB2BSTRTO | DEC | 19 | 0 | |||
| QBSTPIO | Number of sequential prefetch reads | DB2BSTPIO | DEC | 19 | 0 | |||
| QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | DB2BSTWKPD | DEC | 19 | 0 | |||
| QBSTMAX | Number of times a work file could not be opened | DB2BSTMAX | DEC | 19 | 0 | |||
| QBSTWFM | Maximum number of work files concurrently used | DB2BSTWFM | DEC | 19 | 0 | |||
| QBSTWDRP | Number of pages for which destructive read was requested | DB2BSTWDRP | DEC | 19 | 0 | |||
| QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | DB2BSTWBVQ | DEC | 19 | 0 | |||
| QBSTWFR | Number of merge passes requested for DB2 sort activities | DB2BSTWFR | DEC | 19 | 0 | |||
| QBSTWFT | Number of merge passes requested for DB2 sort activities | DB2BSTWFT | DEC | 19 | 0 | |||
| QBSTWFD | Work file requests were rejected due to buffer pool shortage | DB2BSTWFD | DEC | 19 | 0 | |||
| QBSTWFF | Number of times a merge pass could not be performed | DB2BSTWFF | DEC | 19 | 0 | |||
| QBSTLPF | Number of list prefetch requests | DB2BSTLPF | DEC | 19 | 0 | |||
| QBSTDPF | Number of dynamic prefetch requests | DB2BSTDPF | DEC | 19 | 0 | |||
| QBSTVPA | Number of successful virtual buffer pool expans./contract. | DB2BSTVPA | DEC | 19 | 0 | |||
| QBSTVPL | Number of buffers allocated for virtual buffer pool | DB2BSTVPL | DEC | 19 | 0 | |||
| QBSTDPP | Number of pages read via dynamic prefetch read I/O | DB2BSTDPP | DEC | 19 | 0 | |||
| QBSTLPP | Number of pages read via list prefetch | DB2BSTLPP | DEC | 19 | 0 | |||
| QBSTDIO | Number of dynamic prefetch reads | DB2BSTDIO | DEC | 19 | 0 | |||
| QBSTLIO | Number of list prefetch reads | DB2BSTLIO | DEC | 19 | 0 | |||
| QBSTSGT | Number of get page requests issued by sequential access req. | DB2BSTSGT | DEC | 19 | 0 | |||
| QBSTSIO | Synchronous read requests issued by sequential access req. | DB2BSTSIO | DEC | 19 | 0 | |||
| QBSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | DB2BSTNGT | DEC | 19 | 0 | |||
| QBSTXIS | Highest number of concurrent prefetch I/O streams | DB2BSTXIS | DEC | 19 | 0 | |||
| QBSTJIS | Total number of denied concurrent prefetch I/O streams | DB2BSTJIS | DEC | 19 | 0 | |||
| QBSTPQO | Total no. of requests for parallel query support | DB2BSTPQO | DEC | 19 | 0 | |||
| QBSTPQF | The parallel query went into reduced or degenerated mode | DB2BSTPQF | DEC | 19 | 0 | |||
| QBSTPL1 | Prefetch quantity is reduced from normal to 50% | DB2BSTPL1 | DEC | 19 | 0 | |||
| QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | DB2BSTPL2 | DEC | 19 | 0 | |||
| QBSTLPL | Number of times one or more pages were added to LPL | DB2BSTLPL | DEC | 19 | 0 | |||
