IBM Support

PK31492: IMPROVED DOCUMENTATION FOR WHEN/WHY ALC DISPLAYS PANEL ADB27CR WHEN A UP IS ISSUED AGAINST A COLUMN IN PRIMARY KEY

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • The DB2 Administration Tool ALC command will display panel
    ADB27CR when an UP line command is issued against a column
    in the primary key. This APAR will be used to change the
    documentation, help panel and message to better explain why.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users  of  DB2 Administration Tool,  who use *
    *                 ALC to make changes to a column that is part *
    *                 of the table's primary key, may be affected. *
    ****************************************************************
    * PROBLEM DESCRIPTION: ALC command  displayed  panel  ADB27CR  *
    *                      when  an  UP  line command was  issued  *
    *                      against a column in the primary key.    *
    *                      .*                                      *
    *                      Panel  ADB27CR   displayed  a  message  *
    *                      "Primary index required", but, primary  *
    *                      index was OK.                           *
    *                      .*                                      *
    *                      Help text was insufficient to give the  *
    *                      Users a clear sense of what courses of  *
    *                      action were available to them.          *
    *                      .* Note:                                *
    *                      Help text has been expanded to be more  *
    *                      descriptive  of  the  User's  possible  *
    *                      courses of action.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    See Problem Description.
    

Problem conclusion

  • Apply the fix.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK31492

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    710

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2006-09-15

  • Closed date

    2006-10-26

  • Last modified date

    2006-12-01

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

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

Modules/Macros

  •    ADBH7CR  ADB27CR
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • R710 PSY UK19150

       UP06/11/02 P F611

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

Document Information

Modified date:
01 December 2006