IBM Support

PH62856: INCORRECT DDL GENERATED WHEN ALTERING TRUSTED CONTEXT ON PANEL ADB26CN

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Customer did AL command to alter an option (ENABLE) on a
    specific trusted context in panel ADB26CN. They were expecting
    an ALTER statement with just the one option chnaged but they got
    an ALTER statement that had all the options listed. The ALTER
    works correctly and changes the one option but customer was
    expecting only the one option in the ALTER statement as with the
    other Db2 objects (table spaces, tables, etc.)
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    ****************************************************************
    * PROBLEM DESCRIPTION: Incorrect DDL was generated when using  *
    *                      the AL line command on a trusted        *
    *                      context on panel ADB26CN.  One option   *
    *                      was altered, and the DDL includes all   *
    *                      options in the ALTER TRUSTED CONTEXT    *
    *                      statement.                              *
    ****************************************************************
    When using the AL line command on panel ADB26CN to change an
    option for a trusted context, all the options are included in
    the ALTER TRUSTED CONTEXT statement even though only one option
    was changed. Only the changed option should be shown on the
    ALTER statement.
    

Problem conclusion

  • The problems have been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH62856

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    D10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2024-08-20

  • Closed date

    2024-11-01

  • Last modified date

    2024-11-05

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

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

    UI98935

Modules/Macros

  • ADB26CN  ADB2AN   ADBH6CN
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RD10 PSY UI98935

       UP24/11/05 I 1000

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":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSZJXP","label":"DB2 Tools for z\/OS"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"D10","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
05 November 2024