DB6PMHXTHD - DB6: Summary Rec. of Tablespace and DB Table/Index Stats
DB6: Summary Rec. of Tablespace and DB Table/Index Stats information is stored in SAP table DB6PMHXTHD.
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 DB6PMHXTHD
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 | |
| TABLENUM | DB6: number of tables located in object | DEC | 12 | |||
| C_TABLENUM | DB6: changes/interval for number of tables | DEC | 12 | |||
| TABLEKB | DB6: total size of tables located in object | DEC | 12 | |||
| C_TABLEKB | DB6: changes/interval for total size of tables | DEC | 12 | |||
| INDEXNUM | DB6: number of indexes located in object | DEC | 12 | |||
| C_INDEXNUM | DB6: changes/interval for number of indexes | DEC | 12 | |||
| INDEXKB | DB6: total size of indexes located in object | DEC | 12 | |||
| C_INDEXKB | DB6: changes/interval for total size of indexes | DEC | 12 |