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.

LOADDN


The LOADDN option allows you to override the default ddname (SORTOUT) or ddname prefix for the output data set from the PRELOAD phase.

LOADDN.png

For more information about these data sets, see SORTOUT-data-sets-in-LOADPLUS.

If you use this command option to override the default name in the installation options module, you must also change the ddname in your JCL.

Multiple data sets

For multiple SORTOUT data sets, specify only the ddname prefix (no n) in this option. Note the following considerations:

  • If you are not dynamically allocating output data sets, you must append n to the ddnames in the DD statements in your JCL, where n is any valid alphanumeric or national character. These ddnames must not exceed eight characters.
  • If you are not dynamically allocating output data sets, the prefix must allow LOADPLUS to differentiate it from any ddnames that you specify in your JCL for other data sets. For example, if you specify a LOADDN prefix of SYSU and your JCL contains a DD statement for your work data set that uses a ddname of SYSUT1, LOADPLUS assumes that the SYSU prefix refers to the SYSUT1 data set.
  • When you dynamically allocate SORTOUT data sets, LOADPLUS appends the data set number to the ddname prefix that you specify. To dynamically allocate more than nine SORTOUT data sets, use this option to specify a ddname prefix. The prefix plus the highest data set number must not exceed eight characters. For more information, see Specifying ddname prefixes.
  • If dynamic data set allocation is active and you specify more than one ddname prefix for dynamic allocation, the prefix for each ddname must be different enough for LOADPLUS to differentiate one prefix from another. To be different enough, if these prefixes are different only because one prefix has additional trailing bytes, then these trailing bytes must contain at least one nonnumeric byte. For example, the first set of prefixes that follow is different enough, but the second set is not:
    • Acceptable set:

      BMCRD
      BMCRDWK
    • Unacceptable set:

      BMCRD
      BMCRD11

Additional considerations

The following considerations apply to the LOADDN option:

  • If you specify or default to a prefix with a length of 7 or more characters, and the value for the SMAX installation option is greater than 9, LOADPLUS reduces the value of SMAX to 9.
  • When invoking DSNUTILB, LOADPLUS uses this option only to pass a value for the &DDNAME variable for the data set name pattern. LOADPLUS includes this information in the TEMPLATE control statement that it builds for the IBM Db2 LOAD utility.

Specifying the default

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

 

 

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