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