Latest versionsfixlist
11.1.0.6 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
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26
Question in the chat LiveZilla Live Help

DB2 - Problem description

Problem IC70666 Status: Closed

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

product:
DB2 NET SEARCH / 5765F3800 / 950 - DB2
Problem description:
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 Summary:
**************************************************************** 
* 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                               * 
**************************************************************** 
Using the following japanese special characters in search word 
returns incorrect reults: 
 
U+FF5E: FULLWIDH TLIDE 
U+2015: HORIZONTAL BAR 
U+FF0D:FULLWIDTH HYPHEN-MINUS 
U+2225: PARALLEL TO
Local Fix:
available fix packs:
DB2 Version 9.5 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.5 Fix Pack 10 for Linux, UNIX, and Windows

Solution
Customer should upgrade to v9.5 FP7 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
not known / see Local fix
BUG-Tracking
forerunner  : APAR is sysrouted TO one or more of the following: IC71801 IC71802 
follow-up : 
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
24.08.2010
25.01.2011
08.02.2012
Problem solved at the following versions (IBM BugInfos)
9.5.FP7
Problem solved according to the fixlist(s) of the following version(s)
9.1.0.7 FixList
9.5.0.7 FixList
This site uses cookies to make it easier for us to provide you with our services. By using our site you agree to the use of cookies.