PREFORMAT

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

Related topic

Basic-LOADPLUS-processing-options

PREFORMAT.png

If you specify PREFORMAT without a value, LOADPLUS assumes PREFORMAT YES.

LOADPLUS also provides PREFORMAT support at the partition level. See PART.

Specifying the default

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

YES

If you specify PREFORMAT YES, LOADPLUS 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 LOADPLUS loads the data and builds the indexes.

For an SQLAPPLY load, LOADPLUS ignores this option and issues message BMC50109I.

When invoking DSNUTILB, LOADPLUS passes this option to the IBM Db2 LOAD utility as PREFORMAT.

NO

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

Restriction

When invoking DSNUTILB, LOADPLUS ignores this option.


 

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