IBM Support

PH37341: SUPPORT FOR MISSING DB2 UTILITY OPTIONS (PHASE 2)

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Support for missing Db2 utility options (Phase 2)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Db2 Object Comparison Tool for z/OS      *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR provides enhancements to      *
    *                      add support for utility options         *
    *                      for the following utilities:            *
    *                                                              *
    *                      (1) LOAD                                *
    *                      (2) RECOVER                             *
    *                      (3) REORG TABLESPACE                    *
    ****************************************************************
    This APAR adds support as follows:
    
    (1) LOAD utility:
    
    The PRESORT option was added to the 'Table Utilities - LOAD
    with Cross Loader' panel (ADBPUTLC) and to the 'Specify
    Utility Options - LOAD' panel (ADB2UTC).
    The UTIL_LOAD_PRESORT and UTIL_LOAD_PRESORTED Change
    Management (CM) batch parameters have been added to CM batch.
    (2) RECOVER utility:
    
    The value of the SCOPE option (on panel ADB2USV) automatically
    sets a valid value of Updated or All for the SCOPE option for
    the REBUILD INDEX utility (on panel ADB2UXB).
    Multiple partitions or 'ALL' can be specified for the DSNUM
    option. Use dashes to indicate a range and commas to separate
    each value or range. This DSNUM input field is scrollable and
    can be expanded.
    Redirected recovery support has been added for auxiliary and
    XML (LOB and XML) table spaces.
    (3) REORG TABLESPACE utility:
    
    The options ICLIMIT_DASD, ICLIMIT_TAPE are added to the
    'Specify Utility Options - REORG' panel (ADB2USO).
    The UTIL_REORG_ICLIMIT_DASD and UTIL_REORG_ICLIMIT_TAPE
    CM batch parameters have been added to CM batch.
    

Problem conclusion

Temporary fix

Comments

  • ×**** PE21/12/28 FIX IN ERROR. SEE APAR PH43052  FOR DESCRIPTION
    

APAR Information

  • APAR number

    PH37341

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-05-18

  • Closed date

    2021-10-20

  • Last modified date

    2021-12-29

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

    UI77730

Modules/Macros

  • ADB2000  ADB21S   ADB25TU  ADB25TU1 ADB28M   ADB2U    ADB2UOPS
    ADB2US   ADB2USO  ADB2USOP ADB2USV  ADB2USVO ADB2USVX ADB2UTC
    ADB2UTCO ADB2UTLX ADB2UXB  ADB2UXBO ADB2UXV  ADB2UXVO ADB34
    ADBCCM   ADBCMBIV ADBEALT  ADBGAJOB ADBHUSO  ADBHUSV  ADBHUTC
    ADBHUTLC ADBHUXV  ADBPUTLC
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI77730

       UP21/10/27 P F110

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"12.1.0"}]

Document Information

Modified date:
30 December 2021