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 IC77138 Status: Closed

TABLE FUNCTION ADMIN_GET_TAB_INFO CAUSES A MEMORY LEAK IN APPLICATION HEAP
WITH DB2 V9.1

product:
DB2 FOR LUW / DB2FORLUW / 910 - DB2
Problem description:
Calling SYSPROC.ADMIN_GET_TAB_INFO() in DB2 V9.1, will leak 
memory in the application heap. This can be monitored with 
"db2mtrk -a" or "db2pd -db <dbname> -memb all". 
 
The ouput of db2pd shows the following picture: 
 
Memory blocks sorted by size for apph pool: 
PoolID  PoolName  TotalSize(Bytes)  TotalCount LOC   File 
1       apph      392000            1000       730   882766201 
1       apph      360000            1000       2696  882766201 
1       apph      280000            1000       690   882766201 
1       apph      80000             1000       611   882766201 
1       apph      80000             1000       594   882766201 
1       apph      56000             1000       645   882766201 
1       apph      56000             1000       628   882766201 
1       apph      56000             1000       719   882766201
Problem Summary:
Local Fix:
Disconnecting the application will free the application 
heap memory.
available fix packs:
DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows

Solution
Workaround
not known / see Local fix
Comment
NA
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
23.06.2011
08.03.2012
08.03.2012
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.11 FixList