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 REORG PLUS for DB2 13.1.

Work file validity and integrity checks


REORG PLUS ensures that the work files it uses for reload 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 REORG PLUS reads during reload processing is the same one that was created during unload processing. 

Check for data set attributes

This section describes how REORG PLUS responds when determining that your work files are temporary data sets.

REORG PLUS 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

SYSREC, SYSUT1, and SYSARC data sets

If REORG PLUS determines that your SYSREC, SYSUT1, or SYSARC data sets are temporary, REORG PLUS responds based on the value for the FILECHK option.

Value

Description

FILECHK=FAIL

If FILECHK=FAIL and REORG PLUS finds that any of the SYSREC, SYSUT1, or SYSARC data sets are temporary, REORG PLUS terminates. On output, if the disposition is MOD, REORG PLUS resets it to empty.

If REORG PLUS is restarting in the RELOAD or REORG phase and the data set is temporary due to its normal disposition, then REORG PLUS overrides the normal disposition to KEEP to ensure against data loss after termination.

FILECHK=WARN

You can force REORG PLUS to process the SYSREC, SYSUT1, or SYSARC files in WARN mode by specifying FILECHK=WARN. In WARN mode, REORG PLUS issues a warning message for each work file that is allocated as a temporary data set, but continues processing.

Important

If you are running REORG PLUS in WARN mode, specifying DD DUMMY or DSN=NULLFILE for SYSREC or SYSUT1 data sets causes a failure in the RELOAD phase.

Copy data sets

Warning

Use care when you specify DISP=MOD for an image copy data set because REORG PLUS does not reset the data set to empty but appends data to any data that is already present in the file.

If REORG PLUS finds that any of the full copy data sets are temporary data sets, REORG PLUS continues processing and issues a warning message, regardless of the value of FILECHK.

Important

For a two-phase reorganization, the warning message for the copy files occurs at open time, during the RELOAD phase. For a single-phase reorganization, the message occurs during the REORG phase. If you run REORG PLUS in two steps using the UNLOAD PAUSE option, you can code the DDs with DUMMY in the UNLOAD phase to avoid receiving message BMC50391E. This message indicates that REORG PLUS is unable to locate the copy data set.

For SHRLEVEL CHANGE, REORG PLUS terminates and issues an error message if it finds that any of the full or incremental copy files are temporary data sets, regardless of the value of FILECHK.

Check for data integrity

REORG PLUS performs a second check of the SYSREC and SYSUT1 work files to ensure data integrity.

During unload processing, REORG PLUS creates the SYSREC and SYSUT1 work files with header information about the current utility execution. During reload processing, REORG PLUS checks this header information to ensure that the work file is the file that it is expecting to reload. If the header information does not match, REORG PLUS terminates and issues an error message.

 

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