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

When you convert between coded character set identifier (CCSID) 943 and Unicode, the Db2 database manager default code page conversion tables are used. If you want to use a different version of the conversion tables, such as the Microsoft version, you must manually override the default conversion tables.

Before you begin

If the code page conversion table file you want to override already 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, the conversion table on the database server and all of its clients must be changed.

Procedure

To replace the Db2® default conversion tables for converting between CCSID 943 and 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/0943ucs2.cnv to sqllib/conv/0943ucs2.cnv.
  3. Copy sqllib/conv/ms/ucs20943.cnv to sqllib/conv/ucs20943.cnv.
  4. Restart all the applications.