DB2 - Problem description
Problem IC61458 | Status: Closed |
Memory is leaked when an EDU for unfenced store procedure terminates | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
Small memory buffer, related to the thread control block , is leaked when a db2 agent terminates. The memory leak happens only for the agents, executing unfenced store procedures. The leaked memory area can be reused by DB2 if OS creates new threads with reused thread ID. The leaked memory would be released when libdb2e.so library is unloaded from the DB2 engine ( db2sysc process ) | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * all platforms * **************************************************************** * PROBLEM DESCRIPTION: * * The memory is leaked when db2 agent, executing unfenced * * store procedure , terminates. A DB2 agent terminates when * * number of agents exceeds the number of max pool agents * * (NUM_POOLAGENTS) . The memory is released when the last * * application, executing an unfenced store procedure , * * disconnects and libdb2e.so is unloaded. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 V95FP5 * **************************************************************** | |
Local Fix: | |
Disconnect all applications , running unfenced stored procedures | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 5 for Linux, UNIX, and Windows | |
Solution | |
After installation of DB2 V95FP5 the problem would be resolved. No additional behavior changes would be seen. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC63993 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 10.06.2009 09.03.2010 09.03.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP5 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.5 |