|
Problem IC83778
|
Status: Geschlossen |
MEMORY LEAK USING TWO_PHASE COMMIT TRANSACTIONS AND ACTIVITY INVOLVING LOG SCANNING |
| Produkt: |
DB2 FOR LUW / DB2FORLUW / A10 - DB2 |
| Problembeschreibung: |
On DB2 version 9.8 and higher, a memory leak may occur whenever
"non-recovery" log scanning activities read logs containing
two-phase commit transactions. The leak occurs in the database
heap and can accumulate quickly on systems where regular log
scanning occurs, such as replication.
Memory usage in the database heap can be monitored with the
MON_GET_MEMORY_POOL routine (track the MEMORY_POOL_USED column)
, or db2pd -db <db> -mempools (track the PhySz column),
db2pd -db <db> -memblocks 2
will show an increasing number of records with the following
LOC, File combination (LOC can differ across different DB2
releases, Fix Packs):
PoolID PoolName Size(Bytes) LOC File
2 dbh 1480 905 242487389 |
| Problem-Zusammenfassung: |
****************************************************************
* USERS AFFECTED: *
* All systems *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 1 *
**************************************************************** |
| Local-Fix: |
|
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 6 for Linux, UNIX, and Windows
|
| Lösung |
First fixed in DB2 Version 10.1 Fix Pack 1 |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 25.05.2012
31.10.2012
31.10.2012 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.1
|
 |
| 10.5.0.1
|
|
