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.

Work file validity and integrity checks


LOADPLUS ensures that the work files it uses for load processing are valid by performing the following types of file verification:

  • Check for data set attributes

    The first check determines whether a work file has been allocated as a temporary data set or with DISP=MOD.

  • Check for data integrity

    The second check ensures that the work file that LOADPLUS reads during the LOAD phase is the same one that was created during the PRELOAD phase.

Check for data set attributes

This section describes how LOADPLUS responds when determining that your work files and copy data sets are temporary data sets. 

LOADPLUS defines a temporary data set as one whose normal or abnormal DISP is defined with one of the following values:

  • DELETE
  • NEW,PASS
  • OLD,PASS and the original status is not OLD

SORTOUT, SYSERR, and SYSUT1 data sets

If LOADPLUS determines that your SORTOUT, SYSERR, or SYSUT1 data sets are temporary, LOADPLUS responds based on the value of the FILECHK installation option:

FILECHK value

LOADPLUS response

FAIL

If your installation options specify FILECHK=FAIL and if LOADPLUS finds that any of the SORTOUT, SYSERR, or SYSUT1 data sets are temporary, LOADPLUS terminates. On output, if the disposition is MOD, LOADPLUS resets it to empty.

If LOADPLUS is restarting in the LOAD phase and the data set is temporary due to its normal disposition, LOADPLUS overrides the normal disposition to KEEP to ensure against data loss after termination.

WARN

You can force LOADPLUS to process the SORTOUT, SYSERR, and SYSUT1 files in WARN mode by specifying FILECHK=WARN in the LOADPLUS installation options. In WARN mode, LOADPLUS issues a warning message for each work file that is allocated as a temporary data set, but continues load processing.

Important

If you restart your job after receiving this warning message, unpredictable errors can occur due to invalid data in the work data set.

SYSDISC and copy data sets

If LOADPLUS finds that the SYSDISC work file or any of the copy data sets are temporary data sets, LOADPLUS continues processing and issues a warning message, regardless of the value of FILECHK.

Important

LOADPLUS issues a warning message for the copy data sets when opening them during the LOAD phase. If you run LOADPLUS in two steps by using the PRELOAD PAUSE option, you can code the DDs with DUMMY in the PRELOAD phase to avoid receiving message BMC50391E. This message states that LOADPLUS is unable to locate the copy data set.

Check for data integrity

LOADPLUS performs a second check of the SORTOUT, SYSERR, and SYSUT1 work files to ensure data integrity. 

Two-phase load

During the PRELOAD phase of two-phase load processing, LOADPLUS creates the SORTOUT, SYSERR, and SYSUT1 work files with header information about the current utility execution. During the LOAD phase, LOADPLUS checks this header information to ensure that the work file is the file it is expecting to load. If the header information does not match, LOADPLUS terminates.

Single-phase load

During the COMBINED phase of single-phase load processing, LOADPLUS writes and verifies the header information of the SYSERR file.

For certain single-phase load jobs, if SORTOUT and SYSUT1 files are available, LOADPLUS writes the header information during the COMBINED phase of the original load job. If you restart this job, LOADPLUS verifies the header information during the COMBINED phase of the restarted job. If the header information does not match, LOADPLUS terminates and issues an error message. For information about when LOADPLUS uses SORTOUT and SYSUT1 files in a single-phase load, see SORTOUT-data-sets-in-LOADPLUS and SYSUT1-data-sets-in-LOADPLUS.

Related topic

 

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