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.

SYSERR data set in LOADPLUS

The SYSERR data set contains information about errors and is for LOADPLUS internal use only. LOADPLUS always requires a SYSERR data set.

Important

You should not depend on the format of this proprietary data set; this format is subject to change without notice.

LOADPLUS uses this data set from the time LOADPLUS starts reading the SYSREC data set until the time LOADPLUS completes loading all of the tables. To override the default ddname for the SYSERR data set, use the ERRDDN command option.

Important

You can use the DISCARDS option to limit the number of SYSERR records that LOADPLUS generates.

Methods for allocating SYSERR data sets

You can use one of the following methods to allocate your SYSERR data sets and determine the appropriate size for those data sets:

  • Have LOADPLUS dynamically allocate your SYSERR data sets by using the DDTYPE command or installation option.

    For more information about dynamic allocation, see Dynamic-data-set-allocation and Dynamic-allocation-options.

  • Specify ANALYZE PAUSE or ANALYZE ONLY to have LOADPLUS provide an estimate of the space that is needed for your SYSERR data sets.

    For more information about these options, see ANALYZE-option-for-estimating-data-set-allocation-in-LOADPLUS.

  • Calculate the space allocation based on your knowledge of the table space that you are loading and the information in this section.

Additional considerations

Note the following additional information about allocating SYSERR data sets:

  • For a DSNUTILB load, you must have LOADPLUS dynamically allocate your SYSERR data set.
  • Do not specify DD DUMMY or a DD specified with DSN=NULLFILE.
  • BMC recommends that you do not allocate a temporary data set for SYSERR. For information about the LOADPLUS treatment of temporary data sets, see Work-file-validity-and-integrity-checks.
  • For multiple load jobs running in a worklist environment, do not use SMS extended sequential data sets as SYSERR data sets. When LOADPLUS first uses a data set, it defines the data set’s DCB attributes. With an SMS extended sequential data set, once these attributes are defined they cannot be changed. If this data set is reused, as with multiple load jobs in a worklist environment, it can require different DCB attribute values, such as a different block size or record length. LOADPLUS attempts to redefine these attributes if necessary. However, because MVS does not allow changes to these attributes after the file has been opened, LOADPLUS fails.

Related topics

LOADPLUS-DD-statements

Building-the-LOADPLUS-job

 

 

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