DB6PMHXT - DB6: Detail Record of Tablespace and DB Table/Index Stats
DB6: Detail Record of Tablespace and DB Table/Index Stats information is stored in SAP table DB6PMHXT.
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 DB6PMHXT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | |
| STATTYPE | DB6: Type of statistics (D=daily,W=weekly,M=monthly) | X | CHAR | 1 | ||
| OBJECTNAME | DB6: Tablespace Name | X | DB6TSPNAME | CHAR | 30 | |
| BASEDATE | DB6: reference date of the statistics | X | DATS | 8 | ||
| TABLENUM | DB6: number of tables located in object | DEC | 12 | |||
| TABLEKB | DB6: total size of tables located in object | DEC | 12 | |||
| INDEXNUM | DB6: number of indexes located in object | DEC | 12 | |||
| INDEXKB | DB6: changes/interval for total size of indexes | DEC | 12 |