IBM Support

PI92762: LOADING OUTDATED INTERVALS CAN CAUSE MEMORY LEAKS IN THE CAE AGENT

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • This APAR resolves a memory leak in the CAE Agent which can
    occur in the following scenario:
    Choose the oldest interval when this interval has been deleted
    and attempt to load data for the non-existing interval. The CAE
    Agent doesn't release memory properly after processing this
    request, causing a memory leak. Multiple similar requests can
    eventually result in a "Storage Exhausted" condition.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of IBM Db2 Query Monitor z/OS.         *
    ****************************************************************
    * PROBLEM DESCRIPTION: This APAR resolves a memory leak in     *
    *                      the CAE Agent which can occur in the    *
    *                      following scenario:                     *
    *                      Choose the oldest interval when this    *
    *                      interval has been deleted and attempt   *
    *                      to load data for the non-existing       *
    *                      interval. The CAE Agent doesn't         *
    *                      release memory properly after           *
    *                      processing this request, causing a      *
    *                      memory leak. Multiple similar requests  *
    *                      can eventually result in a "Storage     *
    *                      Exhausted" condition.                   *
    ****************************************************************
    * RECOMMENDATION: APPLY the PTF.                               *
    ****************************************************************
    Code has been changed to correct this condition.
    

Problem conclusion

  • APPLY the PTF.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI92762

  • Reported component name

    DB2 QUERY MONIT

  • Reported component ID

    5655E6701

  • Reported release

    330

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-01-22

  • Closed date

    2018-04-18

  • Last modified date

    2018-05-01

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

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

    UI55298

Modules/Macros

  • CQM#QAPI CQM#QAPX CQM#QSQL CQMBLOB  CQMCAE
    CQMCAEPT CQMCAPI  CQMJAR
    

Fix information

  • Fixed component name

    DB2 QUERY MONIT

  • Fixed component ID

    5655E6701

Applicable component levels

  • R330 PSY UI55298

       UP18/04/24 P F804

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

Document Information

Modified date:
05 November 2021