DB2 - Problembeschreibung
Problem IC90053 | Status: Geschlossen |
SINGLE CHARACTER SEARCH MAY RESULT IN CTE0103 | |
Produkt: | |
DB2 NET SEARCH / 5765F3800 / 970 - DB2 | |
Problembeschreibung: | |
Single character search may result in CTE0103. Not only fuzzy search but also non-fuzzy search can hit this problem. Ex: db2 "SELECT count(*) FROM TABLE1 WHERE CONTAINS (article, 'FUZZY FORM OF 90 \"hara\"')=1" db2 "SELECT count(*) FROM TABLE1 WHERE CONTAINS (article, '\"hara\"')=1" Note: "hara" in above examples is a single Japanese character in this case. The keyword may depend on the environment. This issue is similar to APAR IC85081 where SBCS fuzzy search resulted in CTE0103 error. This APAR is opened for single character fuzzy/non-fuzzy DBCS search. | |
Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * NSE users with DBCS search strings * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.7 Fix Pack 9 * **************************************************************** | |
Local-Fix: | |
Recreate the index. | |
verfügbare FixPacks: | |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows | |
Lösung | |
First fixed in DB2 Version 9.7 Fix Pack 9. | |
Workaround | |
keiner bekannt / siehe Local-Fix | |
Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 05.02.2013 13.01.2014 13.01.2014 |
Problem behoben ab folgender Versionen (IBM BugInfos) | |
9.7.FP9 | |
Problem behoben lt. FixList in der Version | |
9.7.0.9 | |
9.7.0.9 |