Setting the Informix environment variables

The Informix® environment variables must be set in the db2dj.ini file on the federated server.

About this task

There are required and optional environment variables for Informix data sources. If you installed the Informix client software before you installed the Informix wrapper, the required Informix environment variables are set in the db2dj.ini file.

You must set the environment variables using the steps in this task if you did not install the Informix client software before you installed the Informix wrapper or if you want to set any of the optional environment variables.

Procedure

  1. Use one of the following methods to set the Informix environment variables that you want to use:
    Method Step
    To set the environment variables automatically Run the Db2® Setup program again and specify the Custom installation option. Follow the instructions in the wizard.
    Important: Running the installation program again will set only the required environment variables. The optional environment variables must be set manually.
    To set the environment variables with the wrapper configuration tool Run the wrapper configuration tool to set required and optional environment variables. Follow the instructions in Running the wrapper configuration tool.
    To set the environment variables manually Edit the db2dj.ini file.
    • On federated servers that run UNIX, the db2dj.ini file is located in the sqllib/cfg directory.
    • On federated servers that run Windows, the db2dj.ini file is located in the %DB2PATH%\cfg directory.
    The db2dj.ini file contains configuration information about the Informix client software that is installed on your federated server. If the file does not exist, you can create a file with the name db2dj.ini by using any text editor. In the db2dj.ini file, you must specify the fully qualified path for the environment variables; otherwise you will encounter errors. The following environment variables show what an entry in the db2dj.ini file on UNIX might look like:
    INFORMIXDIR=/informix/csdk
INFORMIXSERVER=inf10
  2. Set the Informix code page conversion environment variables (as necessary).
  3. To ensure that the environment variables are set on the federated server, recycle the federated database instance.
    Issue the following commands to recycle the federated database instance:
    db2stop 
db2start