DB2 FOR LUW / DB2FORLUW / 970 - DB2

Square brackets([ ]) and caret(^) characters from source 
codepage 937 to target codepage 950 replaced by substitute 
characters on codepage covnersion. DB2 users can use alternate 
table 09370950.cnv provided as the APAR fix to map these 
characters([,],^) to appropriate codepoints. The alternate 
conversion table "09370950.cnv" is located under sqllib/conv/alt 
directory. To get the updated mapping, copy the alternate table 
from sqllib/conv/alt directory to sqllib/conv directory and 
rerun your application or database/instance in some 
circumstances, eg. accessing nickname via federated server. 
 
The default mapping without the alternate conversion table: 
 
   937          950 
char code    code char 
---- ----    ---- ---- 
 ?  4A      5B   [ 
 ?   5F      5E   ^ 
 |   6A      5D   ] 
 ^   B0      7F   SUB 
 [   BA      7F   SUB 
 ]   BB      7F   SUB 
 
New mapping after applying alternate table: 
 
    937        950 
char code    code char 
---- ----    ---- ---- 
 ?  4A      7F   SUB 
 ?   5F      7F   SUB 
 |   6A      7F   SUB 
 ^   B0      5E   ^ 
 [   BA      5B   [ 
 ]   BB      5D   ] 
 
Codpage 937 is host codepage for Taiwan and territory identifier 
is TW. Issue is applicable if database is on host system (eg 
iSeries).

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users using codepage conversion from 937 to 950.         * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Update to version 9.7 fixpack 7 or higher fixpacks.          * 
****************************************************************

To make the conversion same as new mapping without the alternate 
conversion table, codepage 1208(Unicode) shall be involved as an 
intermediate. 
For example, if nickname via federated server is used for 
accessing database with CP937 on iSeries, and the local database 
is using CP950 on LUW platform, then conversion from CP937 to 
CP950 will happen. To bypass conversion 937->950, it is better 
to create a UTF8 database and create nickname in it. Then, the 
conversion will become 937->1208->950. The steps are similar to 
following steps. 
 
  1. create database new using codeset UTF8 territory TW 
  2. create wrapper, server, nickname in the UTF8 database for 
accessing db with CP937 on AS400. 
  3. db2set DB2CODEPAGE=950 
  4. db2 terminate 
Then, the conversion will be 937->1208->950 every time accessing 
data in db with CP937 using db2 CLP.

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
 

This problem is first fixed in version 9.7 fixpack 7.

not known / see Local fix

forerunner  : APAR is sysrouted TO one or more of the following: IC87901 
follow-up : 

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

10.05.2012
20.10.2012
20.10.2012

9.7.FP7