Space announcement This space provides the same content as before, but the organization of the home page has changed. The content is now organized based on logical branches instead of legacy book titles. We hope that the new structure will help you quickly find the content that you need.

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.

Related topic

REORG-PLUS-DD-statements

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.

 

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