DB4INDEX_HIST - History of Index Sizes in the Database
History of Index Sizes in the Database information is stored in SAP table DB4INDEX_HIST.
It is part of development package STU4 in software component BC-DB-DB4. This development package consists of objects that can be grouped under "CCMS / AS/400".
It is part of development package STU4 in software component BC-DB-DB4. This development package consists of objects that can be grouped under "CCMS / AS/400".
Fields for table DB4INDEX_HIST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| DBHOST | Application Server | X | SYHOST | CHAR | 64 | |
| SCHEMANAME | X | CHAR | 20 | |||
| INDNAME | Database index | X | DBINDEX_D | CHAR | 80 | |
| ANDAT | Analysis date (yyyymmddhhmm) | X | AM_DATE | CHAR | 24 | |
| INDNAME_LONG | Database index | X | DBINDEX_D | CHAR | 80 | |
| VWTYP | Single-Character Flag | CHAR1 | CHAR | 2 | ||
| INDSIZE | Total blocks of an index (kb) | IBLOCKS_KB | DEC | 6 | ||
| CRTDATE | Date | DATUM | DATS | 16 | ||
| CRTTIME | Character field of length 6 | CHAR6 | CHAR | 12 | ||
| SAVDATE | Date | DATUM | DATS | 16 | ||
| SAVTIME | Character field of length 6 | CHAR6 | CHAR | 12 | ||
| RSTDATE | Date | DATUM | DATS | 16 | ||
| RSTIME | Character field of length 6 | CHAR6 | CHAR | 12 | ||
| INDTABLE | Table name | TNAME | CHAR | 60 | ||
| INDTABLE_LONG | Table name | TNAME | CHAR | 60 |