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 IC71801 Status: Geschlossen

U+FF5E: FULLWIDH TLIDE,U+2015: HORIZONTAL BAR,U+FF0D:FULLWIDTH HYPHEN-MINUS
,U+2225: PARALLEL TO RETURN INCORRECT RESULTS

Produkt:
DB2 FOR LUW / DB2FORLUW / 970 - DB2
Problembeschreibung:
Shift-JIS  Microsoft primary code point 
---------  ------------------------------- 
X'8160'    U+FF5E: Fullwidh Tlide 
X'815C'    U+2015: Horizontal Bar 
X'817C'    U+FF0D: Fullwidth Hyphen-Minus 
X'8161'    U+2225: Parallel To 
 
used in search return the incorrect results
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Shift-JIS  Microsoft primary code point                      * 
*     ---------  -------------------------------               * 
*     X'8160'    U+FF5E: Fullwidh Tlide                        * 
*     X'815C'    U+2015: Horizontal Bar                        * 
*     X'817C'    U+FF0D: Fullwidth Hyphen-Minus                * 
*     X'8161'    U+2225: Parallel To                           * 
****************************************************************
Local-Fix:
verfügbare FixPacks:
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
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
Customer should upgrade to v9.7 FP4 or later FP which contains 
the fix for the above mentioned problem. 
 
The following is applicable only for SJIS database and for the 
searches that are used on double byte special characters. 
 
An environment variable is introduced which needs to be manually 
set/unset depending on the conversion table in use. 
If default conversion table is used , set the following 
environment variable before creating the index . 
 
export NSE_SJIS_USE_IBM_UCODE= TRUE 
db2set DB2ENVLIST=NSE_SJIS_USE_IBM_UCODE 
Restart DB2/NSE 
 
This helps in converting the characters in SJIS format to 
UNICODE according to IBM conversion table during update index 
process. 
The variable should be unset while Microsoft conversion table is 
in use.
Workaround
keiner bekannt / siehe Local-Fix
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
11.10.2010
09.05.2011
08.02.2012
Problem behoben ab folgender Versionen (IBM BugInfos)
9.7.FP4
Problem behoben lt. FixList in der Version
9.7.0.4 FixList