IBM Support

IT00372: MEMORY LEAK IN PRIVATE POOL WHEN USING COMPLEX DATA TYPES

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • A memory leak may in private pool may occur if the application
    is using complex data types (CREATE TYPE ...), like ARRAY.
    
    The memory leak is in the DRDA layer of the DB2 engine and can
    be observed with db2pd -memblocks, it will show up as an
    allocation in pair's.
    For Example:
    
    ...
    Memory blocks sorted by size:
    PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
    0                     91540064             14938      1127
    2904145706
    0                     69509904             11343      1620
    3103375146
    
    Please note that in the avobe example the LOC and File are
    specific to a DB2 release and may look different in other
    releases. Please check with DB2 Support if you suspect this
    memory leak.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL                                                          *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to DB2 Version 9.7 Fix Pack 10.                      *
    ****************************************************************
    

Problem conclusion

  • First fixed in DB2 Version 9.7 Fix Pack 10.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT00372

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    970

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-03-18

  • Closed date

    2014-11-17

  • Last modified date

    2014-11-17

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

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

    IT00534 IT00535 IT00536 IT00562 IT00588 IT00589

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • R970 PSN

       UP

[{"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSEPGG","label":"DB2 for Linux, UNIX and Windows"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"9.7","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
17 November 2014