IBM Support

PH65763: FILTER OPTIONS ON SQL CODE ARE NOT SHOWN IN CORRECT ORDER IN THE ACCELERATOR QUERIES VIEW.

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • In the Accelerator Queries view, you can filter the queries
    according to the SQL codes displayed in the 'SQL Code' column.
    However, the list of SQL codes available for filtering is shown
    in incorrect order, for example, in ascending order 245 is shown
    before 25.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM DB2 Admin Foundation for z/OS   *
    ****************************************************************
    * PROBLEM DESCRIPTION: In the Accelerator Queries view,        *
    *                       you can filter the queries according   *
    *                       to the SQL codes displayed in the      *
    *                      'SQL Code' column. However, the         *
    *                       list of SQL codes available for        *
    *                       filtering is shown in incorrect        *
    *                      order, for example, in ascending        *
    *                       order 245 is shown before 25.          *
    ****************************************************************
    Filter options on SQL Code are not shown in correct
     order in the Accelerator Queries view.
    

Problem conclusion

  • Apply the PTF provided by this APAR
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH65763

  • Reported component name

    DB2 ADMIN FND Z

  • Reported component ID

    5698ADF00

  • Reported release

    120

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2025-03-20

  • Closed date

    2025-06-25

  • Last modified date

    2025-06-27

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

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

Modules/Macros

  • AFXDDLPX AFXOPPAX AFXVRPAX
    

Fix information

  • Fixed component name

    DB2 ADMIN FND Z

  • Fixed component ID

    5698ADF00

Applicable component levels

  • R120 PSY UP

       A

[{"Business Unit":{"code":"BU011","label":"Systems - zSystems software"},"Product":{"code":"SG19M"},"Platform":[{"code":"PF054","label":"z Systems"}],"Version":"120"}]

Document Information

Modified date:
28 June 2025