SAP ABAP Table DB2_KPI_QBGB (groupbufferpool config data)
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_KPI_QBGB |
|
| Short Description | groupbufferpool config data |
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 | |
DB2MEMN | DB2CHAR08 | CHAR | 8 | 0 | DB2 member name in data sharing environment | ||
| 2 | |
DB2BGLGN | DB2BPNAME | CHAR | 8 | 0 | Group buffer pool ID | ||
| 3 | |
DB2BGBGSZ | DB2INT4 | INT4 | 10 | 0 | Allocated group buffer pool size in 4KB increments | ||
| 4 | |
DB2BGBGDR | DB2INT4 | INT4 | 10 | 0 | The actual number of allocated directory entries | ||
| 5 | |
DB2BGBGDT | DB2INT4 | INT4 | 10 | 0 | The actual number of allocated data entries | ||
| 6 | |
DB2BGBGR1 | DB2CHAR06 | CHAR | 6 | 0 | The current directory entry per data entry ratio | ||
| 7 | |
DB2BGBGR2 | DB2CHAR06 | CHAR | 6 | 0 | The pending directory entry per data entry ratio | ||
| 8 | |
DB2BGBGCT | DB2INT4 | INT4 | 10 | 0 | Class castout threshold (%) | ||
| 9 | |
DB2BGBGGT | DB2INT4 | INT4 | 10 | 0 | Group buffer pool castout threshold (%) | ||
| 10 | |
DB2BGBGCK | DB2INT4 | INT4 | 10 | 0 | GBP checkpoint interval (GBPCHKPT) | ||
| 11 | |
DB2BGBGAS | DB2CHAR03L | CHAR | 3 | 0 | Current automatic recovery setting for the GBP | ||
| 12 | |
DB2BGBGCS8 | DB2CHAR03L | CHAR | 3 | 0 | Current group buffer pool cache (GBPCACHE) setting | ||
| 13 | |
DB2BGBDUP | DB2CHAR08L | CHAR | 8 | 0 | Duplex or simplex indication for the group buffer pool | ||
| 14 | |
DB2BGBGSZ2 | DB2INT4 | INT4 | 10 | 0 | Allocated size of the sec. group buffer pool (in 4KB blocks) | ||
| 15 | |
DB2BGBGDR2 | DB2INT4 | INT4 | 10 | 0 | Number of allocated directory entries in the sec. GBP | ||
| 16 | |
DB2BGBGDT2 | DB2INT4 | INT4 | 10 | 0 | Number of data entries allocated for the secondary GBP |
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 731 |