|
Problem IC90054
|
Status: Closed |
SINGLE CHARACTER SEARCH MAY RESULT IN CTE0103 |
| product: |
DB2 NET SEARCH / 5765F3800 / A10 - DB2 |
| Problem description: |
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 Summary: |
****************************************************************
* USERS AFFECTED: *
* NSE user *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.1 Fix Pack 3. *
**************************************************************** |
| Local Fix: |
Recreate the index. |
| available fix packs: |
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
|
| Solution |
First fixed in Version 10.1 Fix Pack 3. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.02.2013
07.10.2013
07.10.2013 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.1.0.3
|
 |
| 10.1.0.3
|
|
