|
Problem IT05804
|
Status: Closed |
MEMORY LEAK IN APPLICATION HEAP WHEN RUNSTATS COMMAND WITH USE PROFILE OPTION IS EXECUTED |
| product: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problem description: |
Application Heap consuming memory and causing out of memory
errors.
This issue is triggered when RUNSTATS command with USE PROFILE
option is executed in the loop.
Leaking memory can be identified using following command:
db2pd -db <database> -mempools
On the subsequent iterations of this command row with a PoolName
of apph should be looked for.
Memory blocks sorted by size for apph pool:
PoolID PoolName TotalSize(Bytes) TotalCount LOC File
1 apph 3249 9 34172
793532624
...
Memory blocks sorted by size for apph pool:
PoolID PoolName TotalSize(Bytes) TotalCount LOC File
1 apph 74727 207 34172
793532624
...
Memory blocks sorted by size for apph pool:
PoolID PoolName TotalSize(Bytes) TotalCount LOC File
1 apph 85918 238 34172
793532624
... |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All users *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Uprgrade to DB2 10.1 fix pack 5 *
**************************************************************** |
| Local Fix: |
|
| Solution |
This APAR will fix memory leak issue. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.11.2014
10.08.2015
10.08.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.5
|
 |
