IBM Support

PM18569: INTERNAL MODIFICATIONS TO SUPPORT ADDITION OF STMT_ID DATA FOR STATIC AND DYNAMIC SQL STATEMENTS

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as new function.

Error description

  • Internal modifications to support addition of STMT_ID data for
    Static and Dynamic SQL Statements
    
    In addition, this change alters the processing to avoid a
    Possible CQM1055E REASON=20000000
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Query Monitor.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: Internal modifications to support       *
    *                      addition of STMT_ID data for Static     *
    *                      and Dynamic SQL Statements. In          *
    *                      addition, this change alters the        *
    *                      processing to avoid a Possible CQM1055E *
    *                      REASON=20000000.                        *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

Temporary fix

Comments

  • Apply the PTF.
    

APAR Information

  • APAR number

    PM18569

  • Reported component name

    DB2 QUERY MONIT

  • Reported component ID

    5655E6701

  • Reported release

    230

  • Status

    CLOSED UR1

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2010-07-15

  • Closed date

    2010-08-27

  • Last modified date

    2010-09-02

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

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

    UK60080

Modules/Macros

  •    CQMMALOX CQMMAUDX CQMMEXXX CQMMHSTX CQMMHSX9
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R230 PSY UK60080

       UP10/09/01 P F008

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

Document Information

Modified date:
09 August 2024