Restart of REORG TABLESPACE
You can restart a REORG TABLESPACE utility job.
By default, Db2 uses RESTART(CURRENT) when restarting REORG TABLESPACE jobs, with the following exceptions:
- Jobs that are restarted in the SORT, BUILD, or SWITCH phase use RESTART(PHASE) by default.
- Jobs with the SORTKEYS option that are restarted in the RELOAD, SORT, BUILD, or SORTBLD phase always restart from the beginning of the RELOAD phase.
- Jobs with the SHRLEVEL REFERENCE, NOSYSREC, and SORTDATA options use RESTART(PHASE) to restart at the beginning of the UNLOAD phase.
- Jobs with unload parallelism for REORG TABLESPACE SHRLEVEL NONE use RESTART(PHASE) to restart at the beginning of the UNLOAD and RELOAD phases.
- Jobs that reorganize LOB table spaces use RESTART(PHASE).
If you restart a REORG job of one or more of the catalog or directory table spaces in the preceding list, you cannot use RESTART(CURRENT).
If you restart REORG in the UTILINIT phase, it re-executes from the beginning of the phase. If REORG abnormally terminates or 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 TABLESPACE,
depending on the phase that REORG was in when the job stopped. For
each phase of REORG and for each type of REORG TABLESPACE (with SHRLEVEL
NONE, with SHRLEVEL REFERENCE, and with SHRLEVEL CHANGE), the following
table indicates the types of restarts that are allowed (CURRENT and
PHASE). A value of 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 | Required data sets | Notes |
---|---|---|---|---|---|
UNLOAD | CURRENT, PHASE | CURRENT, PHASE6 | None | SYSREC | 7 |
RELOAD | CURRENT, PHASE | CURRENT, PHASE6 | None | SYSREC | 1, 2, 7 |
SORT | CURRENT, PHASE | CURRENT, PHASE6 | None | None | 2, 3, 7 |
BUILD | CURRENT, PHASE | CURRENT, PHASE6 | None | None | 2, 3, 4, 7 |
SORTBLD | CURRENT, PHASE | CURRENT, PHASE6 | None | None | 2, 7 |
LOG | Phase does not occur | Phase does not occur6 | None | None | 7 |
SWITCH | Phase does not occur | CURRENT, PHASE | CURRENT, PHASE | Originals and shadows | 3, 5, 7 |
Note:
|
Phase | CURRENT | PHASE |
---|---|---|
UTILINIT | NO | YES |
UNLOAD | NO | YES |
RELOAD | NO | YES |
SORT | NO | NO |
BUILD | NO | YES |
SORTBLD | NO | YES |