SAP ABAP Table DB2QBGBT (DB2QBGBT)

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	DB2QBGBT	Table Relationship Diagram
Short Description	DB2QBGBT

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