IBM Support

IT28248: CLEANING UP OF EDU CAUSES PRIVATE MEMORY TO LEAK (WINDOWS PLATFORM ONLY)

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • This issue is specific to Db2 running under Windows operating
    system only and with version 11.1 mod 4 fix pack 4. When a EDU
    is released from serving an application it will leak a private
    memory block. Depending on the configuration and number of
    connections coming in/out the leak might grow rather quickly.
    
    The type of blocks leaked will be visible in a "db2fodc -memory"
    output file "db2pd.memblocks.private". In this file, the persist
    pool of the private memory will be the main consumer with a
    large count of blocks:
    
    ...
    Total size for persist pool: 7673057192 bytes (PoolID: 86,
    SecondID: 0, PoolAddr: 0x000001504C280498)
    Total size for Private memory set: 7673668136 bytes
    
    All memory consumers in Private memory set:
    PoolAddr          PoolID    PoolName  SecondID
    TotalSize(Bytes)    %Bytes TotalCount %Count  LOC  File
    0x000001504C280498 86        persist   0
    7663597408          99.87 216388      99.43  476  4284367586
    0x000001504C280498 86        persist   0
    6549088             0.09  52           0.02  196  1235720678
    0x000001504C280498 86        persist   0
    1159264             0.02  490          0.23  244  4283993058
    0x000001504C280498 86        persist   0
    786432              0.01  6            0.00 5176  745254192
    ...
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Db2 running on Windows environment only                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * upgrade to Db2 version 11.1 mod 4 fp5                        *
    ****************************************************************
    

Problem conclusion

  • first fixed in Db2 version 11.1 mod 4 fp5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT28248

  • Reported component name

    DB2 FOR LUW

  • Reported component ID

    DB2FORLUW

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2019-02-28

  • Closed date

    2019-10-31

  • Last modified date

    2019-10-31

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

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

    IT30794 IT31299

Fix information

  • Fixed component name

    DB2 FOR LUW

  • Fixed component ID

    DB2FORLUW

Applicable component levels

  • RB10 PSY

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

Document Information

Modified date:
31 October 2019