home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT01166 Status: Closed

MEMORY ALLOCATED BY A MONITOR FUNCTION MIGHT NOT BE FREED UP AND MIGHT LEAK
AFTER DATABASE IS DEACTIVATED

product:
DB2 FOR LUW / DB2FORLUW / A10 - DB2
Problem description:
Memory allocated by a monitor function might not be freed up 
properly and might leak after database is deactivated. 
 
It can be checked by the following command for monh pool (PoolID 
11). 
Memory allocated by File:2241390729 and LOC:905 is not freed for 
a long time. (LOC 905 might be changed depending on the Fix 
Pack.) 
 
> db2pd -memblocks 11 sort 
 
Memory blocks sorted by size for monh pool: 
PoolID PoolName TotalSize(Bytes)     TotalCount LOC   File 
11     monh     2153446              3801       905   2241390729 
11     monh     239520               15         1889  3055296282 
11     monh     139312               2          983   3400785722 
11     monh     72000                2          266   3400632727 
11     monh     6880                 2          3898  3400632764 
11     monh     960                  2          350   882766201 
11     monh     456                  1          220   3402477436
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 Version 10.1 FixPack 5 or higher              * 
****************************************************************
Local Fix:
Run "db2 flush package cache dynamic" before deactivating the 
database. 
It may not completely remove the memory leak, but it should 
reduce memory that is leaking.
Solution
Problem was first fixed in DB2 UDB Version 10.1 FixPack 5
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
22.04.2014
29.07.2015
29.07.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 FixList