IBM Support

PM97254: INVALID DELETION OF IGNORE CHANGES ROWS IN ADBPCICL.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • While displaying content of ICSpec on panel ADBPCICL, the user
    has the option to delete one or more of the ignored changes.
    If there are multiple ignored changes for the same object type
    and user marks one of the changes to be deleted then the tool
    deletes all changes for that object type.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of the DB2 Administration Tool for     *
    *                 z/OS who are deleting an ignore changes      *
    *                 row on panel ADBPCICL 'Ignored Changes       *
    *                 List' using the 'D - Delete' line command.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: The SQL being created to delete the     *
    *                      row does not include all the unique     *
    *                      columns in the WHERE clause to ensure   *
    *                      only one row is deleted.                *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The Delete line command is deleting more than the specified row.
    

Problem conclusion

  • Problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM97254

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    A20

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-09-17

  • Closed date

    2013-11-13

  • Last modified date

    2013-12-02

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

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

    UI12469

Modules/Macros

  •    ADBPCICL
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RA20 PSY UI12469

       UP13/11/15 P F311

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":"10.2.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
02 December 2013