|
Problem IC72079
|
Status: Closed |
PERFORMANCE DEGRADATION WHILE DOING FUZZY SEARCH ON ALPHANUMERIC STRINGS. |
| product: |
DB2 NET SEARCH / 5765F3800 / 950 - DB2 |
| Problem description: |
When Fuzzy search is used against alphanumeric strings its uses
lot of memory and sometimes can result in syatem hang.Hence its
recommended not to use Fuzzy search on alphanumeric
strings.Refer to technote
http://www-01.ibm.com/support/docview.wss?uid=swg21424334&myns=s
wgimgmt&mynp=OCSSEPGG&mynp=OCSSEPFH&mync=E
For customers who cannot migrate their applications to avoid
fuzzy searches on alphanumerics , anenvironmental variable is
introduced to limit the memory usage during the search |
| Problem Summary: |
When Fuzzy search is used against alphanumeric strings its uses
lot of memory and sometimes can result in syatem hang.Hence its
recommended not to use Fuzzy search on alphanumeric strings. |
| Local Fix: |
Avoid using fuzzy search on alphanumeric strings. |
| available fix packs: |
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 |
|
| Workaround |
Avoid Using Fuzzy search on alpha-numeric strings. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 21.10.2010
20.12.2010
20.12.2010 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
