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

DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

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 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