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

When you convert from coded character set identifier (CCSID) 5039 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 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, 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.

Procedure

To replace the Db2 default conversion table for converting from CCSID 5039 to Unicode:

  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.
  2. Copy sqllib/conv/ms/5039ucs2.cnv to sqllib/conv/5039ucs2.cnv.
  3. Restart all the applications.