SAP ABAP Table DB2_VIEW_BP_DET (view data for BP Activity Details)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU2 (Package) CCMS for DB2 for OS/390

Basic Data

Table Category	INTTAB	Structure
Structure	DB2_VIEW_BP_DET	Table Relationship Diagram
Short Description	view data for BP Activity Details

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	QBST	☐	DB2QBST		STRU	0	0
2	QBSTPID	☐	DB2NUMC10	DB2INT4	INT4	10	0	Field type numc, length 10, integer
3	QBSTGET	☐	DB2BSTGET	DB2DEC19V	DEC	19	0	Number of get page requests (conditional and unconditional)
4	QBSTRIO	☐	DB2BSTRIO	DB2DEC19V	DEC	19	0	Number of synchronous read I/O operations
5	QBSTDWV	☐	DB2BSTDWV	DB2DEC19V	DEC	19	0	Number of times vertical deferred write threshold is reached
6	QBSTXFL	☐	DB2BSTXFL	DB2DEC19V	DEC	19	0	Number of times the virtual buffer pool was full
7	QBSTXFV	☐	DB2BSTXFV	DB2DEC19V	DEC	19	0	Total number of virtual buffer pool or hiperpool failures
8	QBSTSWS	☐	DB2BSTSWS	DB2DEC19V	DEC	19	0	Update intents against pages in the buffer pool
9	QBSTPWS	☐	DB2BSTPWS	DB2DEC19V	DEC	19	0	Number of pages written
10	QBSTWIO	☐	DB2BSTWIO	DB2DEC19V	DEC	19	0	Number of asynchronous writes
11	QBSTCBA	☐	DB2BSTCBA	DB2DEC19V	DEC	19	0	Number of currently active (non-stealable) buffers
12	QBSTRPI	☐	DB2BSTRPI	DB2DEC19V	DEC	19	0	Number of page inserts required for read I/O
13	QBSTWPI	☐	DB2BSTWPI	DB2DEC19V	DEC	19	0	Number of page inserts required for write I/O
14	QBSTDSO	☐	DB2BSTDSO	DB2DEC19V	DEC	19	0	Number of datasets successfully opened physically
15	QBSTIMW	☐	DB2BSTIMW	DB2DEC19V	DEC	19	0	Number of immediate writes
16	QBSTSEQ	☐	DB2BSTSEQ	DB2DEC19V	DEC	19	0	Number of sequential prefetch requests
17	QBSTSPP	☐	DB2BSTSPP	DB2DEC19V	DEC	19	0	Number of pages read because of normal sequential prefetch
18	QBSTSPD	☐	DB2BSTSPD	DB2DEC19V	DEC	19	0	Sequential prefetch disabled - no buffers available
19	QBSTREE	☐	DB2BSTREE	DB2DEC19V	DEC	19	0	Sequential prefetch disabled - unavailable read engine
20	QBSTWEE	☐	DB2BSTWEE	DB2DEC10V	DEC	10	0	A write engine is unavailable for asynchronous write I/O
21	QBSTDWT	☐	DB2BSTDWT	DB2DEC19V	DEC	19	0	Number of times the deferred write threshold was reached
22	QBSTDMC	☐	DB2BSTDMC	DB2DEC19V	DEC	19	0	Number of times the data manager threshold was reached
23	QBSTMIG	☐	DB2BSTMIG	DB2DEC19V	DEC	19	0	Number of times migrated datasets were encountered
24	QBSTRTO	☐	DB2BSTRTO	DB2DEC19V	DEC	19	0	Number of recall timeouts
25	QBSTPIO	☐	DB2BSTPIO	DB2DEC19V	DEC	19	0	Number of sequential prefetch reads
26	QBSTWKPD	☐	DB2BSTWKPD	DB2DEC19V	DEC	19	0	Number of work prefetches not scheduled due to zero prefetch
27	QBSTMAX	☐	DB2BSTMAX	DB2DEC19V	DEC	19	0	Number of times a work file could not be opened
28	QBSTWFM	☐	DB2BSTWFM	DB2DEC19V	DEC	19	0	Maximum number of work files concurrently used
29	QBSTWDRP	☐	DB2BSTWDRP	DB2DEC19V	DEC	19	0	Number of pages for which destructive read was requested
30	QBSTWBVQ	☐	DB2BSTWBVQ	DB2DEC19V	DEC	19	0	Number of Pages Removed from the DWQ for Destructive Read
31	QBSTWFR	☐	DB2BSTWFR	DB2DEC19V	DEC	19	0	Number of merge passes requested for DB2 sort activities
32	QBSTWFT	☐	DB2BSTWFT	DB2DEC19V	DEC	19	0	Number of merge passes requested for DB2 sort activities
33	QBSTWFD	☐	DB2BSTWFD	DB2DEC19V	DEC	19	0	Work file requests were rejected due to buffer pool shortage
34	QBSTWFF	☐	DB2BSTWFF	DB2DEC19V	DEC	19	0	Number of times a merge pass could not be performed
35	QBSTLPF	☐	DB2BSTLPF	DB2DEC19V	DEC	19	0	Number of list prefetch requests
36	QBSTDPF	☐	DB2BSTDPF	DB2DEC19V	DEC	19	0	Number of dynamic prefetch requests
37	QBSTVPA	☐	DB2BSTVPA	DB2DEC19V	DEC	19	0	Number of successful virtual buffer pool expans./contract.
38	QBSTVPL	☐	DB2BSTVPL	DB2DEC19V	DEC	19	0	Number of buffers allocated for virtual buffer pool
39	QBSTDPP	☐	DB2BSTDPP	DB2DEC19V	DEC	19	0	Number of pages read via dynamic prefetch read I/O
40	QBSTLPP	☐	DB2BSTLPP	DB2DEC19V	DEC	19	0	Number of pages read via list prefetch
41	QBSTDIO	☐	DB2BSTDIO	DB2DEC19V	DEC	19	0	Number of dynamic prefetch reads
42	QBSTLIO	☐	DB2BSTLIO	DB2DEC19V	DEC	19	0	Number of list prefetch reads
43	QBSTSGT	☐	DB2BSTSGT	DB2DEC19V	DEC	19	0	Number of get page requests issued by sequential access req.
44	QBSTSIO	☐	DB2BSTSIO	DB2DEC19V	DEC	19	0	Synchronous read requests issued by sequential access req.
45	QBSTNGT	☐	DB2BSTNGT	DB2DEC19V	DEC	19	0	# of unsuccessful GETPAGE due conditional GETPAGE request
46	QBSTXIS	☐	DB2BSTXIS	DB2DEC19V	DEC	19	0	Highest number of concurrent prefetch I/O streams
47	QBSTJIS	☐	DB2BSTJIS	DB2DEC19V	DEC	19	0	Total number of denied concurrent prefetch I/O streams
48	QBSTPQO	☐	DB2BSTPQO	DB2DEC19V	DEC	19	0	Total no. of requests for parallel query support
49	QBSTPQF	☐	DB2BSTPQF	DB2DEC19V	DEC	19	0	The parallel query went into reduced or degenerated mode
50	QBSTPL1	☐	DB2BSTPL1	DB2DEC19V	DEC	19	0	Prefetch quantity is reduced from normal to 50%
51	QBSTPL2	☐	DB2BSTPL2	DB2DEC19V	DEC	19	0	Number of occurrences of prefetch quantity reduced 1/4
52	QBSTHITR	☐	DB2BSTHITR		CHAR	7	0	Buffer hit ratio
53	QBSTBPNM	☐	DB2BSTBPNM	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
54	MARK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
55	RANDHITR	☐	DB2RNDHITR	DB2DECPCT	DEC	5	2	Random hit ratio
56	READRATE	☐	DB2READRAT	DB2DEC20V	DEC	20	0	Read rate per second
57	UPPPWRIT	☐	DB2UPPPWRI	DB2DEC19V2	DEC	19	2	Buffer update per pages written
58	PWPWIO	☐	DB2PWPWIO	DB2DEC19V2	DEC	19	2	Pages written per write I/O
59	WRITERATE	☐	DB2WRITRAT	DB2DEC20V	DEC	20	0	Write rate = ( Synchronous + async. writes ) / interval
60	BPTYPE	☐	DB2DBPVPTY	DB2CHAR01	CHAR	1	0	Type of virtual buffer pool
61	CURRINUSE	☐	DB2BINUSE	DB2DECPCT	DEC	5	2	Percentage of buffers currently in use
62	VPSHORT	☐	DB2VPSHORT	DB2DEC20V	DEC	20	0	Number of Virtual Pool Shortages
63	PREFDIS	☐	DB2PREFDIS	DB2DEC20V	DEC	20	0	Number of Times Sequential Prefetch Was Disabled
64	PAGEIN	☐	DB2PAGEIN	DB2DEC20V	DEC	20	0	Number of page-ins
65	GETPRAND	☐	DB2GETPRND	DB2DEC20V	DEC	20	0	Number of Random Access Getpage Requests
66	GETPRATE	☐	DB2GETPRAT	DB2DEC19V	DEC	19	0	Number of Getpage Requests per Second
67	SYNRRAND	☐	DB2SYNRRND	DB2DEC20V	DEC	20	0	Number of Random Access Synchronous Reads
68	PG_SEQPREF	☐	DB2PGPSEQP		CHAR	19	0	Number of Pages Read per Sequential Prefetch Read
69	PG_LISPREF	☐	DB2PGPLISP		CHAR	19	0	Number of Pages Read per List Prefetch Read
70	PG_DYNPREF	☐	DB2PGPDYNP		CHAR	19	0	Number of Pages Read per Dynamic Prefetch Read
71	BUPDRATE	☐	DB2BUPDRAT	DB2DEC19V	DEC	19	0	Buffer Update Rate
72	WF_MERGE	☐	DB2WFPMRGP	DB2DEC19V	DEC	19	0	Average Work Files per Merge Pass
73	WFN_DEGMP	☐	DB2WFNPDMP	DB2DEC19V	DEC	19	0	Average Work Files Not Given per Degraded Merge Pass
74	QBSTLPL	☐	DB2BSTLPL	DB2DEC19V	DEC	19	0	Number of times one or more pages were added to LPL
75	SIOPERSGT	☐	DB2SIOSGT	DB2DEC19V6	DEC	19	6	Sync. seq. reads / seq. getpages
76	SWRTRATE	☐	DB2SWRTRATE	DB2DECPCT	DEC	5	2	Sync writes / ( sync writes + async writes)
77	QBSTSMIN	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
78	QBSTSMAX	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
79	QBSTHST	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
80	QBSTRHS	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
81	QBSTNSG	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
82	QDBP	☐	DB2QDBP		STRU	0	0
83	QDBPNM	☐	DB2DBPNM	CHAR8	CHAR	8	0	Name of buffer pool
84	QDBPVPSZ	☐	DB2DBPVPSZ		INT4	10	0	The size of the virtual buffer pool
85	QDBPVPSH	☐	DB2DBPVPSH	DB2INT4	INT4	10	0	The sequential steal threshold for the virtual buffer pool
86	QDBPDWQT	☐	DB2DBPDWQT	DB2INT4	INT4	10	0	The deferred write threshold for the virtual buffer pool
87	QDBPVDQT	☐	DB2DBPVDQT		INT4	10	0	The vertical deferred write threshold for the virtual BP
88	QDBPPSQT	☐	DB2DBPPSQT	DB2INT4	INT4	10	0	Parallel I/O sequential steal threshold for virtual BP
89	QDBPXSQT	☐	DB2DBPXSQT	DB2INT4	INT4	10	0	Assisting parallel sequential threshold
90	QDBPVPTY	☐	DB2DBPVPTY	DB2CHAR01	CHAR	1	0	Type of virtual buffer pool
91	QDBPVDQB	☐	DB2DBPVDQB	DB2INT2V	INT2	5	0	Pool vertical write threshold in number of buffers
92	QDBPPGST	☐	DB2DBPPGST	DB2CHAR04	CHAR	4	0	Page stealing algorithm to be used for the virtual BP
93	QDBPPFIX	☐			CHAR	3	0
94	QDBPFRAM	☐			CHAR	2	0
95	QDBPVPMI	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
96	QDBPVPMA	☐	DB2DEC10	DEC_10	DEC	10	0	Field Type DEC, Length 10
97	QDBPASIZ	☐			CHAR	3	0

History

Last changed by/on	SAP	20140117
SAP Release Created in	703