SAP ABAP Table DB2QBST (Buffer Manager Statistics Block)

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	DB2QBST	Table Relationship Diagram
Short Description	Buffer Manager Statistics Block

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

History

Last changed by/on	SAP	20140117
SAP Release Created in