home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC95365 Status: Geschlossen

PRIVATE MEMORY LEAK ON THE DB2 SERVER BY THE DB2PFCHR THREAD

Produkt:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problembeschreibung:
db2sysc process will increase in memory consumption over time. 
 
db2 private memory leak is observed within the db2pfchr thread. 
db2pd -memset output will show the 
committed size keep increasing over time for the private memory 
set. 
 
db2 select MEMORY_POOL_TYPE, MEMORY_POOL_ID, APPLICATION_HANDLE, 
 
EDU_ID, MEMORY_POOL_USED, MEMORY_POOL_USED_HWM from 
 
table"(mon_get_memory_pool('PRIVATE',null,null))" 
 
will show the max private memory is consumed by the edu threads 
corresponding to the db2prefchr threads. 
 
e.g. 
MEMORY_POOL_TYPE                 MEMORY_POOL_ID 
APPLICATION_HANDLE   EDU_ID               MEMORY_POOL_USED 
MEMORY_POOL_USED_HWM 
-------------------------------- -------------------- 
-------------------- -------------------- -------------------- 
-------------------- 
PERSISTENT_PRIVATE                                 86 
-                    0             17956864             25427968 
PRIVATE                                            88 
-                 7455              8454144              8519680 
PRIVATE                                            88 
-                 7712              7864320              7864320 
PRIVATE                                            88 
-                 7969              6881280              6881280 
 
db2pd -memblocks pid=<db2sysc pid> will show the LOC as follows: 
Memory blocks sorted by size: 
 
PoolID     PoolName   TotalSize(Bytes)     TotalCount LOC   File 
 
0                     248320000            12125      1231 
1480119721 
 
The leak is due to incorrect memory deallocation by the 
db2prefchr thread.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW V10.5 Fix Pack 3 or Later.                * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 10.5 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Cancun Release 10.5.0.4 (also known as Fix Pack 4) for Linux, UNIX, and Windows
DB2 Version 10.5 Fix Pack 9 for Linux, UNIX, and Windows

Lösung
First Fixed in DB2 LUW V10.5 Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
27.08.2013
30.07.2014
30.07.2014
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version
10.5.0.3 FixList
10.5.0.3 FixList
10.5.0.4 FixList