Enabling REORG PLUS to invoke DSNUTILB

This task describes how to enable REORG PLUS to invoke DSNUTILB when required.

To enable REORG PLUS to invoke DSNUTILB

Ensure that the following installation or command options are set:

Option	Required setting
DSNUTILB	YES
ACTIVE	YES for the following DDTYPES: All work file DDTYPEs that the reorganization job requires (if you specify COPY YES) The LOCPFCPY DDTYPE and other copy DDTYPEs if needed
SORTNUM	2 or greater

For a SHRLEVEL CHANGE table space reorganization, ensure that a mapping table or database is specified and available by completing one of the following actions:
- Specify an existing mapping table with the MAPPINGTABLE command option.
- Provide a user exit that will create and drop the mapping objects for you; then, supply the user exit name in the MAPTEXIT installation or command option.
  For more information about the MAPTEXIT user exit, see Using-MAPTEXIT-to-create-mapping-objects
- (Db2 Version 11 or later only) Specify an existing mapping database with the MAPPINGDATABASE command option.
If you anticipate that the IBM Db2 REORG utility will need data sets for discarded rows and for LOAD control cards for those discarded rows, ensure that dynamic allocation is enabled for the ARCHIVE and SYSPUNCH DDTYPEs.If the Db2 REORG utility needs these data sets and they are not dynamically allocated in your REORG PLUS job, the job terminates.
Use the information in the rest of this section to ensure that you create appropriate JCL for your job.For existing jobs, you might need to make changes to your JCL. For example, certain options will cause your job to fail when invoking DSNUTILB.