|
Problem IC72079
|
Status: Geschlossen |
PERFORMANCE DEGRADATION WHILE DOING FUZZY SEARCH ON ALPHANUMERIC STRINGS. |
| Produkt: |
DB2 NET SEARCH / 5765F3800 / 950 - DB2 |
| Problembeschreibung: |
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-Zusammenfassung: |
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. |
| verfügbare FixPacks: |
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 |
|
| Workaround |
Avoid Using Fuzzy search on alpha-numeric strings. |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 21.10.2010
20.12.2010
20.12.2010 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 9.1.0.7
|
 |
| 9.5.0.7
|
|
