Skip to Content
Information
Limited support BMC 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.

PREFORMAT

The PREFORMAT option tells REORG PLUS whether to preformat the unused pages of the data set.

PREFORMAT.png

If you specify PREFORMAT without a value, REORG PLUS assumes PREFORMAT YES.

For information about PREFORMAT and the SYSIDCIN data set, see SYSIDCIN-data-sets-in-REORG-PLUS.

Specifying the default

You can specify the default for the PREFORMAT command option in your installation options module by using the PREFORMAT installation option. REORG PLUS was shipped with a default value of NO for this option. The command overrides the default that is in the installation options module.

YES

If you specify PREFORMAT YES, REORG PLUS preformats the unused portion of the data set, writing full pages that have been initialized with zeros up to the high-allocated RBA of the table space and index spaces. Preformatting occurs after REORG PLUS reorganizes the data and indexes.

When invoking DSNUTILB, REORG PLUS handles this option as follows:

  • For a LOB table space, REORG PLUS ignores this option.
  • For all other objects, REORG PLUS passes this option to the IBM Db2 REORG utility as PREFORMAT.

Restriction

When reorganizing a catalog object, REORG PLUS changes this option to PREFORMAT NO.

NO

If you specify PREFORMAT NO, REORG PLUS does not preformat the unused pages.

Restriction

When invoking DSNUTILB, REORG PLUS ignores this option.

Related topic

Basic-REORG-PLUS-processing-options

 

 

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

REORG PLUS for DB2 11.2