Restart of REORG INDEX
You can restart a REORG INDEX utility job.
If you restart REORG in the outlined phase, it re-executes from the beginning of the phase. Db2 always uses RESTART(PHASE) by default unless you restart the job in the UNLOAD phase. In this case, Db2 uses RESTART(CURRENT) by default.
If REORG abnormally terminates or a system failure occurs while it is in the UTILTERM phase, you must restart the job with RESTART(PHASE).
The following table provides information about restarting REORG INDEX. For each phase of REORG and for each type of REORG INDEX (with SHRLEVEL NONE, with SHRLEVEL REFERENCE, and with SHRLEVEL CHANGE), the table indicates the types of restart that are allowed (CURRENT and PHASE). None indicates that no restart is allowed. The "Data sets required" column lists the data sets that must exist to perform the specified type of restart in the specified phase.
Phase | Type of restart allowed for SHRLEVEL NONE | Type of restart allowed for SHRLEVEL REFERENCE | Type of restart allowed for SHRLEVEL CHANGE | Data sets required | Notes |
---|---|---|---|---|---|
UNLOAD | CURRENT, PHASE | CURRENT, PHASE | None | SYSUT1 | |
BUILD | CURRENT, PHASE | CURRENT, PHASE | None | SYSUT1 | 1 |
LOG | Phase does not occur | Phase does not occur | None | None | |
SWITCH | Phase does not occur | CURRENT, PHASE | CURRENT, PHASE | originals and shadows | 1 |
Note:
|
Phase | RESTART CURRENT | RESTART PHASE |
---|---|---|
UTILINIT | No | Yes |
UNLOAD | No | Yes |
BUILD | No | Yes |