SAP ABAP Table DB2QBSTT (DB2 CL - Buffer manager statitics block)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-DB2 (Application Component) DB2 for z/OS
     ⤷ STU3 (Package) Development Class for Database Monitor

Basic Data

Table Category	INTTAB	Structure
Structure	DB2QBSTT	Table Relationship Diagram
Short Description	DB2 CL - Buffer manager statitics 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	MEMBNM	☑	DB2MEMN	DB2CHAR08	CHAR	8	0	DB2 member name in data sharing environment
2	QBSTBPNM	☑	DB2BSTBPNM	DB2BPNAME	CHAR	8	0	DB2 buffer pool name
3	QBSTPID	☐	DB2NUMC10	DB2INT4	INT4	10	0	Field type numc, length 10, integer
4	QBSTGET	☐	DB2BSTGET	DB2DEC19V	DEC	19	0	Number of get page requests (conditional and unconditional)
5	QBSTRIO	☐	DB2BSTRIO	DB2DEC19V	DEC	19	0	Number of synchronous read I/O operations
6	QBSTDWV	☐	DB2BSTDWV	DB2DEC19V	DEC	19	0	Number of times vertical deferred write threshold is reached
7	QBSTXFL	☐	DB2BSTXFL	DB2DEC19V	DEC	19	0	Number of times the virtual buffer pool was full
8	QBSTXFV	☐	DB2BSTXFV	DB2DEC19V	DEC	19	0	Total number of virtual buffer pool or hiperpool failures
9	QBSTSWS	☐	DB2BSTSWS	DB2DEC19V	DEC	19	0	Update intents against pages in the buffer pool
10	QBSTPWS	☐	DB2BSTPWS	DB2DEC19V	DEC	19	0	Number of pages written
11	QBSTWIO	☐	DB2BSTWIO	DB2DEC19V	DEC	19	0	Number of asynchronous writes
12	QBSTCBA	☐	DB2BSTCBA	DB2DEC19V	DEC	19	0	Number of currently active (non-stealable) buffers
13	QBSTRPI	☐	DB2BSTRPI	DB2DEC19V	DEC	19	0	Number of page inserts required for read I/O
14	QBSTWPI	☐	DB2BSTWPI	DB2DEC19V	DEC	19	0	Number of page inserts required for write I/O
15	QBSTDSO	☐	DB2BSTDSO	DB2DEC19V	DEC	19	0	Number of datasets successfully opened physically
16	QBSTIMW	☐	DB2BSTIMW	DB2DEC19V	DEC	19	0	Number of immediate writes
17	QBSTSEQ	☐	DB2BSTSEQ	DB2DEC19V	DEC	19	0	Number of sequential prefetch requests
18	QBSTSPP	☐	DB2BSTSPP	DB2DEC19V	DEC	19	0	Number of pages read because of normal sequential prefetch
19	QBSTSPD	☐	DB2BSTSPD	DB2DEC19V	DEC	19	0	Sequential prefetch disabled - no buffers available
20	QBSTREE	☐	DB2BSTREE	DB2DEC19V	DEC	19	0	Sequential prefetch disabled - unavailable read engine
21	QBSTWEE	☐	DB2BSTWEE	DB2DEC10V	DEC	10	0	A write engine is unavailable for asynchronous write I/O
22	QBSTDWT	☐	DB2BSTDWT	DB2DEC19V	DEC	19	0	Number of times the deferred write threshold was reached
23	QBSTDMC	☐	DB2BSTDMC	DB2DEC19V	DEC	19	0	Number of times the data manager threshold was reached
24	QBSTMIG	☐	DB2BSTMIG	DB2DEC19V	DEC	19	0	Number of times migrated datasets were encountered
25	QBSTRTO	☐	DB2BSTRTO	DB2DEC19V	DEC	19	0	Number of recall timeouts
26	QBSTPIO	☐	DB2BSTPIO	DB2DEC19V	DEC	19	0	Number of sequential prefetch reads
27	QBSTWKPD	☐	DB2BSTWKPD	DB2DEC19V	DEC	19	0	Number of work prefetches not scheduled due to zero prefetch
28	QBSTMAX	☐	DB2BSTMAX	DB2DEC19V	DEC	19	0	Number of times a work file could not be opened
29	QBSTWFM	☐	DB2BSTWFM	DB2DEC19V	DEC	19	0	Maximum number of work files concurrently used
30	QBSTWDRP	☐	DB2BSTWDRP	DB2DEC19V	DEC	19	0	Number of pages for which destructive read was requested
31	QBSTWBVQ	☐	DB2BSTWBVQ	DB2DEC19V	DEC	19	0	Number of Pages Removed from the DWQ for Destructive Read
32	QBSTWFR	☐	DB2BSTWFR	DB2DEC19V	DEC	19	0	Number of merge passes requested for DB2 sort activities
33	QBSTWFT	☐	DB2BSTWFT	DB2DEC19V	DEC	19	0	Number of merge passes requested for DB2 sort activities
34	QBSTWFD	☐	DB2BSTWFD	DB2DEC19V	DEC	19	0	Work file requests were rejected due to buffer pool shortage
35	QBSTWFF	☐	DB2BSTWFF	DB2DEC19V	DEC	19	0	Number of times a merge pass could not be performed
36	QBSTLPF	☐	DB2BSTLPF	DB2DEC19V	DEC	19	0	Number of list prefetch requests
37	QBSTDPF	☐	DB2BSTDPF	DB2DEC19V	DEC	19	0	Number of dynamic prefetch requests
38	QBSTVPA	☐	DB2BSTVPA	DB2DEC19V	DEC	19	0	Number of successful virtual buffer pool expans./contract.
39	QBSTVPL	☐	DB2BSTVPL	DB2DEC19V	DEC	19	0	Number of buffers allocated for virtual buffer pool
40	QBSTDPP	☐	DB2BSTDPP	DB2DEC19V	DEC	19	0	Number of pages read via dynamic prefetch read I/O
41	QBSTLPP	☐	DB2BSTLPP	DB2DEC19V	DEC	19	0	Number of pages read via list prefetch
42	QBSTDIO	☐	DB2BSTDIO	DB2DEC19V	DEC	19	0	Number of dynamic prefetch reads
43	QBSTLIO	☐	DB2BSTLIO	DB2DEC19V	DEC	19	0	Number of list prefetch reads
44	QBSTSGT	☐	DB2BSTSGT	DB2DEC19V	DEC	19	0	Number of get page requests issued by sequential access req.
45	QBSTSIO	☐	DB2BSTSIO	DB2DEC19V	DEC	19	0	Synchronous read requests issued by sequential access req.
46	QBSTNGT	☐	DB2BSTNGT	DB2DEC19V	DEC	19	0	# of unsuccessful GETPAGE due conditional GETPAGE request
47	QBSTXIS	☐	DB2BSTXIS	DB2DEC19V	DEC	19	0	Highest number of concurrent prefetch I/O streams
48	QBSTJIS	☐	DB2BSTJIS	DB2DEC19V	DEC	19	0	Total number of denied concurrent prefetch I/O streams
49	QBSTPQO	☐	DB2BSTPQO	DB2DEC19V	DEC	19	0	Total no. of requests for parallel query support
50	QBSTPQF	☐	DB2BSTPQF	DB2DEC19V	DEC	19	0	The parallel query went into reduced or degenerated mode
51	QBSTPL1	☐	DB2BSTPL1	DB2DEC19V	DEC	19	0	Prefetch quantity is reduced from normal to 50%
52	QBSTPL2	☐	DB2BSTPL2	DB2DEC19V	DEC	19	0	Number of occurrences of prefetch quantity reduced 1/4
53	QBSTLPL	☐	DB2BSTLPL	DB2DEC19V	DEC	19	0	Number of times one or more pages were added to LPL
54	QBSTSMIN	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
55	QBSTSMAX	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
56	QBSTHST	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
57	QBSTRHS	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign
58	QBSTNSG	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign

History

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