SAP Table DB2REOIDX
REORG INDEX Parameters
DB2REOIDX (REORG INDEX Parameters) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link DB2REOIDX to other SAP tables.
Source: DB2REOIDX (REORG INDEX Parameters)
DB2REOIDX table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IXNAME | Name of the index to be reorganized | DB2RIXIX | CHAR | 18 | 0 | |||||||||
| IXCREATOR | Creator of the index to be reorganized | DB2RIXCRE | CHAR | 8 | 0 | |||||||||
| PARTNO | Number of the partition to be reorganized | DB2RTSPART | INT2 | 5 | 0 | |||||||||
| SHRLEVEL | SHRLEVEL parameter of the REORG utility | DB2RTSSHR | CHAR | 10 | 0 | |||||||||
| DEADLINE | DEADLINE parameter of the REORG utility | DB2RTSDEAD | CHAR | 26 | 0 | |||||||||
| MAXRO | MAXRO parameter of the REORG utility | DB2RTSMRO | CHAR | 10 | 0 | |||||||||
| LONGLOG | LONGLOG parameter of the REORG utility | DB2RTSLLOG | CHAR | 8 | 0 | |||||||||
| DELAY | DELAY parameter of the REORG utility | DB2RTSDLAY | CHAR | 10 | 0 | |||||||||
| UNLOAD | UNLOAD parameter of the REORG utility | DB2RTSUNLD | CHAR | 8 | 0 | |||||||||
| RECDSN | Dataset allocated to the SYSREC DDNAME | DB2RECDSN | CHAR | 54 | 0 | |||||||||
| RECDEVT | Device on which the SYSREC dataset resides | DB2RECDEVT | CHAR | 8 | 0 | |||||||||
| RECSPACE | Primary space allocation for the SYSREC dataset (cylinders) | DB2RECSPC | INT2 | 5 | 0 | |||||||||
| WORKDSN1 | Dataset allocated to the SYSUT1 DDNAME | DB2WK1DSN | CHAR | 54 | 0 | |||||||||
| WORKDEVT1 | Device on which the SYSUT1 dataset resides | DB2WK1DEVT | CHAR | 8 | 0 | |||||||||
| WORKSPACE1 | Primary space allocation for the SYSUT1 dataset (cyl.) | DB2WK1SPC | INT2 | 5 | 0 | |||||||||
| WORKDSN2 | Dataset allocated to the SORTOUT DDNAME | DB2WK2DSN | CHAR | 54 | 0 | |||||||||
| WORKDEVT2 | Device on which the SORTOUT dataset resides | DB2WK2DEVT | CHAR | 8 | 0 | |||||||||
| WORKSPACE2 | Primary space allocation for the SORTOUT dataset (cyl.) | DB2WK2SPC | INT2 | 5 | 0 | |||||||||
| SORTDEVT | Device type for temporary datasets allocated by DFSORT | DB2SRTDEVT | CHAR | 8 | 0 | |||||||||
| SORTNUM | Number of temporary datasets allocated by DFSORT | DB2SRTNUM | INT4 | 10 | 0 | |||||||||
| PREFORMAT | PREFORMAT option of the REORG utility | DB2RTSPREF | CHAR | 1 | 0 |
Possible values
|
||||||||
| RESTART | Whether & at which point a current utility job is restarted | DB2RESTART | CHAR | 8 | 0 |
Possible values
|
||||||||
