Replacing the Unicode conversion table for CCSID 954 with the Microsoft conversion table

When you convert from coded character set identifier (CCSID) 954 to Unicode, the Db2® database manager default code page conversion table is used. If you want to use a different version of the conversion table such as the Microsoft version, you must manually override the default conversion table.

Before you begin

If the code page conversion table file you want to override exists in the conv subdirectory of the sqllib directory, you should back up that file in case you want to revert to the default table.

About this task

For conversion table replacement to be effective, every Db2 client that connects to the same database must have its conversion table changed. If your client is Japanese Windows whose ANSI code page is Shift-JIS (CCSID 943), you must also change the default conversion tables between CCSID 943 and Unicode to the Microsoft version. Otherwise, the different clients might store the same character using different code points.

Procedure

To replace the Db2 default conversion table for converting from CCSID 954 to Unicode, follow these steps:

  1. When replacing conversion tables on the client, stop all the applications that are using the database.
    If you have any CLP sessions running, issue the TERMINATE command for each session. When replacing conversion tables on the database server, stop all instances on all nodes by issuing the db2stop command.
  2. Copy sqllib/conv/ms/0954ucs2.cnv to sqllib/conv/0954ucs2.cnv.
  3. Restart all the applications.