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
⤷ 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 | Table Relationship Diagram |
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 | MEMBER | DB2MEMN | DB2CHAR08 | CHAR | 8 | 0 | DB2 member name in data sharing environment | ||
2 | QBGBGN | DB2BGLGN | DB2BPNAME | CHAR | 8 | 0 | Group buffer pool ID | ||
3 | QBGBGSZ | DB2BGBGSZ | DB2INT4 | INT4 | 10 | 0 | Allocated group buffer pool size in 4KB increments | ||
4 | QBGBGDR | DB2BGBGDR | DB2INT4 | INT4 | 10 | 0 | The actual number of allocated directory entries | ||
5 | QBGBGDT | DB2BGBGDT | DB2INT4 | INT4 | 10 | 0 | The actual number of allocated data entries | ||
6 | QBGBGR1 | DB2BGBGR1 | DB2CHAR06 | CHAR | 6 | 0 | The current directory entry per data entry ratio | ||
7 | QBGBGR2 | DB2BGBGR2 | DB2CHAR06 | CHAR | 6 | 0 | The pending directory entry per data entry ratio | ||
8 | QBGBGCT | DB2BGBGCT | DB2INT4 | INT4 | 10 | 0 | Class castout threshold (%) | ||
9 | QBGBGGT | DB2BGBGGT | DB2INT4 | INT4 | 10 | 0 | Group buffer pool castout threshold (%) | ||
10 | QBGBGCK | DB2BGBGCK | DB2INT4 | INT4 | 10 | 0 | GBP checkpoint interval (GBPCHKPT) | ||
11 | QBGBGAS | DB2BGBGAS | DB2CHAR03L | CHAR | 3 | 0 | Current automatic recovery setting for the GBP | ||
12 | QBGBGCS | DB2BGBGCS8 | DB2CHAR03L | CHAR | 3 | 0 | Current group buffer pool cache (GBPCACHE) setting | ||
13 | QBGBDUP | DB2BGBDUP | DB2CHAR08L | CHAR | 8 | 0 | Duplex or simplex indication for the group buffer pool | ||
14 | QBGBGSZ2 | DB2BGBGSZ2 | DB2INT4 | INT4 | 10 | 0 | Allocated size of the sec. group buffer pool (in 4KB blocks) | ||
15 | QBGBGDR2 | DB2BGBGDR2 | DB2INT4 | INT4 | 10 | 0 | Number of allocated directory entries in the sec. GBP | ||
16 | QBGBGDT2 | 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 |