DBSTATIDB6 - DB6: Statistics for Indexes (Application Monitor)
DB6: Statistics for Indexes (Application Monitor) information is stored in SAP table DBSTATIDB6.
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 DBSTATIDB6
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| TNAME | Table name | X | TNAME | CHAR | 30 | * |
| DB6TOWNER | DB6: Schema Name | X | DB6SCHEMA | CHAR | 20 | |
| INAME | Index Name | X | CHAR | 18 | ||
| DB6IOWNER | DB6: Schema Name | X | DB6SCHEMA | CHAR | 20 | |
| ANDAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR | 12 | ||
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | ||
| DB6NLEAF | Number of Leaf Pages for an Index | INT4 | 4 | |||
| DB6NLEVELS | Number of Index Levels | INT2 | 2 | |||
| DB6ISIZE | 4-Byte Integer of Length 10 | INT4 | 4 |