SAP Table DB2REOIX
REORG of Indexes
The table DB2REOIX (REORG of Indexes) is a standard table in SAP ERP.
It belongs to the package STU2.
Technical Information
| Table |
DB2REOIX |
| Short Text |
REORG of Indexes |
| Package |
STU2
|
| Table Type |
Transparent Table
|
Fields for Table DB2REOIX
| Field Name |
Key |
Description |
Data Element |
Type |
Length |
Check Table |
| IXCREATOR |
✔ |
Authorization ID of the creator of the partitioned index |
DB2CREATPI |
CHAR |
8 |
|
| IXNAME |
✔ |
Name of a DB2 for OS/390 index |
DB2IDXNAME |
CHAR |
18 |
|
| IXPARTS |
✔ |
Number of partition |
DB2PARTNRI |
INT4 |
10 |
|
| 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 |
|