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