IBM Support

PH54682: DB2 ADMIN TOOL UTILITY FIXES

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Db2 Admin Tool utility fixes.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 and Object Compare                           *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR addresses various problems    *
    *                      with running utilities from Db2         *
    *                      Administration Tool.                    *
    ****************************************************************
    1. When Db2 Administration Tool generates JCL for ALT with
    'Run COPY' = A, the generated apply job fails on the COPY step.
    2. When 'Space unit' on panel ADB2UPA is set to BLK or a
    numerical value, the LOAD job fails on template processing.
    3. When performing a migrate operation with cross loader, the
    job fails during template processing.
    4. When Db2 Administration Tool generates JCL a for table space
    cross loader operation, the job fails, because the SERR and
    SDISC template data set names are missing the last qualifier.
    5. When performing redirected recovery for tables with the same
    schema, the 'Table schema mismatch' error is returned if
    the source or target table space has a view.
    6. When Db2 Administration Tool generates a WSL for LOAD with
    input created from UNLOAD, the created WSL fails
    due to a missing SYSREC DD card.
    7. When performing a lookup operation from panel ADB2USV,
    ADB21SAR, or ADB2Z2I3 for a nonexistent database or table space,
    processing error CMG999 occurs.
    8. Message part ADBRA00 is renamed to ADBR00.
    

Problem conclusion

  • .The problems have been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH54682

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2023-05-23

  • Closed date

    2023-06-05

  • Last modified date

    2023-07-03

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

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

    UI92093

Modules/Macros

  • ADB21SAR ADB28M2  ADB2U    ADB2USV  ADB2UTLX ADB2Z2I3 ADBGAJOB
    ADBR00   ADBRA00  ADBTEP2
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI92093

       UP23/06/07 P F306

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.

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"12.1.0"}]

Document Information

Modified date:
03 July 2023