IBM Support

PH40337: PANEL ADB21TSE RESET COMMAND DOES NOT RESET WHERE CLAUSE FROM SEL LINE COMMAND PERFORMED EARLIER

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When you enter line command SEL on an object on PANEL ADB21T
    ('Tables, Views, and Aliases'), update the WHERE clause on
    panel ADB21TSE ('Build SQL SELECT Prototype'), and then
    PF3 back to enter SEL again on panel ADB21T,
    if you then enter RESET on panel ADB21TSE, the WHERE
    clause from the SELECT on the first object may reappear.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of Db2 Administration Tool for z/OS    *
    ****************************************************************
    * PROBLEM DESCRIPTION: The RESET command on panel              *
    *                      ADB21TSE might not reset                *
    *                      the WHERE clause.                       *
    ****************************************************************
    When line command SEL is used on panel ADB21T 'Tables, Views,
    and Aliases', the RESET command on panel ADB21TSE
    'Build SQL SELECT Prototype' does not reset the
    WHERE clause from a SEL line command that was performed earlier.
    

Problem conclusion

  • The problem has been resolved.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH40337

  • Reported component name

    DB2 ADMIN TOOL

  • Reported component ID

    568851500

  • Reported release

    C10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2021-09-02

  • Closed date

    2021-11-01

  • Last modified date

    2021-12-01

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

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

    UI77887

Modules/Macros

  • ADB21TSE ADB21TSR
    

Fix information

  • Fixed component name

    DB2 ADMIN TOOL

  • Fixed component ID

    568851500

Applicable component levels

  • RC10 PSY UI77887

       UP21/11/03 P F111

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

Document Information

Modified date:
02 December 2021