DB2_VIEW_BP_DET SAP (view data for BP Activity Details) Structure details
Description: view data for BP Activity Details
Related tables to DB2_VIEW_BP_DET
Access table DB2_VIEW_BP_DET
Structure field list including key, data, relationships and ABAP select examples
DB2_VIEW_BP_DET 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 "view data for BP Activity Details" 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_DB2_VIEW_BP_DET TYPE DB2_VIEW_BP_DET.
The DB2_VIEW_BP_DET table consists of various fields, each holding specific information or linking keys about view data for BP Activity Details data available in SAP. These include QBSTPID (Field type numc, length 10, integer), QBSTGET (Number of get page requests (conditional and unconditional)), QBSTRIO (Number of synchronous read I/O operations), QBSTDWV (Number of times vertical deferred write threshold is reached).. 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 DB2_VIEW_BP_DET 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 |
QBST | 0 | ||||||||
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 | ||||
QBSTWIO | Number of asynchronous writes | DB2BSTWIO | DEC | 19 | DB2DEC19V | ||||
QBSTCBA | Number of currently active (non-stealable) buffers | DB2BSTCBA | DEC | 19 | DB2DEC19V | ||||
QBSTRPI | Number of page inserts required for read I/O | DB2BSTRPI | 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 | ||||
QBSTIMW | Number of immediate writes | DB2BSTIMW | DEC | 19 | DB2DEC19V | ||||
QBSTSEQ | Number of sequential prefetch requests | DB2BSTSEQ | 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 | ||||
QBSTREE | Sequential prefetch disabled - unavailable read engine | DB2BSTREE | 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 | ||||
QBSTDMC | Number of times the data manager threshold was reached | DB2BSTDMC | DEC | 19 | DB2DEC19V | ||||
QBSTMIG | Number of times migrated datasets were encountered | DB2BSTMIG | DEC | 19 | DB2DEC19V | ||||
QBSTRTO | Number of recall timeouts | DB2BSTRTO | DEC | 19 | DB2DEC19V | ||||
QBSTPIO | Number of sequential prefetch reads | DB2BSTPIO | 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 | ||||
QBSTWFM | Maximum number of work files concurrently used | DB2BSTWFM | DEC | 19 | DB2DEC19V | ||||
QBSTWDRP | Number of pages for which destructive read was requested | DB2BSTWDRP | 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 | ||||
QBSTWFT | Number of merge passes requested for DB2 sort activities | DB2BSTWFT | DEC | 19 | DB2DEC19V | ||||
QBSTWFD | Work file requests were rejected due to buffer pool shortage | DB2BSTWFD | 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 | ||||
QBSTDPF | Number of dynamic prefetch requests | DB2BSTDPF | DEC | 19 | DB2DEC19V | ||||
QBSTVPA | Number of successful virtual buffer pool expans./contract. | DB2BSTVPA | 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 | ||||
QBSTLPP | Number of pages read via list prefetch | DB2BSTLPP | DEC | 19 | DB2DEC19V | ||||
QBSTDIO | Number of dynamic prefetch reads | DB2BSTDIO | DEC | 19 | DB2DEC19V | ||||
QBSTLIO | Number of list prefetch reads | DB2BSTLIO | 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 | ||||
QBSTNGT | # of unsuccessful GETPAGE due conditional GETPAGE request | DB2BSTNGT | DEC | 19 | DB2DEC19V | ||||
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 | ||||
QBSTHITR | Buffer hit ratio | DB2BSTHITR | CHAR | 7 | |||||
QBSTBPNM | DB2 buffer pool name | DB2BSTBPNM | CHAR | 8 | DB2BPNAME | ||||
MARK | Single-Character Indicator | CHAR1 | CHAR | 1 | CHAR1 | ||||
RANDHITR | Random hit ratio | DB2RNDHITR | DEC | 5(2) | DB2DECPCT | ||||
READRATE | Read rate per second | DB2READRAT | DEC | 20 | DB2DEC20V | ||||
UPPPWRIT | Buffer update per pages written | DB2UPPPWRI | DEC | 19(2) | DB2DEC19V2 | ||||
PWPWIO | Pages written per write I/O | DB2PWPWIO | DEC | 19(2) | DB2DEC19V2 | ||||
WRITERATE | Write rate = ( Synchronous + async. writes ) / interval | DB2WRITRAT | DEC | 20 | DB2DEC20V | ||||
BPTYPE | Type of virtual buffer pool | DB2DBPVPTY | CHAR | 1 | DB2CHAR01 | ||||
CURRINUSE | Percentage of buffers currently in use | DB2BINUSE | DEC | 5(2) | DB2DECPCT | ||||
VPSHORT | Number of Virtual Pool Shortages | DB2VPSHORT | DEC | 20 | DB2DEC20V | ||||
PREFDIS | Number of Times Sequential Prefetch Was Disabled | DB2PREFDIS | DEC | 20 | DB2DEC20V | ||||
PAGEIN | Number of page-ins | DB2PAGEIN | DEC | 20 | DB2DEC20V | ||||
GETPRAND | Number of Random Access Getpage Requests | DB2GETPRND | DEC | 20 | DB2DEC20V | ||||
GETPRATE | Number of Getpage Requests per Second | DB2GETPRAT | DEC | 19 | DB2DEC19V | ||||
SYNRRAND | Number of Random Access Synchronous Reads | DB2SYNRRND | DEC | 20 | DB2DEC20V | ||||
PG_SEQPREF | Number of Pages Read per Sequential Prefetch Read | DB2PGPSEQP | CHAR | 19 | |||||
PG_LISPREF | Number of Pages Read per List Prefetch Read | DB2PGPLISP | CHAR | 19 | |||||
PG_DYNPREF | Number of Pages Read per Dynamic Prefetch Read | DB2PGPDYNP | CHAR | 19 | |||||
BUPDRATE | Buffer Update Rate | DB2BUPDRAT | DEC | 19 | DB2DEC19V | ||||
WF_MERGE | Average Work Files per Merge Pass | DB2WFPMRGP | DEC | 19 | DB2DEC19V | ||||
WFN_DEGMP | Average Work Files Not Given per Degraded Merge Pass | DB2WFNPDMP | DEC | 19 | DB2DEC19V | ||||
QBSTLPL | Number of times one or more pages were added to LPL | DB2BSTLPL | DEC | 19 | DB2DEC19V | ||||
SIOPERSGT | Sync. seq. reads / seq. getpages | DB2SIOSGT | DEC | 19(6) | DB2DEC19V6 | ||||
SWRTRATE | Sync writes / ( sync writes + async writes) | DB2SWRTRATE | DEC | 5(2) | DB2DECPCT | ||||
QDBP | 0 | ||||||||
QDBPNM | Name of buffer pool | DB2DBPNM | CHAR | 8 | CHAR8 | ||||
QDBPVPSZ | The size of the virtual buffer pool | DB2DBPVPSZ | INT4 | 10 | |||||
QDBPVPSH | The sequential steal threshold for the virtual buffer pool | DB2DBPVPSH | INT4 | 10 | DB2INT4 | ||||
QDBPDWQT | The deferred write threshold for the virtual buffer pool | DB2DBPDWQT | INT4 | 10 | DB2INT4 | ||||
QDBPVDQT | The vertical deferred write threshold for the virtual BP | DB2DBPVDQT | INT4 | 10 | |||||
QDBPPSQT | Parallel I/O sequential steal threshold for virtual BP | DB2DBPPSQT | INT4 | 10 | DB2INT4 | ||||
QDBPXSQT | Assisting parallel sequential threshold | DB2DBPXSQT | INT4 | 10 | DB2INT4 | ||||
QDBPVPTY | Type of virtual buffer pool | DB2DBPVPTY | CHAR | 1 | DB2CHAR01 | ||||
QDBPVDQB | Pool vertical write threshold in number of buffers | DB2DBPVDQB | INT2 | 5 | DB2INT2V | ||||
QDBPPGST | Page stealing algorithm to be used for the virtual BP | DB2DBPPGST | CHAR | 4 | DB2CHAR04 | ||||
QDBPPFIX | PGFIX attribute (BP long-term fixed in real storage) | 0 |
Key field | Non-key field |
How do I retrieve data from SAP structure DB2_VIEW_BP_DET using ABAP code?
As DB2_VIEW_BP_DET 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 DB2_VIEW_BP_DET as there is no data to select.How to access SAP table DB2_VIEW_BP_DET
Within an ECC or HANA version of SAP you can also view further information about DB2_VIEW_BP_DET 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