Running SHRLEVEL REFERENCE

When you specify SHRLEVEL REFERENCE, LOADPLUS places the object that you are loading in read-only status while it 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-only status. During the brief rename or FASTSWITCH process, which occurs in the UTILTERM phase, the object is stopped. This non-destructive process leaves the original data sets intact throughout the load process and allows you to easily restart from a failure or make the objects available without having to recover the objects.

Related topics

Running-LOADPLUS-jobs

SHRLEVEL-considerations

Before you begin

Ensure that the job that you are going to run will not invoke DSNUTILB. If you specify SHRLEVEL REFERENCE for a load job that invokes DSNUTILB, LOADPLUS issues message BMC50178E and terminate.

For LOAD RESUME YES, LOADPLUS uses the Instant Snapshot capability of XBM or SUF to create the staging data set. Ensure that you meet the following requirements:

  • You must be using one of the intelligent storage devices that XBM or SUF supports (as documented in the SNAPSHOT UPGRADE FEATURE for DB2).
  • You must have sufficient DASD available to create an Instant Snapshot of the table space or partitions that you are loading and the participating indexes.
  • The storage group on which the table space is defined must contain volumes from a single vendor, and all volumes in that storage group must support Instant Snapshots.

To run a SHRLEVEL REFERENCE load job

  1. (LOAD RESUME YES only) Ensure that the intelligent storage device that you are using for the Instant Snapshot is set up and running correctly.For details, see the SNAPSHOT UPGRADE FEATURE for DB2.
  2. (LOAD RESUME YES only) Ensure that XBM or SUF is available and enabled:
    1. Ensure that a currently supported version of XBM or SUF (as described in System-and-software-requirements) is installed and available to LOADPLUS.XBM and SUF require a started task.
    2. Set the appropriate SSI options in XBM or SUF, as described in the SNAPSHOT UPGRADE FEATURE for DB2.
    3. Create and activate the XBM management set that contains the appropriate snapshot template.For more information, see the SNAPSHOT UPGRADE FEATURE for DB2.
    4. (optional) Use the XBMID installation or command option to specify the XBM subsystem that you want to use for snapshot processing.
  3. Depending on the value in effect for the REDEFINE option, complete any staging data set tasks that are required as described in Staging-data-sets.
  4. Specify SHRLEVEL REFERENCE.
  5. Determine whether to use the FASTSWITCH or rename process and specify FASTSWITCH YES if applicable.For information about these processes, see Staging-data-sets. For information about the FASTSWITCH option, see FASTSWITCH.
  6. 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.
  7. (optional) Specify a value for the SWITCHTIME option.For information about this option, see SWITCHTIME.

 

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