IBM Support

PK78594: DB2 OBJECT COMPARE COMMENT / LABEL ON VIEW ALIAS NOT REPORTED CORRECTLY.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • DB2 OBJECT COMPARE COMMENT / LABEL ON VIEW ALIAS NOT REPORTED
    CORRECTLY.
    

Local fix

  • APPLY PTF.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool or DB2  *
    *                 Object Comparison Tool for z/OS who use the  *
    *                 Change Management function.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: When an alias is based on a view or     *
    *                      Materialized Query Table (MQT), Comment *
    *                      and Label statements on the alias are   *
    *                      not processed correctly when such       *
    *                      alters are grouped along with alters    *
    *                      on its base view or MQT.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When an alias is based on a view or Materialized Query Table
    (MQT), Comment and Label statements on the alias are not
    processed correctly when such alters are grouped along with
    alters on its base view or MQT.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK78594

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    720

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2009-01-13

  • Closed date

    2011-04-12

  • Last modified date

    2011-05-02

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

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

Modules/Macros

  • ADBCCMM
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA10 PSY UK66732

       UP11/04/15 P F104

  • R720 PSY UK66733

       UP11/04/15 P F104

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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCVQTD","label":"IBM Db2 Administration Tool for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"720","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 May 2011