DBSTATTDB6 - DB6: Table Statistics for Application Monitor
DB6: Table Statistics for Application Monitor information is stored in SAP table DBSTATTDB6.
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 DBSTATTDB6
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 | |
| ANDAT | Analysis date (yyyymmddhhmm) | AM_DATE | CHAR | 12 | ||
| VWTYP | Type of Usage of Table Entry | AM_VWTYP | CHAR | 2 | ||
| AMETH | Analysis Method for Collecting Statistics | AM_AMETH | CHAR | 4 | ||
| OPTIO | Sample Size for Collection of Statistics | AM_OPTIO | CHAR | 5 | ||
| DB6CARD | Cardinality (Number of Rows) in a Table | CHAR | 10 | |||
| DB6FPAGES | Total Number of Pages Allocated to a Table | INT4 | 4 | |||
| DB6NPAGES | Total Number of Pages Containing Table Data | INT4 | 4 | |||
| DB6TSIZE | Table Size | INT4 | 4 |