DB6IREORG - DB6: Database REORG Check Information: Indexes
DB6: Database REORG Check Information: Indexes information is stored in SAP table DB6IREORG.
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 DB6IREORG
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| SYSID | Name of SAP System | X | SYSYSID | CHAR | 8 | |
| DB6IOWNER | DB6: Schema Name | X | DB6SCHEMA | CHAR | 20 | |
| DB6INAME | Index Name | X | CHAR | 128 | ||
| DB6TOWNER | DB6: Schema Name | DB6SCHEMA | CHAR | 20 | ||
| DB6TNAME | Table Name | CHAR | 128 | |||
| DB6TSPACE | Tablespace Name | CHAR | 18 | |||
| DB6CARD | Cardinality (Number of Rows) in a Table | CHAR | 10 | |||
| DB6ISIZE | Index Size | INT4 | 4 | |||
| DB6F4 | Formula 4 of REORGCHK Analysis | CHAR | 3 | |||
| DB6F5 | Formula 5 of REORGCHK Analysis | CHAR | 3 | |||
| DB6F6 | Formula 6 of REORGCHK Analysis | CHAR | 3 | |||
| DB6REORG | REORGCHK - Recommendation | CHAR | 3 | |||
| DB6DATETIM | DBA: ISO conform timestamp with ms precission | DB6DATETIM | CHAR | 26 | ||
| DB6ITYPE | Type of Index: U=unique P=primary D=duplicates | CHAR | 1 | |||
| DB6F7 | INT4 | 4 | ||||
| DB6F8 | INT4 | 4 | ||||
| DB6REORG2 | CHAR | 2 |