IBM Support

PK70137: EXPECTED DATA MISSING FROM CURRENT ACTIVITY, WHEN MONITORING LIGHTLY LOADED DB2 SUBSYSTEM

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • Incorrect consolidation of in-flight data with an active
    workload resulting in the workload disapearing from current
    activity.
    

Local fix

  • Specifying INFLIGHT(N) in CQMPARMS can be used for turning off
    INFLIGHT collection.
    
    INFLIGHT(N) is an undocumented parameter.  INFLIGHT(N) prevents
    both the exception and alert processes from detecting thresholds
    until the unit of work has completed.
    
    It is recommended only for use as a workaround and should be
    removed when the maintenance resolving this issue has been
    applied.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Query Monitor.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: Incorrect consolidation of in-flight    *
    *                      data with an active workload resulting  *
    *                      in the workload disapearing from        *
    *                      current activity.                       *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK70137

  • Reported component name

    DB2 QUERY MONIT

  • Reported component ID

    5655E6701

  • Reported release

    230

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2008-08-05

  • Closed date

    2008-09-05

  • Last modified date

    2008-10-03

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

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

    UK39571

Modules/Macros

  •    CQMMACTX CQMMSSQX
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R230 PSY UK39571

       UP08/09/13 P F809

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

Document Information

Modified date:
30 March 2021