Oracle^® Business Intelligence Applications Installation and Configuration Guide > Preinstallation and Predeployment Considerations for Oracle BI Applications > Deploying Oracle Business Analytics 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. Connect to the Source database, using the following 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.