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 IC68086 Status: Geschlossen

DB2EXT.TEXTSEARCH(FUZZY FORM OF 80 "99????8" CAUSES LARGE
AMOUNTS OF MEMORY TO BE ALLOCATED BUT NOT FREED

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
NSE query uses up large memory and does not release it even 
after the application is terminated by db2 force application 
command. As a result it uses up system memory and new 
connections fail. 
 
Certain NSE searches that uses FUZZY form of  option against a 
large numerical values uses up large amount of 
memory and fails with CTE0104 or hangs. 
 
 
The issues which need to be fix are: 
 
- NSE mallocing large amount of memory 
 
- NSE not freeing the memory even when application is terminated 
from 
  the database.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL                                                          * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* NSE query uses up large memory and does not release it even  * 
*                                                              * 
* after the application is terminated by db2 force application * 
*                                                              * 
* command. As a result it uses up system memory and new        * 
*                                                              * 
* connections fail.                                            * 
*                                                              * 
*                                                              * 
*                                                              * 
* Certain NSE searches that uses FUZZY form of  option against * 
* a                                                            * 
* large numerical values uses up large amount of               * 
*                                                              * 
* memory and fails with CTE0104 or hangs.                      * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
*                                                              * 
* The issues which need to be fix are:                         * 
*                                                              * 
*                                                              * 
*                                                              * 
* - NSE mallocing large amount of memory                       * 
*                                                              * 
*                                                              * 
*                                                              * 
* - NSE not freeing the memory even when application is        * 
* terminated                                                   * 
* from                                                         * 
*                                                              * 
*   the database.                                              * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* n/a                                                          * 
****************************************************************
Local-Fix:
Lösung
Problem is first fixed in Version 9.7 Fix Pack 3
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
23.04.2010
23.09.2010
23.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP3
Problem behoben lt. FixList in der Version