Setting the Teradata environment variables

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

About this task

Restrictions

Review the restrictions for the db2dj.ini file.

The db2dj.ini file contains configuration information about the Teradata client software that is installed on your federated server.

There are required and optional environment variables for Teradata data sources.

If you installed the Teradata client software before you installed the Teradata wrapper, the required Teradata environment variables are set in the db2dj.ini file.

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

Procedure

  1. Use one of the following methods:
    Method Step
    Automatically set the environment variables. Run the Federation component installation wizard. Follow the instructions in the wizard.
    Important: Set the required environment variables by running the installation wizard. The optional environment variables must be set manually.
    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.
    Manually set the environment variables. Edit the db2dj.ini file:
    The db2dj.ini file is located in the directory that the Db2® registry variable DB2_DJ_INI specifies. When the DB2_DJ_INI variable is not set, the db2dj.ini file is in one of the following default paths depending on the operating system:
    • On UNIX: instancehome/sqllib/cfg/db2dj.ini.
      instancehome
      The home directory of the instance owner.
    • On Windows: %DB2PATH%\cfg\db2dj.ini
      %DB2PATH%
      The directory where the Db2 database system is installed, for example, C:\Program Files\IBM\sqllib.
    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 in the value of the environment variables; otherwise you will encounter errors. For example:
    COPLIB=/usr/lib
  2. Set the Teradata 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 with these commands:
    db2stop 
    db2start  

What to do next

After you complete this task, you can register the wrapper.