SAP table DB2REOIDX (REORG INDEX Parameters)
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IXNAME | Name of the index to be reorganized | CHAR | 18 | 0 | DB2RIXIX | ||||||||
| IXCREATOR | Creator of the index to be reorganized | CHAR | 8 | 0 | DB2RIXCRE | ||||||||
| PARTNO | Number of the partition to be reorganized | INT2 | 5 | 0 | DB2RTSPART | ||||||||
| SHRLEVEL | SHRLEVEL parameter of the REORG utility | CHAR | 10 | 0 | DB2RTSSHR | ||||||||
| DEADLINE | DEADLINE parameter of the REORG utility | CHAR | 26 | 0 | DB2RTSDEAD | ||||||||
| MAXRO | MAXRO parameter of the REORG utility | CHAR | 10 | 0 | DB2RTSMRO | ||||||||
| LONGLOG | LONGLOG parameter of the REORG utility | CHAR | 8 | 0 | DB2RTSLLOG | ||||||||
| DELAY | DELAY parameter of the REORG utility | CHAR | 10 | 0 | DB2RTSDLAY | ||||||||
| UNLOAD | UNLOAD parameter of the REORG utility | CHAR | 8 | 0 | DB2RTSUNLD | ||||||||
| RECDSN | Dataset allocated to the SYSREC DDNAME | CHAR | 54 | 0 | DB2RECDSN | ||||||||
| RECDEVT | Device on which the SYSREC dataset resides | CHAR | 8 | 0 | DB2RECDEVT | ||||||||
| RECSPACE | Primary space allocation for the SYSREC dataset (cylinders) | INT2 | 5 | 0 | DB2RECSPC | ||||||||
| WORKDSN1 | Dataset allocated to the SYSUT1 DDNAME | CHAR | 54 | 0 | DB2WK1DSN | ||||||||
| WORKDEVT1 | Device on which the SYSUT1 dataset resides | CHAR | 8 | 0 | DB2WK1DEVT | ||||||||
| WORKSPACE1 | Primary space allocation for the SYSUT1 dataset (cyl.) | INT2 | 5 | 0 | DB2WK1SPC | ||||||||
| WORKDSN2 | Dataset allocated to the SORTOUT DDNAME | CHAR | 54 | 0 | DB2WK2DSN | ||||||||
| WORKDEVT2 | Device on which the SORTOUT dataset resides | CHAR | 8 | 0 | DB2WK2DEVT | ||||||||
| WORKSPACE2 | Primary space allocation for the SORTOUT dataset (cyl.) | INT2 | 5 | 0 | DB2WK2SPC | ||||||||
| SORTDEVT | Device type for temporary datasets allocated by DFSORT | CHAR | 8 | 0 | DB2SRTDEVT | ||||||||
| SORTNUM | Number of temporary datasets allocated by DFSORT | INT4 | 10 | 0 | DB2SRTNUM | ||||||||
| PREFORMAT | PREFORMAT option of the REORG utility | CHAR | 1 | 0 | DB2RTSPREF | ||||||||
| RESTART | Whether & at which point a current utility job is restarted | CHAR | 8 | 0 | DB2RESTART |
|