home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

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
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 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 FixList
9.7.0.9 FixList