IBM Support

PI82533: CANNOT FIND MATCHING COLUMN NAME: RECEIVE ADBC002E ERROR.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • ADBC002E SEVER ERROR IN MERGE, NO OBJECT ROW FOUND TO MATCH
    DELTA ROW - rowtype=KY.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool for         *
    *                 z/OS who analyze a change and the            *
    *                 ADMIN ALTER INDEX statement has a            *
    *                 quoted column name in the change.            *
    ****************************************************************
    * PROBLEM DESCRIPTION: Analyzing a change ends with a          *
    *                      ADBC002E / msgadbc002e error when       *
    *                      the change contains an ADMIN ALTER      *
    *                      INDEX statement with a quoted           *
    *                      column name.                            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    When a change contains an ADMIN ALTER INDEX statement with a
    quoted column name, upon performing an ALTER INDEX with column
    attribute operation, Merge fails to find matching column
    name due to the quotes around the column name and fails
    with the following error:
    
    ADBC002E severe error in merge, No object row found to
    match delta row- rowtype=KY.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI82533

  • Reported component name

    DB2 OBJECT COMP

  • Reported component ID

    5697G6400

  • Reported release

    B20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-06-02

  • Closed date

    2017-06-13

  • Last modified date

    2017-07-05

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

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

    UI48017

Modules/Macros

  •    ADBCDTS  ADB2CME
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RB20 PSY UI48017

       UP17/06/15 P F706

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":"11.2.0"}]

Document Information

Modified date:
18 March 2021