DB2 - Problembeschreibung
Problem IC80394 | Status: Geschlossen |
CHANCES OF MEMORY LEAK INTRODUCED IN VERSION 9.7 FIX PACK 5 | |
Produkt: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problembeschreibung: | |
In Version 9.7 Fix Pack 5, chances of having a memory leak have been introduced. To check if a memory leak has happened, issue the db2pd -memb command and check if the output of the command looks similar to the following output: Memory blocks sorted by size for private pool: PoolID PoolName TotalSize(Bytes) TotalCount LOC File 88 private 264376936 164622 1541 2904145706 88 private 131072 1 1287 789176096 88 private 49152 5 385 1234005865 88 private 7072 2 1253 2506170342 88 private 4296 1 246 2926445243 Total size for PRIVATE memory set: 283633406 bytes Memory blocks sorted by size for private pool: PoolID PoolName TotalSize(Bytes) TotalCount LOC File 88 private 283437968 175389 1541 2904145706 88 private 131072 1 1287 789176096 88 private 49152 5 385 1234005865 88 private 7072 2 1253 2506170342 The private memory usage in file 2904145706 at line 1541 keeps leaking and consumes physical memory. This memory leak can happen if a query uses a LOB locator for the output column. Example: ODBC application does: select substr( clob_column, 1, 30 ) from t1 SQLBindCol is done with with SQL_C_CLOB_LOCATOR The query is returning a LOB column, but the client wants a LOB locator. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * N/A * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Install fix * **************************************************************** | |
Local-Fix: | |
n/a | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows | |
Lösung | |
Install fix | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Bug-Verfolgung | |
Vorgänger : APAR is sysrouted TO one or more of the following: IC84259 IC84266 Nachfolger : | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 13.12.2011 06.06.2012 06.06.2012 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
Problem behoben lt. FixList in der Version | |
9.7.0.6 |