FASTSWITCH
This option is valid only if SHRLEVEL CHANGE (except an SQLAPPLY load) or SHRLEVEL REFERENCE is in effect. For more information about FASTSWITCH processing, see Staging-data-sets-and-the-FASTSWITCH-process.
When invoking DSNUTILB, the value in DSNZPARM is used for this option.
Specifying the default
You can specify the default for the FASTSWITCH command option in your installation options module by using the FASTSWITCH installation option. LOADPLUS was shipped with a default value of NO for this option. The command overrides the default that is in the installation options module.
YES
YES tells LOADPLUS to bypass the VSAM rename process and points the Db2 catalog to the staging data sets.
Restriction
When loading clone tables or base objects that participate (or have participated) in a clone relationship, LOADPLUS changes FASTSWITCH YES to FASTSWITCH NO.
Additional considerations
Consider the following information before using the FASTSWITCH process:
- We recommend using the FASTSWITCH process when you are loading objects with more than 200 data sets, such as a segmented table space that contains many tables that each have an index.
- The FASTSWITCH process requires updates to the Db2 catalog and directory. In some environments, LOADPLUS might have difficulty acquiring the necessary locks, which results in contention or deadlocks. Minimizing the use of the FASTSWITCH process can reduce this contention and allow the process to be more effective when it is needed. Frequently reorganizing the Db2 catalog and directory can also help prevent contention.
NO
NO tells LOADPLUS to rename the staging data sets to the names of the original data sets.