|
Problem IC66613
|
Status: Closed |
DB2EXT.TEXTSEARCH(FUZZY FORM OF 80 "99????8" CAUSES LARGE AMOUNTS OF MEMORY TO BE ALLOCATED BUT NOT FREED |
| product: |
DB2 NET SEARCH / 5765F3800 / 950 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* 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: |
|
| available fix packs: |
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
|
| Solution |
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 |
not known / see Local fix |
| BUG-Tracking |
forerunner : APAR is sysrouted TO one or more of the following: IP23023 IC68086 IC68089
follow-up : |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 25.02.2010
09.09.2010
09.09.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
