IBM Support

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

Subscribe

You can track all active APARs for this component.

 

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

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU053","label":"Cloud \u0026 Data Platform"},"Product":{"code":"SSEPGG","label":"DB2 for Linux- UNIX and Windows"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1"}]

Document Information

Modified date:
03 September 2021