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.

Enabling REORG PLUS to invoke DSNUTILB

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

Related topic

Reorganization-jobs-that-invoke-DSNUTILB

To enable REORG PLUS to invoke DSNUTILB

  1. Ensure that you are licensed to use the IBM Db2 REORG utility.

  2. 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

  3. 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 12 or later only) Specify an existing mapping database with the MAPPINGDATABASE command option.
  4. 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.
  5. Use the information in the rest of this section to ensure that you create an 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.

 

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