DB2QBSTT SAP (DB2 CL - Buffer manager statitics block) Structure details
Description: DB2 CL - Buffer manager statitics block
Structure field list including key, data, relationships and ABAP select examples
DB2QBSTT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "DB2 CL - Buffer manager statitics block" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_DB2QBSTT TYPE DB2QBSTT.
The DB2QBSTT table consists of various fields, each holding specific information or linking keys about DB2 CL - Buffer manager statitics block data available in SAP. These include QBSTBPNM (DB2 buffer pool name), QBSTPID (Field type numc, length 10, integer), QBSTGET (Number of get page requests (conditional and unconditional)), QBSTRIO (Number of synchronous read I/O operations).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP DB2QBSTT structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MEMBNM | DB2 member name in data sharing environment | DB2MEMN | CHAR | 8 | DB2CHAR08 | ||||
QBSTBPNM | DB2 buffer pool name | DB2BSTBPNM | CHAR | 8 | DB2BPNAME | ||||
QBSTPID | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 10 | DB2INT4 | ||||
QBSTGET | Number of get page requests (conditional and unconditional) | DB2BSTGET | DEC | 19 | DB2DEC19V | ||||
QBSTRIO | Number of synchronous read I/O operations | DB2BSTRIO | DEC | 19 | DB2DEC19V | ||||
QBSTDWV | Number of times vertical deferred write threshold is reached | DB2BSTDWV | DEC | 19 | DB2DEC19V | ||||
QBSTXFL | Number of times the virtual buffer pool was full | DB2BSTXFL | DEC | 19 | DB2DEC19V | ||||
QBSTXFV | Total number of virtual buffer pool or hiperpool failures | DB2BSTXFV | DEC | 19 | DB2DEC19V | ||||
QBSTSWS | Update intents against pages in the buffer pool | DB2BSTSWS | DEC | 19 | DB2DEC19V | ||||
QBSTPWS | Number of pages written | DB2BSTPWS | DEC | 19 | DB2DEC19V | ||||
QBSTPWS | Number of pages written | DB2BSTPWS | DEC | 19 | DB2DEC19V | ||||
QBSTWIO | Number of asynchronous writes | DB2BSTWIO | DEC | 19 | DB2DEC19V | ||||
QBSTCBA | Number of currently active (non-stealable) buffers | DB2BSTCBA | DEC | 19 | DB2DEC19V | ||||
QBSTRES2 | Field Type INT, Length 4 | DB2INT4 | INT4 | 10 | DB2INT4 | ||||
QBSTRPI | Number of page inserts required for read I/O | DB2BSTRPI | DEC | 19 | DB2DEC19V | ||||
QBSTWIO | Number of asynchronous writes | DB2BSTWIO | DEC | 19 | DB2DEC19V | ||||
QBSTCBA | Number of currently active (non-stealable) buffers | DB2BSTCBA | DEC | 19 | DB2DEC19V | ||||
QBSTWPI | Number of page inserts required for write I/O | DB2BSTWPI | DEC | 19 | DB2DEC19V | ||||
QBSTDSO | Number of datasets successfully opened physically | DB2BSTDSO | DEC | 19 | DB2DEC19V | ||||
QBSTRPI | Number of page inserts required for read I/O | DB2BSTRPI | DEC | 19 | DB2DEC19V | ||||
QBSTIMW | Number of immediate writes | DB2BSTIMW | DEC | 19 | DB2DEC19V | ||||
QBSTWPI | Number of page inserts required for write I/O | DB2BSTWPI | DEC | 19 | DB2DEC19V | ||||
QBSTDSO | Number of datasets successfully opened physically | DB2BSTDSO | DEC | 19 | DB2DEC19V | ||||
QBSTSEQ | Number of sequential prefetch requests | DB2BSTSEQ | DEC | 19 | DB2DEC19V | ||||
QBSTIMW | Number of immediate writes | DB2BSTIMW | DEC | 19 | DB2DEC19V | ||||
QBSTSPP | Number of pages read because of normal sequential prefetch | DB2BSTSPP | DEC | 19 | DB2DEC19V | ||||
QBSTSEQ | Number of sequential prefetch requests | DB2BSTSEQ | DEC | 19 | DB2DEC19V | ||||
QBSTSPD | Sequential prefetch disabled - no buffers available | DB2BSTSPD | DEC | 19 | DB2DEC19V | ||||
QBSTREE | Sequential prefetch disabled - unavailable read engine | DB2BSTREE | DEC | 19 | DB2DEC19V | ||||
QBSTSPP | Number of pages read because of normal sequential prefetch | DB2BSTSPP | DEC | 19 | DB2DEC19V | ||||
QBSTSPD | Sequential prefetch disabled - no buffers available | DB2BSTSPD | DEC | 19 | DB2DEC19V | ||||
QBSTWEE | A write engine is unavailable for asynchronous write I/O | DB2BSTWEE | DEC | 10 | DB2DEC10V | ||||
QBSTDWT | Number of times the deferred write threshold was reached | DB2BSTDWT | DEC | 19 | DB2DEC19V | ||||
QBSTREE | Sequential prefetch disabled - unavailable read engine | DB2BSTREE | DEC | 19 | DB2DEC19V | ||||
QBSTDMC | Number of times the data manager threshold was reached | DB2BSTDMC | DEC | 19 | DB2DEC19V | ||||
QBSTWEE | A write engine is unavailable for asynchronous write I/O | DB2BSTWEE | DEC | 10 | DB2DEC10V | ||||
QBSTDWT | Number of times the deferred write threshold was reached | DB2BSTDWT | DEC | 19 | DB2DEC19V | ||||
QBSTMIG | Number of times migrated datasets were encountered | DB2BSTMIG | DEC | 19 | DB2DEC19V | ||||
QBSTDMC | Number of times the data manager threshold was reached | DB2BSTDMC | DEC | 19 | DB2DEC19V | ||||
QBSTRTO | Number of recall timeouts | DB2BSTRTO | DEC | 19 | DB2DEC19V | ||||
QBSTMIG | Number of times migrated datasets were encountered | DB2BSTMIG | DEC | 19 | DB2DEC19V | ||||
QBSTPIO | Number of sequential prefetch reads | DB2BSTPIO | DEC | 19 | DB2DEC19V | ||||
QBSTRTO | Number of recall timeouts | DB2BSTRTO | DEC | 19 | DB2DEC19V | ||||
QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | DB2BSTWKPD | DEC | 19 | DB2DEC19V | ||||
QBSTMAX | Number of times a work file could not be opened | DB2BSTMAX | DEC | 19 | DB2DEC19V | ||||
QBSTPIO | Number of sequential prefetch reads | DB2BSTPIO | DEC | 19 | DB2DEC19V | ||||
QBSTWFM | Maximum number of work files concurrently used | DB2BSTWFM | DEC | 19 | DB2DEC19V | ||||
QBSTWKPD | Number of work prefetches not scheduled due to zero prefetch | DB2BSTWKPD | DEC | 19 | DB2DEC19V | ||||
QBSTMAX | Number of times a work file could not be opened | DB2BSTMAX | DEC | 19 | DB2DEC19V | ||||
QBSTWDRP | Number of pages for which destructive read was requested | DB2BSTWDRP | DEC | 19 | DB2DEC19V | ||||
QBSTWFM | Maximum number of work files concurrently used | DB2BSTWFM | DEC | 19 | DB2DEC19V | ||||
QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | DB2BSTWBVQ | DEC | 19 | DB2DEC19V | ||||
QBSTWFR | Number of merge passes requested for DB2 sort activities | DB2BSTWFR | DEC | 19 | DB2DEC19V | ||||
QBSTWDRP | Number of pages for which destructive read was requested | DB2BSTWDRP | DEC | 19 | DB2DEC19V | ||||
QBSTWFT | Number of merge passes requested for DB2 sort activities | DB2BSTWFT | DEC | 19 | DB2DEC19V | ||||
QBSTWBVQ | Number of Pages Removed from the DWQ for Destructive Read | DB2BSTWBVQ | DEC | 19 | DB2DEC19V | ||||
QBSTWFD | Work file requests were rejected due to buffer pool shortage | DB2BSTWFD | DEC | 19 | DB2DEC19V | ||||
QBSTWFR | Number of merge passes requested for DB2 sort activities | DB2BSTWFR | DEC | 19 | DB2DEC19V | ||||
QBSTWFF | Number of times a merge pass could not be performed | DB2BSTWFF | DEC | 19 | DB2DEC19V | ||||
QBSTWFT | Number of merge passes requested for DB2 sort activities | DB2BSTWFT | DEC | 19 | DB2DEC19V | ||||
QBSTLPF | Number of list prefetch requests | DB2BSTLPF | DEC | 19 | DB2DEC19V | ||||
QBSTWFD | Work file requests were rejected due to buffer pool shortage | DB2BSTWFD | DEC | 19 | DB2DEC19V | ||||
QBSTDPF | Number of dynamic prefetch requests | DB2BSTDPF | DEC | 19 | DB2DEC19V | ||||
QBSTWFF | Number of times a merge pass could not be performed | DB2BSTWFF | DEC | 19 | DB2DEC19V | ||||
QBSTLPF | Number of list prefetch requests | DB2BSTLPF | DEC | 19 | DB2DEC19V | ||||
QBSTVPA | Number of successful virtual buffer pool expans./contract. | DB2BSTVPA | DEC | 19 | DB2DEC19V | ||||
QBSTDPF | Number of dynamic prefetch requests | DB2BSTDPF | DEC | 19 | DB2DEC19V | ||||
QBSTVPL | Number of buffers allocated for virtual buffer pool | DB2BSTVPL | DEC | 19 | DB2DEC19V | ||||
QBSTDPP | Number of pages read via dynamic prefetch read I/O | DB2BSTDPP | DEC | 19 | DB2DEC19V | ||||
QBSTVPA | Number of successful virtual buffer pool expans./contract. | DB2BSTVPA | DEC | 19 | DB2DEC19V | ||||
QBSTHPA | Number of successful hiperpool expansions/contractions | DB2BSTHPA | DEC | 10 | DEC_10 | ||||
QBSTLPP | Number of pages read via list prefetch | DB2BSTLPP | DEC | 19 | DB2DEC19V | ||||
QBSTDIO | Number of dynamic prefetch reads | DB2BSTDIO | DEC | 19 | DB2DEC19V | ||||
QBSTHRE | Number of successful hiperpool reads | DB2BSTHRE | DEC | 10 | DEC_10 | ||||
QBSTHRA | Number of successful hiperpool reads done asynchronously | DB2BSTHRA | DEC | 10 | DEC_10 | ||||
QBSTLIO | Number of list prefetch reads | DB2BSTLIO | DEC | 19 | DB2DEC19V | ||||
QBSTHRF | Number of unsuccessful hiperpool reads | DB2BSTHRF | DEC | 10 | DEC_10 | ||||
QBSTSGT | Number of get page requests issued by sequential access req. | DB2BSTSGT | DEC | 19 | DB2DEC19V | ||||
QBSTHWR | Number of successful hiperpool writes | DB2BSTHWR | DEC | 10 | DEC_10 | ||||
QBSTSIO | Synchronous read requests issued by sequential access req. | DB2BSTSIO | DEC | 19 | DB2DEC19V | ||||
QBSTHWA | Number of successful hiperpool writes done asynchronously | DB2BSTHWA | DEC | 10 | DEC_10 | ||||
QBSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | DB2BSTNGT | DEC | 19 | DB2DEC19V | ||||
QBSTHWF | Number of unsuccessful hiperpool writes | DB2BSTHWF | DEC | 10 | DEC_10 | ||||
QBSTXIS | Highest number of concurrent prefetch I/O streams | DB2BSTXIS | DEC | 19 | DB2DEC19V | ||||
QBSTJIS | Total number of denied concurrent prefetch I/O streams | DB2BSTJIS | DEC | 19 | DB2DEC19V | ||||
QBSTVPL | Number of buffers allocated for virtual buffer pool | DB2BSTVPL | DEC | 19 | DB2DEC19V | ||||
QBSTHPL | Number of buffers allocated for hiperpool | DB2BSTHPL | DEC | 10 | DEC_10 | ||||
QBSTPQO | Total no. of requests for parallel query support | DB2BSTPQO | DEC | 19 | DB2DEC19V | ||||
QBSTDPP | Number of pages read via dynamic prefetch read I/O | DB2BSTDPP | DEC | 19 | DB2DEC19V | ||||
QBSTPQF | The parallel query went into reduced or degenerated mode | DB2BSTPQF | DEC | 19 | DB2DEC19V | ||||
QBSTLPP | Number of pages read via list prefetch | DB2BSTLPP | DEC | 19 | DB2DEC19V | ||||
QBSTPL1 | Prefetch quantity is reduced from normal to 50% | DB2BSTPL1 | DEC | 19 | DB2DEC19V | ||||
QBSTDIO | Number of dynamic prefetch reads | DB2BSTDIO | DEC | 19 | DB2DEC19V | ||||
QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | DB2BSTPL2 | DEC | 19 | DB2DEC19V | ||||
QBSTLIO | Number of list prefetch reads | DB2BSTLIO | DEC | 19 | DB2DEC19V | ||||
QBSTLPL | Number of times one or more pages were added to LPL | DB2BSTLPL | DEC | 19 | DB2DEC19V | ||||
QBSTSGT | Number of get page requests issued by sequential access req. | DB2BSTSGT | DEC | 19 | DB2DEC19V | ||||
QBSTSIO | Synchronous read requests issued by sequential access req. | DB2BSTSIO | DEC | 19 | DB2DEC19V | ||||
QBSTDWC | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 10 | DB2INT4 | ||||
QBSTDWX | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 10 | DB2INT4 | ||||
QBSTALX | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 10 | DB2INT4 | ||||
QBSTNGT | Field type numc, length 10, integer | DB2NUMC10 | INT4 | 10 | DB2INT4 | ||||
QBSTXIS | Highest number of concurrent prefetch I/O streams | DB2BSTXIS | DEC | 19 | DB2DEC19V | ||||
QBSTJIS | Total number of denied concurrent prefetch I/O streams | DB2BSTJIS | DEC | 19 | DB2DEC19V | ||||
QBSTPQO | Total no. of requests for parallel query support | DB2BSTPQO | DEC | 19 | DB2DEC19V | ||||
QBSTPQF | The parallel query went into reduced or degenerated mode | DB2BSTPQF | DEC | 19 | DB2DEC19V | ||||
QBSTPL1 | Prefetch quantity is reduced from normal to 50% | DB2BSTPL1 | DEC | 19 | DB2DEC19V | ||||
QBSTPL2 | Number of occurrences of prefetch quantity reduced 1/4 | DB2BSTPL2 | DEC | 19 | DB2DEC19V | ||||
QBSTARA | Asynchronous data mover facility hiperpool reads | DB2BSTARA | DEC | 10 | DEC_10 | ||||
QBSTARF | Number of pages for which a read request failed using DMF | DB2BSTARF | DEC | 10 | DEC_10 | ||||
QBSTAWA | Pages moved successfully from virtual pool to hp using DMF | DB2BSTAWA | DEC | 10 | DEC_10 | ||||
QBSTAWF | Number of pages for which write request failed using DMF | DB2BSTAWF | DEC | 10 | DEC_10 | ||||
QBSTHBE | Number of hp buffers currently backed by expanded storage | DB2BSTHBE | DEC | 10 | DEC_10 | ||||
QBSTLPL | Number of times one or more pages were added to LPL | DB2BSTLPL | DEC | 19 | DB2DEC19V |
Key field | Non-key field |
How do I retrieve data from SAP structure DB2QBSTT using ABAP code?
As DB2QBSTT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on DB2QBSTT as there is no data to select.How to access SAP table DB2QBSTT
Within an ECC or HANA version of SAP you can also view further information about DB2QBSTT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects