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.

EXPDT


Specify EXPDT to set an expiration date for certain data sets that you are dynamically allocating.

EXPDT.png

This option applies to the following data sets:

  • Copy data sets
  • SYSDISC data sets
  • SYSERR data sets
  • SYSMAP data sets

LOADPLUS ignores this option for any other data sets.

The value of date must be in the format yyyyddd or yyyy/ddd. The variable yyyy is the 4-digit year (1900 through 2155) and ddd is the 3-digit Julian day (000 through 366).

Additional considerations

The following considerations apply to the EXPDT option:

  • If DELETEFILES YES is in effect, LOADPLUS deletes your SYSERR data set only if the expiration date is earlier than the current date.
  • If DELETEFILES YES SYSDISC YES is in effect and you have no discarded records, LOADPLUS deletes your SYSDISC data set only if the expiration date is earlier than the current date.
  • When invoking DSNUTILB, LOADPLUS includes this information in the TEMPLATE control statement that it builds for the IBM Db2 LOAD utility. For more information about TEMPLATE control statements, see the documentation for the Db2 LOAD utility.

Specifying the default

You can specify the default for the EXPDT command option in your installation options module by using the EXPDT installation option. LOADPLUS was shipped without a value for this option. The EXPDT command option overrides the RETPD command option and the EXPDT and RETPD installation options.

 

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