Skip to Content
Information

This site will undergo a brief period of maintenance on Friday, 18 December at 12:30 AM Central/12:00 PM IST. During a 30 minute window, site availability may be intermittent.

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.

FSTHRESHOLD

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

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.

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