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.

FSTHRESHOLD

The FSTHRESHOLD option provides a threshold above which REORG PLUS performs FASTSWITCH processing.

Related topic

Basic REORG PLUS processing options

 

FSTHRESHOLD.png

This option applies to SHRLEVEL REFERENCE or SHRLEVEL CHANGE.

If the number of staging data sets used in a single reorganization is greater than or equal to this value, REORG PLUS performs FASTSWITCH processing. Otherwise, REORG PLUS performs rename processing.

You can specify a value from 0 through 32767. A value of 0 tells REORG PLUS to always perform FASTSWITCH processing.

Restrictions

REORG PLUS ignores this option when either of the following conditions exists:

  • FASTSWITCH NO is in effect.
  • Pending definition changes exist on the object that you are reorganizing.

Specifying the default

You can specify the default for the FSTHRESHOLD command option in your installation options module by using the FSTHRESHOLD 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.

 

 

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

REORG PLUS for DB2 13.1