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

History

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