DB2REOIX - REORG of Indexes
REORG of Indexes information is stored in SAP table DB2REOIX.
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
It is part of development package STU2 in software component BC-DB-DB2. This development package consists of objects that can be grouped under "CCMS for DB2 for OS/390".
Fields for table DB2REOIX
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| IXCREATOR | Authorization ID of the creator of the partitioned index | X | DB2CREATPI | CHAR | 8 | |
| IXNAME | Name of a DB2 for OS/390 index | X | DB2IDXNAME | CHAR | 18 | |
| IXPARTS | Number of partition | X | DB2PARTNRI | INT4 | 4 | |
| NOREORG | A reorg should never work on this tablespace or index | DB2NOREORG | CHAR | 1 | ||
| NEEDREORG | State if a reorg is needed (Y/N) | DB2REONEED | CHAR | 1 |