DB6PMHSB - DB6: Buffer Pool Statistics History
DB6: Buffer Pool Statistics History information is stored in SAP table DB6PMHSB.
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".
It is part of development package STU6 in software component BC-DB-DB6. This development package consists of objects that can be grouped under "DB6: Performance-Monitor (UNIX/Windows)".
Fields for table DB6PMHSB
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | |
| COMPTIME | DB6: Timestamp (Format: YYYYMMDDHHMMSS) | X | DB6TSTAMP | CHAR | 14 | |
| PARTITN | DB6: partition number | X | INT4 | 4 | ||
| BP_NAME | DB6: General identifier | X | DB6IDENT | CHAR | 20 | |
| BP_SZ | Total Buffer Pool Size (KB) | DEC | 12 | |||
| BP_QAL | Overall Buffer Quality (%) | DEC | 5 | |||
| PL_D_LRS | Data Logical Reads | DEC | 12 | |||
| PL_D_PRS | Data Physical Reads | DEC | 12 | |||
| PL_I_LRS | Index Logical Reads | DEC | 12 | |||
| PL_I_PRS | Index Physical Reads | DEC | 12 | |||
| PL_TD_LRS | pool_temp_data_l_reads | DEC | 12 | |||
| PL_TD_PRS | pool_temp_data_p_reads | DEC | 12 | |||
| PL_TI_LRS | pool_temp_index_l_reads | DEC | 12 | |||
| PL_TI_PRS | pool_temp_index_p_reads | DEC | 12 | |||
| PL_D_WS | Data Physical Writes | DEC | 12 | |||
| PL_I_WS | Index Physical Writes | DEC | 12 | |||
| AUTOSIZE | AUTOMATIC flag | CHAR | 1 |