| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | CREATOR | Creator of BP tuning settings ( = SAP for default settings ) | nvarchar | 12 | 0 | CHAR | (N' ') | No | | DB2BPCUST | Allow NULL? |
| 2 | CREATEDATE | System Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | SYDATUM | Allow NULL? |
| 3 | CREATETIME | System Time | nvarchar | 6 | 0 | TIMS | (N'000000') | No | | SYUZEIT | Allow NULL? |
| 4 | QDBPNM | Name of buffer pool | nvarchar | 8 | 0 | CHAR | (N' ') | No | | DB2DBPNM | Allow NULL? |
| 5 | CATEGORY | DB2 for OS/390: Table category | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | DB2TABCAT | Allow NULL? |
| 6 | QDBPVPSZ | The size of the virtual buffer pool | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPVPSZ | Allow NULL? |
| 7 | QDBPHPSZ | The size of the hiperpool | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPHPSZ | Allow NULL? |
| 8 | QDBPVPSH | The sequential steal threshold for the virtual buffer pool | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPVPSH | Allow NULL? |
| 9 | QDBPHPSH | The sequential steal threshold for the hiperpool | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPHPSH | Allow NULL? |
| 10 | QDBPDWQT | The deferred write threshold for the virtual buffer pool | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPDWQT | Allow NULL? |
| 11 | QDBPVDQT | The vertical deferred write threshold for the virtual BP | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPVDQT | Allow NULL? |
| 12 | QDBPCAST | CASTOUT attribute | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | DB2DBPCAST | Allow NULL? |
| 13 | QDBPPSQT | Parallel I/O sequential steal threshold for virtual BP | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPPSQT | Allow NULL? |
| 14 | QDBPXSQT | Assisting parallel sequential threshold | int | 10 | 0 | INT4 | ((0)) | Yes | | DB2DBPXSQT | Allow NULL? |
| 15 | QDBPRES1 | Field type char, length 1, reserved | char | 1 | 0 | CHAR | (N' ') | Yes | | DB2RES01 | Allow NULL? |
| 16 | TABCATDES | Table category description | nvarchar | 44 | 0 | CHAR | (N' ') | Yes | | DB2TCATDES | Allow NULL? |
| 17 | VPTYPE | | nvarchar | 15 | 0 | | (N' ') | Yes | | | Allow NULL? |
