Limited supportBMC 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 LOADPLUS for DB2 13.1.

EXCHANGE


EXCHANGE tells LOADPLUS that you want to exchange the base and clone objects after the load process completes.

SWITCHTIME.png

If you specify EXCHANGE without a value, LOADPLUS assumes EXCHANGE NOW.

Restrictions

The following restrictions apply to the EXCHANGE option:

  • LOADPLUS terminates if you specify this option when loading an object other than a clone table.
  • When invoking DSNUTILB, LOADPLUS ignores this option.
  • If you specify SWITCHTIME and EXCHANGE, LOADPLUS uses the last keyword that it finds in the command string.

Additional considerations

The following considerations apply to the EXCHANGE option:

  • For load jobs that use staging data sets, LOADPLUS completes the renaming process before starting the exchange process.
  • If you are running jobs to load both the base and clone objects, and you specify EXCHANGE, run the jobs sequentially to avoid unexpected results.

NOW

EXCHANGE NOW tells LOADPLUS to begin the exchange process as soon as the load process is complete.

PAUSE

EXCHANGE PAUSE tells LOADPLUS to pause after the load process is complete. Use this option to control the timing of the exchange.

Restarting

You can restart the utility at the beginning of the UTILTERM phase by specifying RESTART or RESTART(PHASE) on your EXEC statement. Note the following information about restarting your job:

  • You do not need to change the EXCHANGE option on the LOAD command. When restarting an EXCHANGE PAUSE job, LOADPLUS ignores the PAUSE specification.
  • When you restart an EXCHANGE PAUSE job, the object must be in the same status that it was in during the original load job.

WTOR

EXCHANGE WTOR tells LOADPLUS to issue the following message to the MVS system console after the load process is complete, and to wait for a reply:

BMC51563A  JOB <jobName>, STEP <stepName>, FOR TABLESPACE <DBName>.<tableSpaceName>
           REACHED EXCHANGE. REPLY (G)O OR (P)AUSE

Specify G (or GO) to tell LOADPLUS to start the exchange process now. Specify P (or PAUSE) to tell LOADPLUS to pause. When you specify P in response to this message, LOADPLUS functions as if you specified EXCHANGE PAUSE.

 

 

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