Configure environment variables (DB2®)

To configure environment variables for DB2®, identify the DB2® database code page, then set the DB2CODEPAGE DB2® environment variable to the same value. For localized environments, the DB2® database code page must be 1208.

About this task

Follow these steps to set the DB2CODEPAGE DB2® environment variable to 1208.

Procedure

  1. On Windows, add the following line to the Unica Campaign Listener startup script (<CAMPAIGN_HOME>\bin\cmpServer.bat):

    db2set DB2CODEPAGE=1208

  2. On UNIX:
    1. After DB2® is started, the system administrator must type the following command from the DB2® instance user:

      $ db2set DB2CODEPAGE=1208

      After completing this step, the administrator does not need to run the db2set DB2CODEPAGE=1208 command from the DB2® instance user again, because the value is registered for the DB2® instance user. The root user cannot run the command because the root user might not have sufficient permission.

    2. To verify the setting, type the following command and confirm that the output is 1208:

      $ db2set DB2CODEPAGE

    3. To confirm that the DB2CODEPAGE setting works for the root user, type the following command on the $CAMPAIGN_HOME/bin directory and confirm that the output is 1208:

      # . ./setenv.sh

      # db2set DB2CODEPAGE

    4. Run the following command to start the Unica Campaign listener:

      ./rc.unica_ac start