|
Problem IC71432
|
Status: Geschlossen |
MEMORY LEAK IN AGENT PRIVATE HEAP WITH SINGLETON SELECT INTO .. INCLUDING LOB DESCRIPTOR - IMPACTS QUERY PATROLLER |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problembeschreibung: |
A memory leak in DB2 agent private memory exists on DB2 Version
9.7. Memory is leaked every time an associated application
executes a singleton select, i.e. "select into", which includes
a LOB descriptor. In application snapshot monitoring, this
memory shows up as "Other Memory" for the application. A
database manager snapshot will show "Committed private Memory"
increasing. The memory will be released if the agent with the
leaked private memory terminates (as opposed to being returned
to the agent pool).
Query Patroller is impacted by this. Significant memory growth
may occur each time a purge job is run. |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* Systems using Query Patroller, other applications executing *
* singleton SELECTs with LOB descriptors *
****************************************************************
* PROBLEM DESCRIPTION: *
* See error description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 Fix Pack 4 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
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
|
| Lösung |
Problem first fixed in DB2 9.7 Fix Pack 4 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 23.09.2010
13.05.2011
13.05.2011 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
9.7.FP4
|
| Problem behoben lt. FixList in der Version |
| 9.7.0.4
|
 |
