SAP Table DB2_VIEW_BP_DET

view data for BP Activity Details

DB2_VIEW_BP_DET (view data for BP Activity Details) 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 DB2_VIEW_BP_DET to other SAP tables.

Source: DB2_VIEW_BP_DET (view data for BP Activity Details)

DB2_VIEW_BP_DET table fields

Field		Data element	Datatype	Length	Decimals
QBST		DB2QBST	STRU	0	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
QBSTHITR	Buffer hit ratio	DB2BSTHITR	CHAR	7	0
QBSTBPNM	DB2 buffer pool name	DB2BSTBPNM	CHAR	8	0
MARK	Single-Character Indicator	CHAR1	CHAR	1	0
RANDHITR	Random hit ratio	DB2RNDHITR	DEC	5	2
READRATE	Read rate per second	DB2READRAT	DEC	20	0
UPPPWRIT	Buffer update per pages written	DB2UPPPWRI	DEC	19	2
PWPWIO	Pages written per write I/O	DB2PWPWIO	DEC	19	2
WRITERATE	Write rate = ( Synchronous + async. writes ) / interval	DB2WRITRAT	DEC	20	0
BPTYPE	Type of virtual buffer pool	DB2DBPVPTY	CHAR	1	0
CURRINUSE	Percentage of buffers currently in use	DB2BINUSE	DEC	5	2
VPSHORT	Number of Virtual Pool Shortages	DB2VPSHORT	DEC	20	0
PREFDIS	Number of Times Sequential Prefetch Was Disabled	DB2PREFDIS	DEC	20	0
PAGEIN	Number of page-ins	DB2PAGEIN	DEC	20	0
GETPRAND	Number of Random Access Getpage Requests	DB2GETPRND	DEC	20	0
GETPRATE	Number of Getpage Requests per Second	DB2GETPRAT	DEC	19	0
SYNRRAND	Number of Random Access Synchronous Reads	DB2SYNRRND	DEC	20	0
PG_SEQPREF	Number of Pages Read per Sequential Prefetch Read	DB2PGPSEQP	CHAR	19	0
PG_LISPREF	Number of Pages Read per List Prefetch Read	DB2PGPLISP	CHAR	19	0
PG_DYNPREF	Number of Pages Read per Dynamic Prefetch Read	DB2PGPDYNP	CHAR	19	0
BUPDRATE	Buffer Update Rate	DB2BUPDRAT	DEC	19	0
WF_MERGE	Average Work Files per Merge Pass	DB2WFPMRGP	DEC	19	0
WFN_DEGMP	Average Work Files Not Given per Degraded Merge Pass	DB2WFNPDMP	DEC	19	0
QBSTLPL	Number of times one or more pages were added to LPL	DB2BSTLPL	DEC	19	0
SIOPERSGT	Sync. seq. reads / seq. getpages	DB2SIOSGT	DEC	19	6
SWRTRATE	Sync writes / ( sync writes + async writes)	DB2SWRTRATE	DEC	5	2
QDBP		DB2QDBP	STRU	0	0
QDBPNM	Name of buffer pool	DB2DBPNM	CHAR	8	0
QDBPVPSZ	The size of the virtual buffer pool	DB2DBPVPSZ	INT4	10	0
QDBPVPSH	The sequential steal threshold for the virtual buffer pool	DB2DBPVPSH	INT4	10	0
QDBPDWQT	The deferred write threshold for the virtual buffer pool	DB2DBPDWQT	INT4	10	0
QDBPVDQT	The vertical deferred write threshold for the virtual BP	DB2DBPVDQT	INT4	10	0
QDBPPSQT	Parallel I/O sequential steal threshold for virtual BP	DB2DBPPSQT	INT4	10	0
QDBPXSQT	Assisting parallel sequential threshold	DB2DBPXSQT	INT4	10	0
QDBPVPTY	Type of virtual buffer pool	DB2DBPVPTY	CHAR	1	0
QDBPVDQB	Pool vertical write threshold in number of buffers	DB2DBPVDQB	INT2	5	0
QDBPPGST	Page stealing algorithm to be used for the virtual BP	DB2DBPPGST	CHAR	4	0
QDBPPFIX			CHAR	3	0