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.

COPYLVL

COPYLVL tells LOADPLUS how to assign the dynamically allocated image copy data sets in certain cases. LOADPLUS uses this option only when dynamic allocation is active for copy data sets.

COPYLVL.png

The COPYLVL option applies to dynamically allocated copy data sets when either of the following conditions exist:

  • You are loading all partitions of a partitioned table space.
  • You are loading a subset of contiguous partitions by using the PART command option, and you specify YES for the COPYSUBSET installation option.

You can improve performance when loading partitioned table spaces by specifying COPYLVL PART.

Specifying the default

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

FULL

COPYLVL FULL tells LOADPLUS to allocate a single copy data set to contain all of the partitions being loaded.

Restrictions

LOADPLUS changes COPYLVL FULL to COPYLVL PART when any of the following conditions exists:

  • You specify a subset of partitions, but the value of the COPYSUBSET installation option is NO.
  • The value of the COPYSUBSET installation option is YES and you specify a subset of partitions, but they are not contiguous.

  • For XML copies, you specify LOAD RESUME YES (without PART REPLACE) COPY YES for a partition-by-growth XML table space.

    Important

    For base table space copies, LOADPLUS honors COPYLVL FULL.

PART

COPYLVL PART tells LOADPLUS to allocate individual copy data sets for each partition being loaded.

Restriction

This option is not valid when LOADPLUS invokes DSNUTILB (and you specify COPY YES). LOADPLUS issues message BMC50178E and terminates.

Additional considerations

Note the following considerations for this option:

  • If you are using a GDG name, each partition must have a different GDG base.
  • If you are loading more than 99 partitions, use the COPYDDN option to specify a ddname prefix for the copy data sets that results in eight characters or less after LOADPLUS appends the highest partition number. If you are also making remote copies, use the RECOVERYDDN option in the same way.
  • If you specify a tape device for the UNIT option, LOADPLUS allocates a tape unit for each partition.

Related topic

Copy-options

 

 

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