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.

SYSPUNCH data sets in REORG PLUS

The SYSPUNCH data set contains LOAD control statements for the rows that are discarded and written to the discard file during a DSNUTILB reorganization.

When invoking DSNUTILB, REORG PLUS includes the dynamic allocation information for the optional SYSPUNCH data set in the TEMPLATE control statement that it builds for the IBM Db2 REORG utility.

Db2 REORG requires this data set when certain conditions exist. If you do not enable dynamic allocation for this data set and Db2 REORG determines that it needs the data set, the reorganization terminates. For more information about this data set, see the documentation for the Db2 REORG utility.


AllocationTo allocate this data set, you must enable dynamic allocation for the SYSPUNCH DDTYPE. If you include a SYSPUNCH DD statement in your JCL, REORG PLUS ignores it.

For non-DSNUTILB reorganizations, REORG PLUS does not allocate this data set.


ConsiderationsThe following considerations apply to the SYSPUNCH data set for DSNUTILB reorganization jobs:

  • When invoking DSNUTILB to reorganize a LOB table space, REORG PLUS does not allocate this data set.
  • You can decide when to delete this data set by specifying an expiration date with the EXPDT option, or by specifying a retention period with the RETPD option.

Related topic

REORG-PLUS-DD-statements

 

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