Limited supportBMC provides limited support for this version of the product. As a result, BMC no longer accepts comments in this space. If you encounter problems with the product version or the space, contact BMC Support.BMC recommends upgrading to the latest version of the product. To see documentation for that version, see REORG PLUS for DB2 13.1.

UNLOAD


The UNLOAD option controls the processing phases that REORG PLUS uses.

UNLOAD.png

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.

Important

If you are performing a partial reorganization (not reorganizing all partitions of a partitioned table space), do not redefine the nonpartitioned index data sets. REORG PLUS does not rebuild these data sets during a partial reorganization, but only updates them.

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.

 

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*