Skip to Content

Default language.

Information
Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

PREFORMAT

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

Related topic

Basic REORG PLUS processing options

 

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.

 

 

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

REORG PLUS for DB2 13.1