|
Problem IC78422
|
Status: Closed |
MEMORY LEAK IN APPLICATION HEAP WHEN DROPPING AN SQL PROCEDURE OR COMPILED SQL FUNCTION |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Whenever you drop an SQL stored procedure or compiled SQL
function, some memory in the application heap is not freed.
The amount of memory leaked varies directly with the number of
parameters in the routine being dropped. You may use the
command
db2mtrk -i -d -a
to monitor the size of the application heap (apph). |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* MEMORY LEAK IN APPLICATION HEAP WHEN DROPPING A SQL *
* PROCEDURE *
* OR COMPILED SQL FUNCTION *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 v9.7 Fixpack 5 *
**************************************************************** |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 v9.7 Fixpack 5 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 31.08.2011
19.01.2012
19.01.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP5
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.5
|
 |
