IBM Support

PK39976: STATISTICAL SUMMARIZATION FOR DATA SHARING GROUP VIEWS IS INCOMPLETE IN SUMMARIES PERSPECTIVES.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • When viewing "summary by sql text" (the table shown by selecting
    an "instance folder") in either the Activity Summaries
    (Operational) or Activity Summaries (Structural), the statistics
    are not summarized. When viewing details panels for other
    summaries (by selecting a row in the table shown by selecting a
    "group folder), some of the statistics are not summarized across
    the data sharing group.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of DB2 Query Monitor.                  *
    ****************************************************************
    * PROBLEM DESCRIPTION: When viewing "summary by sql text"      *
    *                      (the table shown by selecting an        *
    *                      "instance folder") in either the        *
    *                      Activity Summaries (Operational) or     *
    *                      Activity Summaries (Structural), the    *
    *                      statistics are not summarized. When     *
    *                      viewing details panels for other        *
    *                      summaries (by selecting a row in the    *
    *                      table shown by selecting a              *
    *                      "group folder"), some of the statistics *
    *                      are not summarized across the data      *
    *                      sharing group.                          *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK39976

  • Reported component name

    DB2 QUERY MONIT

  • Reported component ID

    5655E6701

  • Reported release

    220

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2007-02-23

  • Closed date

    2007-04-09

  • Last modified date

    2007-05-02

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

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

Modules/Macros

  •    CQMJAR
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R220 PSY UK23839

       UP07/04/17 P F704

  • R221 PSY UK23840

       UP07/04/17 P F704

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

Document Information

Modified date:
10 August 2024