|
Problem IC90054
|
Status: Geschlossen |
SINGLE CHARACTER SEARCH MAY RESULT IN CTE0103 |
| Produkt: |
DB2 NET SEARCH / 5765F3800 / A10 - 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 user *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3. *
**************************************************************** |
| Local-Fix: |
Recreate the index. |
| verfügbare FixPacks: |
DB2 Version 10.1 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 10.1 Fix Pack 3a for Linux, UNIX, and Windows
|
| Lösung |
First fixed in Version 10.1 Fix Pack 3. |
| Workaround |
keiner bekannt / siehe Local-Fix |
| Weitere Daten |
Datum - Problem gemeldet :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
| 05.02.2013
07.10.2013
07.10.2013 |
| Problem behoben ab folgender Versionen (IBM BugInfos) |
|
| Problem behoben lt. FixList in der Version |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
