SAP ABAP Table DB2BPTUNE (DB2/390: Buffer Pool Tuning Settings)
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
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 | TRANSP | Transparent table |
| Transparent table | DB2BPTUNE |
Table Relationship Diagram 
|
| Short Description | DB2/390: Buffer Pool Tuning Settings |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | E | Control table, SAP and customer have separate key areas |
| Data Browser/Table View Maintenance | X | Display/Maintenance Allowed |
Components
 |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  CREATOR |
DB2BPCUST | DB2CHAR12 | CHAR | 12 | 0 | Creator of BP tuning settings ( = SAP for default settings ) | ||
| 2 | CREATEDATE |
SYDATUM | SYDATS | DATS | 8 | 0 | System Date | ||
| 3 | CREATETIME |
SYUZEIT | SYTIME | TIMS | 6 | 0 | System Time | ||
| 4 | QDBPNM |
DB2DBPNM | CHAR8 | CHAR | 8 | 0 | Name of buffer pool | ||
| 5 | CATEGORY |
DB2TABCAT | DB2TABCAT | CHAR | 2 | 0 | DB2 for OS/390: Table category | ||
| 6 | QDBPVPSZ |
DB2DBPVPSZ | INT4 | 10 | 0 | The size of the virtual buffer pool | |||
| 7 | QDBPHPSZ |
DB2DBPHPSZ | INT4 | 10 | 0 | The size of the hiperpool | |||
| 8 | QDBPVPSH |
DB2DBPVPSH | DB2INT4 | INT4 | 10 | 0 | The sequential steal threshold for the virtual buffer pool | ||
| 9 | QDBPHPSH |
DB2DBPHPSH | INT4 | 10 | 0 | The sequential steal threshold for the hiperpool | |||
| 10 | QDBPDWQT |
DB2DBPDWQT | DB2INT4 | INT4 | 10 | 0 | The deferred write threshold for the virtual buffer pool | ||
| 11 | QDBPVDQT |
DB2DBPVDQT | INT4 | 10 | 0 | The vertical deferred write threshold for the virtual BP | |||
| 12 | QDBPCAST |
DB2DBPCAST | CHAR6 | CHAR | 6 | 0 | CASTOUT attribute | ||
| 13 | QDBPPSQT |
DB2DBPPSQT | DB2INT4 | INT4 | 10 | 0 | Parallel I/O sequential steal threshold for virtual BP | ||
| 14 | QDBPXSQT |
DB2DBPXSQT | DB2INT4 | INT4 | 10 | 0 | Assisting parallel sequential threshold | ||
| 15 | QDBPRES1 |
DB2RES01 | DB2CHAR01 | CHAR | 1 | 0 | Field type char, length 1, reserved | ||
| 16 | TABCATDES |
DB2TCATDES | DB2CHAR44 | CHAR | 44 | 0 | Table category description | ||
| 17 | VPTYPE |
CHAR | 15 | 0 |
History
| Last changed by/on | SAP | 20130604 |
| SAP Release Created in | 620 |
