IBM Support

PH42750: EXCLUDE OF STORED PROCEDURE IN OBJECT COMPARE NOT HONORED IF SCHEMA OF SP ADDED TO SOURCE

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When a schema of a stored procedure is specified in source along
    with other databases, the stored procedures of that schema are
    not excluded, even when they are specified in an exclude
    specification. Other objects in the exclude specification are
    correctly excluded.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    *                 who exclude stored procedures in a compare   *
    ****************************************************************
    * PROBLEM DESCRIPTION: When comparing objects, compare does    *
    *                      not exclude stored procedures as        *
    *                      requested.                              *
    ****************************************************************
    When stored procedures are specified in the source or target
    exclude specification during a comparison, the exclude for
    stored procedures is not honored; stored procedures are
    incorrectly included in the compare.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH42750

  • 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-12-13

  • Closed date

    2022-04-15

  • Last modified date

    2022-05-03

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

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

    UI80172

Modules/Macros

  • ADBCMPDB
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI80172

       UP22/04/19 P F204

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:
04 May 2022