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.

Running LOAD REPLACE or LOAD RESUME YES PART n REPLACE

When you specify SHRLEVEL CHANGE with LOAD REPLACE or LOAD RESUME YES PART n REPLACE, the table space or partition that you are loading remains in read/write status while LOADPLUS loads the data to a staging data set.

After the load completes, LOADPLUS replaces the original object with the staging data set.

During the load process, the original object is available in read/write status. The original data sets are intact throughout the load process, allowing you to easily restart from a failure or make the objects available without having to recover the objects.

Warning

This type of load fully replaces the data in the table space (or partition), including any inserts, updates, or deletes to the base object that occur during the load process.

To run a SHRLEVEL CHANGE job with LOAD REPLACE or LOAD RESUME YES PART n REPLACE

  1. Depending on the value for your REDEFINE command or installation option, complete any staging data set tasks that are required as described in Staging-data-sets.
  2. Specify SHRLEVEL CHANGE.
  3. Determine whether to use the FASTSWITCH or rename process, and specify FASTSWITCH YES if applicable.For information about these processes, see Considerations-when-loading-Unicode-data. For information about the FASTSWITCH option, see FASTSWITCH.
  4. If necessary, specify a value for the ORIGINALDISP command option or ORIGDISP installation option.For more information about these options, see ORIGINALDISP or ORIGDISP=DELETE.
  5. (optional) Specify a value for the SWITCHTIME option.For information about this option, see SWITCHTIME.

Related topic

Running-LOADPLUS-jobs

 

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