ORIGINALDISP


ORIGINALDISP allows you to specify the action that you want LOADPLUS to take after it has successfully renamed or switched the staging data sets and completed the load job.

ORIGINALDISP.png

This option is valid only if SHRLEVEL CHANGE (except an SQLAPPLY load) or SHRLEVEL REFERENCE is in effect.

For information about staging data sets, see Staging-data-sets.

Restriction

When invoking DSNUTILB, LOADPLUS ignores this option.

Specifying the default

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

DELETE

This option tells LOADPLUS to delete the original data sets.

RENAME

This option tells LOADPLUS to rename the original data sets to the staging data set names. LOADPLUS changes the OLD in the OLDDBC and OLDDBD node of the cluster and data component names to BMC.

This option allows you to preserve the space that was initially allocated for the original data sets by renaming them to the staging data set names. The renamed data sets are then ready to use as the staging data sets in a subsequent load process.

LOADPLUS ignores the ORIGINALDISP RENAME option if either of the following conditions exists:

  • You specify YES for the FASTSWITCH option.
  • You specify ZPARM for the FASTSWITCH installation option and the Db2 ZPARM value is YES.

In these cases, no rename is needed. The data sets keep their original names, and the space is preserved for use in a subsequent load job. For more details about the rename process, see Staging-data-sets-and-the-data-set-rename-process.


 

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