|
Problem IC90053
|
Status: Closed |
SINGLE CHARACTER SEARCH MAY RESULT IN CTE0103 |
| product: |
DB2 NET SEARCH / 5765F3800 / 970 - 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 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. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
First fixed in DB2 Version 9.7 Fix Pack 9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 05.02.2013
13.01.2014
13.01.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
