Siebel Business Analytics Applications Installation and Administration Guide > Preinstallation Considerations for Analytics Applications > Deploying Siebel Data Warehouse in Latin-1 General, Unicode and Non-English Environments >

Setting the DB2CODEPAGE Environment Variable for DB2 Databases

Follow this procedure to set the DB2CODEPAGE environment variable for DB2 databases.

To set the DB2CODEPAGE environment variable for DB2 databases

1. Determine the DB2CODEPAGE value.
   1. In the data warehouse database, run the command

   SELECT CODEPAGE FROM SYSCAT.DATATYPES WHERE TYPENAME = 'VARCHAR'

   2. Make a note of the result.

      For example: 1208

2. For Windows:
   1. Navigate to Control Panel > System and click the Advanced tab. Click Environment Variables.
   2. In System variables section, click New.
   3. In the Variable Name field, DB2CODEPAGE.
   4. In the Variable Value field, enter the value that was returned in Step 1.
3. For UNIX, set the variable as shown below:

   setenv DB2CODEPAGE <DB2CODEPAGE value>

   For example: setenv 1208.

4. Reboot the machine after creating the variable.