SAP ABAP Table DB2QBGL (Statistics Group Buffer Pool)

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	DB2QBGL	Table Relationship Diagram
Short Description	Statistics Group Buffer Pool

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	QBGLGN	☐	DB2BGLGN	DB2BPNAME	CHAR	8	0	Group buffer pool ID
2	QBGLXD	☐	DB2BGLXD	DB2DEC19V	DEC	19	0	Synchronous read (cross invalidation) - data returned
3	QBGLXR	☐	DB2BGLXR	DB2DEC19V	DEC	19	0	Synchronous Read (Cross Invalidation) - No Data Returned
4	QBGLMD	☐	DB2BGLMD	DB2DEC19V	DEC	19	0	Synchronous read (not found) - Data returned
5	QBGLMR	☐	DB2BGLMR	DB2DEC19V	DEC	19	0	Synchronous Read (Not Found) - No Data Returned (Dir. Entry)
6	QBGLSW	☐	DB2BGLSW	DB2DEC19V	DEC	19	0	Changed pages written synchronously to GBP
7	QBGLWC	☐	DB2BGLWC	DB2DEC19V	DEC	19	0	Clean pages written synchronously
8	QBGLCT	☐	DB2BGLCT	DB2DEC19V	DEC	19	0	Castout class threshold
9	QBGLGT	☐	DB2BGLGT	DB2DEC19V	DEC	19	0	Group buffer pool castout threshold
10	QBGLEX	☐	DB2BGLEX	DB2DEC19V	DEC	19	0	Number of explicit cross-invalidations
11	QBGLAW	☐	DB2BGLAW	DB2DEC19V	DEC	19	0	Changed pages written asynchronously
12	QBGLAC	☐	DB2BGLAC	DB2DEC19V	DEC	19	0	Clean pages written asynchronously
13	QBGLRC	☐	DB2BGLRC	DB2DEC19V	DEC	19	0	Pages cast out from GBP to DASD
14	QBGLWF	☐	DB2BGLWF	DB2DEC19V	DEC	19	0	Write failed - no storage
15	QBGLOS	☐	DB2BGLOS	DB2DEC19V	DEC	19	0	CF requests to read storage statistics
16	QBGLCK	☐	DB2BGLCK	DB2DEC19V	DEC	19	0	GBP checkpoints triggered
17	QBGLUN	☐	DB2BGLUN	DB2DEC19V	DEC	19	0	Unlock castout
18	QBGLCC	☐	DB2BGLCC	DB2DEC19V	DEC	19	0	Read castout class
19	QBGLCS	☐	DB2BGLCS	DB2DEC19V	DEC	19	0	Read castout statistics
20	QBGLDN	☐	DB2BGLDN	DB2DEC19V	DEC	19	0	Delete data and directory entries in GBP
21	QBGLRD	☐	DB2BGLRD	DB2DEC19V	DEC	19	0	Read directory info
22	QBGLRG	☐	DB2BGLRG	DB2DEC19V	DEC	19	0	Register page
23	QBGLDG	☐	DB2BGLDG	DB2DEC19V	DEC	19	0	Unregister page
24	QBGLAX	☐	DB2BGLAX	DB2DEC19V	DEC	19	0	Register page list request
25	QBGLAY	☐	DB2BGLAY	DB2DEC19V	DEC	19	0	Changed pages - Read after register page list
26	QBGL2F	☐	DB2BGL2F	DB2DEC19V	DEC	19	0	Number of write requests to the secondary GBP that failed
27	QBGL2D	☐	DB2BGL2D	DB2DEC19V	DEC	19	0	Number of requests to delete a list of pages (secondary GBP)
28	QBGL2R	☐	DB2BGL2R	DB2DEC19V	DEC	19	0	Number of requests to read the castout statistics (sec. GBP)
29	QBGL2N	☐	DB2BGL2N	DB2DEC19V	DEC	19	0	Number of requests to delete a page from the secondary GBP
30	QBGLHS	☐	DB2BGLHS	DB2DEC19V	DEC	19	0	# Asynch IXLCACHE invocations for primary GBP
31	QBGL2H	☐	DB2BGL2H	DB2DEC19V	DEC	19	0	# Asynch IXLCACHE invocations for secondary GBP
32	QBGLP1	☐	DB2BGLP1	DB2DEC19V	DEC	19	0	# page P-lock lock requests for space map pages
33	QBGLP2	☐	DB2BGLP2	DB2DEC19V	DEC	19	0	# page P-lock lock requests for data pages
34	QBGLP3	☐	DB2BGLP3	DB2DEC19V	DEC	19	0	# page P-lock lock requests for index leaf pages
35	QBGLU1	☐	DB2BGLU1	DB2DEC19V	DEC	19	0	# page P-lock unlock requests
36	QBGLS1	☐	DB2BGLS1	DB2DEC19V	DEC	19	0	# page P-lock lock suspensions for space map pages
37	QBGLS2	☐	DB2BGLS2	DB2DEC19V	DEC	19	0	# page P-lock lock suspensions for data pages
38	QBGLS3	☐	DB2BGLS3	DB2DEC19V	DEC	19	0	# page P-lock lock suspensions for index leaf pages
39	QBGLN1	☐	DB2BGLN1	DB2DEC19V	DEC	19	0	# page P-lock lock negotiations for space map pages
40	QBGLN2	☐	DB2BGLN2	DB2DEC19V	DEC	19	0	# page P-lock lock negotiations for data pages
41	QBGLN3	☐	DB2BGLN3	DB2DEC19V	DEC	19	0	# page P-lock lock negotiations for index leaf pages
42	QBGLWA	☐	DB2DEC19V	DB2DEC19V	DEC	19	0	dec 19 with sign

History

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