IBM Support

PH39224: ADBTEP2 MAY TREAT RELATED DB2 UTILITY STATEMENTS AS INDEPENDENT AND IGNORE OPTIONS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ADBTEP2 has a function to run Db2 utilities directly based on
    the input it is given.  However, the way input is formatted may
    cause ADBTEP2 to run related Db2 utility statements as though
    they were completely independent.  As a result, various options
    may be potentially ignored when the utility is executed.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All Db2 Administration Tool for z/OS users   *
    ****************************************************************
    * PROBLEM DESCRIPTION: Modifying Admin Tool-generated ADBTEP2  *
    *                      jobs with Db2 utilities statements to   *
    *                      add DIAGNOSE statements can result      *
    *                      in the DIAGNOSE statements not being    *
    *                      properly scoped and thereby made        *
    *                      ineffective.  The reported problem      *
    *                      involved the use of DIAGNOSE TYPE(xxx)  *
    *                      statements with the statement-          *
    *                      terminating semicolon on the following  *
    *                      input line.                             *
    ****************************************************************
    APAR PH34007 enhanced the processing of Db2 DIAGNOSE utility
    control statements so that ADBTEP2 recognizes statements, such
    as DIAGNOSE TYPE(xxx), that are intended to apply to another
    utility.  This APAR further extends that code to recognize
    additional variations in the format of DIAGNOSE statements.
    

Problem conclusion

  • The reported problem has been fixed.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH39224

  • 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

    2021-07-23

  • Closed date

    2021-11-19

  • Last modified date

    2021-12-01

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

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

    UI78185

Modules/Macros

  • ADBTEP2
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI78185

       UP21/11/23 P F111

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:
02 December 2021