UNLOAD
The UNLOAD option controls the processing phases that REORG PLUS uses.
Based on this option, REORG PLUS either continues processing after the UNLOAD phase, suspends execution after the UNLOAD phase, or combines the UNLOAD and RELOAD phases into a single processing phase.
Specifying NOSYSREC is the same as specifying UNLOAD RELOAD.
RELOAD
UNLOAD RELOAD tells REORG PLUS to combine the UNLOAD and RELOAD phases into a single processing phase named REORG. In this single phase, REORG PLUS provides significant CPU and elapsed time savings over a two-phase reorganization. For performance benefits and considerations when using this single phase, see REORG-phase-for-a-single-phase-reorganization.
Additional considerations
The following considerations apply to UNLOAD RELOAD:
- If you specify UNLOAD RELOAD and want any VCAT-defined data sets to be deleted and redefined as part of the reorganization, the value of the REDEFINE command or installation option must be YES. You must also provide the necessary IDCAMS commands in the SYSIDCIN data set. For more information, see REDEFINE and SYSIDCIN-data-sets-in-REORG-PLUS.
- If you specify UNLOAD RELOAD with ORDER NO, see ORDER for more information about ORDER NO and the various types of reorganizations.
- When invoking DSNUTILB, REORG PLUS passes the value of this option to the IBM DB2 REORG utility as NOSYSREC.
CONTINUE
The CONTINUE option specifies that REORG PLUS continue with a two-phase reorganization process after the data has been unloaded.
Restriction
When you are reorganizing a LOB table space and SHRLEVEL REFERENCE is in effect, REORG PLUS changes UNLOAD CONTINUE to UNLOAD RELOAD.
PAUSE
This option does not apply to a SHRLEVEL CHANGE reorganization.
UNLOAD PAUSE instructs REORG PLUS to stop the processing after the data has been unloaded. You can then restart the job in the RELOAD phase. The PAUSE option is useful if you need to redefine data sets during reorganization.
Messages that are displayed at the end of the UNLOAD phase provide the estimated amount of space required to rebuild an index or reload a table space. Key compression of nonleaf pages is not considered when making these estimates.
If you specify UNLOAD PAUSE with SHRLEVEL REFERENCE for a partial reorganization with nonpartitioned indexes, copying the nonpartitioned indexes is deferred until the RELOAD phase following the restart.
Restrictions
REORG PLUS terminates when either of the following conditions exists:
- You are reorganizing a LOB table space and SHRLEVEL REFERENCE is in effect.
- You specify AUX YES to reorganize the base and LOB table space in a single job step.
Related topic