DB2BPTUNE - DB2/390: Buffer Pool Tuning Settings
DB2/390: Buffer Pool Tuning Settings information is stored in SAP table DB2BPTUNE.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2BPTUNE
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| CREATOR | Creator of BP tuning settings ( = SAP for default settings ) | X | DB2BPCUST | CHAR | 12 | |
| CREATEDATE | System Date | X | SYDATUM | DATS | 8 | |
| CREATETIME | System Time | X | SYUZEIT | TIMS | 6 | |
| QDBPNM | Name of buffer pool | X | DB2DBPNM | CHAR | 8 | |
| CATEGORY | DB2 for OS/390: Table category | DB2TABCAT | CHAR | 2 | ||
| QDBPVPSZ | The size of the virtual buffer pool | DB2DBPVPSZ | INT4 | 4 | ||
| QDBPHPSZ | The size of the hiperpool | DB2DBPHPSZ | INT4 | 4 | ||
| QDBPVPSH | The sequential steal threshold for the virtual buffer pool | DB2DBPVPSH | INT4 | 4 | ||
| QDBPHPSH | The sequential steal threshold for the hiperpool | DB2DBPHPSH | INT4 | 4 | ||
| QDBPDWQT | The deferred write threshold for the virtual buffer pool | DB2DBPDWQT | INT4 | 4 | ||
| QDBPVDQT | The vertical deferred write threshold for the virtual BP | DB2DBPVDQT | INT4 | 4 | ||
| QDBPCAST | CASTOUT attribute | DB2DBPCAST | CHAR | 6 | ||
| QDBPPSQT | Parallel I/O sequential steal threshold for virtual BP | DB2DBPPSQT | INT4 | 4 | ||
| QDBPXSQT | Assisting parallel sequential threshold | DB2DBPXSQT | INT4 | 4 | ||
| QDBPRES1 | Field type char, length 1, reserved | DB2RES01 | CHAR | 1 | ||
| TABCATDES | Table category description | DB2TCATDES | CHAR | 44 | ||
| VPTYPE | Location of buffer pool: primary (DBM1) or data space | CHAR | 15 |