Setting the character encoding of the DB2e synchronization serverAdded by IBM on October 4, 2010 | Version 1 (Original)
|This topic explains how to configure the character encoding of the DB2e synchronization server. If a configured user ID or password contains double-byte or diacritic characters, the character encoding of the client system must match the character encoding of the server.
This topic explains how to configure the character encoding of the DB2e synchronization server. If a configured user ID or password contains double-byte or diacritic characters, the character encoding of the client system must match the character encoding of the server.
If user IDs and/or passwords that contain double-byte characters or diacritics, such as umlauts, will be used with the synchronization services of DB2® Everyplace®, you must ensure that the DB2 Everyplace application server uses the same code page as the code page that is set on the operating system where the Expeditor Client is running. You must also ensure that the DB2 Everyplace database is created with a code page that supports the national language characters that you plan to use. The locale setting of operating system where the DB2e Mobile Device Administration Center runs should be the same as the Expeditor Client.
To set the character encoding at the server, follow these steps:
- Open the WebSphere® Administrative Console:
is the fully-qualified host name for the machine that contains the administrative server, and port_number
is the administrative console port number.
- In the left pane, click Servers > Application Servers.
- Click the DB2 Everyplace application server ( (IBMDB2eServer).
- On the Configuration tab, click Java™ and Process Management > Process Definition.
- Under Additional Properties, click Java Virtual Machine.
- Under Additional Properties, click Custom Properties.
- Create the following WebSphere environment variable, which is used to specify the character encoding used for Basic Authentication:
- Set the encoding value, such as UTF-8 (recommended).
- Save your changes.
- Restart the DB2 Everyplace application server.
To set the default encoding for the database, follow these steps before creating the database or installing the server:
- On the DB2 server, start a DB2 command environment as follows:
: From a shell prompt, switch to the DB2 instance using su - db2inst1
, for instance.
: From a command prompt, type db2cmd
. A new db2cmd window is displayed.
- Run the following commands:
specifies the code page number. Note that code page 1208 maps to UTF-8 and is recommended.
- If installing a remote database, create the database.
- If installing a local database, install the server.
- After installation and configuration are successful, you may reset the DB2CODEPAGE value by running the following command:
For additional information see the Technote at: http://www.ibm.com/support/docview.wss?rs=212&uid=swg21263682
Parent topic: Installation procedures and scenarios: XPD621