IBM Support

LI75538: MEMORY LEAKS IN POLICY CODE OF DB2ACD FOR AUTOBACKUP EVALUATIONS

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • db2pd -memblock  output for db2acd shows small memory leaks for
    db2acd.
    
    Autobackup evaluations happens every two hour interval.  And
    after each evaluations, db2pd detects a leak of 3 allocations
    from LOC 56, and 1 allocation from LOC 410 for file 521867987.
    
    
    
    A single evaluation leaks:
    3 allocations from LOC 56 ; and 1 allocation from LOC 410.
    
    After one evaluation (2hours):
    Memory blocks sorted by size:
    PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
    88         private    112                  3          56
    521867987
    88         private    11                   1          410
    521867987
    
    After two evaluations (4hours):
    Memory blocks sorted by size:
    PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File
    88         private    224                  6          56
    521867987
    88         private    22                   2          410
    521867987
    
    
    The problem happens only for autobackup evaluations. It does not
    happen for the other plugins like autoreorg or autorunstats even
    though  it uses the same parser code.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * ALL users below v9.5 FP7                                     *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * db2pd -memblock  output for db2acd shows small memory        *
    * leaksfordb2acd.Autobackup evaluations happens every two hour *
    * interval.  Andafter each evaluations, db2pd detects a leak   *
    * of 3allocationsfrom LOC 56, and 1 allocation from LOC 410    *
    * for file521867987.A single evaluation leaks:3 allocations    *
    * from LOC 56 ; and 1 allocation from LOC 410.After one        *
    * evaluation (2hours):Memory blocks sorted by size:PoolID      *
    * PoolName  TotalSize(Bytes)    TotalCount LOC  File88         *
    * private    112                  3          5652186798788     *
    *    private    11                  1                          *
    * 410521867987After two evaluations (4hours):Memory blocks     *
    * sorted by size:PoolID    PoolName  TotalSize(Bytes)          *
    * TotalCount LOC  File88        private    224                 *
    *  6          5652186798788        private    22               *
    *    2          410521867987The problem happens only for       *
    * autobackup evaluations. It doesnothappen for the other       *
    * plugins like autoreorg or autorunstatseventhough  it uses    *
    * the same parser code.                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Upgrade to V9.5 FP7 or later.                                *
    ****************************************************************
    

Problem conclusion

  • First fixed in v9.5 FP7
    

Temporary fix

Comments

APAR Information

  • APAR number

    LI75538

  • Reported component name

    DB2 UDB WSE LIN

  • Reported component ID

    5765F3504

  • Reported release

    950

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2010-06-25

  • Closed date

    2011-01-17

  • Last modified date

    2011-01-17

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

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

    IC71484 IC71485

Fix information

  • Fixed component name

    DB2 UDB WSE LIN

  • Fixed component ID

    5765F3504

Applicable component levels

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

Document Information

Modified date:
17 January 2011