IBM Support

PK05506: ADMIN TOOL ALTER INDEX ALL PARTS WITH PROMPT ON USING OPTION 1A PERFORMS CHANGES BUT ALSO SCROLLS THROUGH INDIVIDUAL ALTERS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When an alter of the priqty of a partitioning index is done, for
    all part, with prompt on, and option 1A is cheosen, all cahnges
    are done, however admin still loops through each alter to be
    done unnecessarily.
    

Local fix

  • use PF3 end key to terminate prompts
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Administration Tool R510, who   *
    *                 use the ALL PARTs Area in Panel ADB21XA      *
    *                 for partition index changes, are affected.   *
    ****************************************************************
    * PROBLEM DESCRIPTION: With Prompt On, a value specified in    *
    *                      the All Parts area will be forced to    *
    *                      make the change one at a time, for      *
    *                      each index in the Partition.            *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    See Problem Description.
    

Problem conclusion

  • A customer, who enters some value in the ALL PARTS Area, with
    PROMPT ON were directed to ADB2PSTM (Statement Execution Prompt)
    panel for each partition index to be updated.
    .*
    Code has been fixed to "mass" update all Partitions, when the
    ALL PARTS Area is used and Prompt is ON.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK05506

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    510

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2005-05-09

  • Closed date

    2005-06-24

  • Last modified date

    2005-07-01

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

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

Modules/Macros

  •    ADB21XA
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R510 PSY UK04850

       UP05/06/30 P F506

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

Document Information

Modified date:
01 July 2005