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

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

Produkt:
DB2 NET SEARCH / 5765F3800 / 950 - DB2
Problembeschreibung:
Some of the queries using NSE Fuzzy search on numerical/alphanum 
values consumes lot of memory and results in a system hang or 
CTE0104 error. The memory allocated is not freed even after the 
termination of application. 
 
This APAR fix addresses the following: 
 
1.Memory is freed after the query returns with  CTE0104 error. 
2.Reduces the memory consumption in case of Fuzzy search on 
alphanumerical values that contain a combination of SBCS and 
DBCS characters
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
* ALL DB2+NSE Users and Content Manager Users                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* Some of the queries using NSE Fuzzy search on                * 
* numerical/alphanumeric values consumes lot of memory and     * 
* results in a system hang or return CTE0104 error. The memory * 
* allocated is not freed even after the termination of         * 
* application.                                                 * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IBM DB2 Net Search Extender V.9.5.0.6             * 
**************************************************************** 
Problem Statement: 
Fuzzy search on a numerical/alpha-numerical columns fails with 
CTE0104 error consuming lots of memory. After the error the 
memory allocated is not freed by NSE. 
 
This APAR fixes the above problem by freeing the allocated 
memory after the CTE0104 error.
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.5 Fix Pack 6a for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Lösung
This APAR fix addresses the following: 
1.Memory is freed after the query returns with CTE0104 error. 
2.Reduces the memory consumption in case of Fuzzy search on 
alphanumerical values that contain a combination of SBCS and 
DBCS characters 
 
The problem is fixed in IBM DB2 Net Search Extender V.9.5.0.6
Workaround
keiner bekannt / siehe Local-Fix
Bug-Verfolgung
Vorgänger  : APAR is sysrouted TO one or more of the following: IP23023 IC68086 IC68089 
Nachfolger : 
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
25.02.2010
09.09.2010
09.09.2010
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version