IBM Support

PK58852: THE USER IS NOT BEING PROMPTED TO CANCEL THE QUERY WHEN ONE OF THE THRESHOLDS HAVE BEEN EXCEEDED.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After setting up the SQLPA/QMF interface, when thresholds have
    been exceeded the user gets ANL5026W. The user should then be
    given the opportunity to cancel the query but that is not
    occurring. The SQL/PA QMF governor exit routine is not prompting
    the QMF user asking if they would like to cancel the query when
    SQL/PA detects one of the thresholds have been exceeded.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of SQL Performance Analyzer.           *
    ****************************************************************
    * PROBLEM DESCRIPTION: After setting up the SQLPA/QMF          *
    *                      interface, when thresholds have been    *
    *                      exceeded the user gets ANL5026W. The    *
    *                      user should then be given the           *
    *                      opportunity to cancel the query but     *
    *                      that is not occurring. The SQL/PA QMF   *
    *                      governor exit routine is not prompting  *
    *                      the QMF user asking if they would like  *
    *                      to cancel the query when SQL/PA detects *
    *                      one of the thresholds have been         *
    *                      exceeded.                               *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK58852

  • Reported component name

    DB2 SQL PERF AN

  • Reported component ID

    5697F5701

  • Reported release

    310

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2008-01-04

  • Closed date

    2008-01-30

  • Last modified date

    2008-03-04

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

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

    UK33360 UK33361

Modules/Macros

  • ANLGOV1  ANLJQMF  ANLSKELT
    

Fix information

  • Fixed component name

    DB2 SQL PERF AN

  • Fixed component ID

    5697F5701

Applicable component levels

  • R310 PSY UK33360

       UP08/02/04 P F802

  • R320 PSY UK33361

       UP08/02/04 P F802

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":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SG19M","label":"APARs - z\/OS environment"},"Platform":[{"code":"PF054","label":"z\/OS"}],"Version":"310"}]

Document Information

Modified date:
04 January 2021