SAP ABAP Table DB2QBGB (DB2/390: Group Buffer Pool Parameters)

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	DB2QBGB	Table Relationship Diagram
Short Description	DB2/390: Group Buffer Pool Parameters

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	QBGBGN	☐	DB2BGLGN	DB2BPNAME	CHAR	8	0	Group buffer pool ID
2	QBGBGR1	☐	DB2BGBGR1	DB2CHAR06	CHAR	6	0	The current directory entry per data entry ratio
3	QBGBGR2	☐	DB2BGBGR2	DB2CHAR06	CHAR	6	0	The pending directory entry per data entry ratio
4	QBGBGCT	☐	DB2BGBGCT	DB2INT4	INT4	10	0	Class castout threshold (%)
5	QBGBGGT	☐	DB2BGBGGT	DB2INT4	INT4	10	0	Group buffer pool castout threshold (%)
6	QBGBGAS	☐	DB2BGBGAS	DB2CHAR03L	CHAR	3	0	Current automatic recovery setting for the GBP
7	QBGBGCS	☐	DB2BGBGCS8	DB2CHAR03L	CHAR	3	0	Current group buffer pool cache (GBPCACHE) setting
8	QBGBGCK	☐	DB2BGBGCK	DB2INT4	INT4	10	0	GBP checkpoint interval (GBPCHKPT)
9	QBGBGSZ	☐	DB2BGBGSZ	DB2INT4	INT4	10	0	Allocated group buffer pool size in 4KB increments
10	QBGBGDR	☐	DB2BGBGDR	DB2INT4	INT4	10	0	The actual number of allocated directory entries
11	QBGBGDT	☐	DB2BGBGDT	DB2INT4	INT4	10	0	The actual number of allocated data entries
12	QBGBDRR	☐	DB2BGBDRR	DB2INT4	INT4	10	0	Directory entry reclaim counter
13	QBGBDTR	☐	DB2BGBDTR	DB2INT4	INT4	10	0	Data entry reclaim counter
14	QBGBRXI	☐	DB2BGBRXI	DB2INT4	INT4	10	0	Cross-invalidation & directory entry reclaim counter
15	QBGBTCC	☐	DB2BGBTCC	DB2INT4	INT4	10	0	Total changed counter
16	QBGBDUP	☐	DB2BGBDUP	DB2CHAR08L	CHAR	8	0	Duplex or simplex indication for the group buffer pool
17	QBGBGSZ2	☐	DB2BGBGSZ2	DB2INT4	INT4	10	0	Allocated size of the sec. group buffer pool (in 4KB blocks)
18	QBGBGDR2	☐	DB2BGBGDR2	DB2INT4	INT4	10	0	Number of allocated directory entries in the sec. GBP
19	QBGBGDT2	☐	DB2BGBGDT2	DB2INT4	INT4	10	0	Number of data entries allocated for the secondary GBP
20	QBGBGCTN	☐	DB2BGBCTN		DEC	10	0	DB2 11 - Castout class level threshold (buffer num)

History

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