IBM InfoSphere Federation Server, Version 10.5

Setting required environment variables for data source clients

Ensure that the required environment variables are set in the db2dj.ini file. This task is required for Informix®, Microsoft SQL Server, Oracle, Sybase, and Teradata data sources, as well as for applications that use the JDBC and ODBC wrappers.

Before you begin

The system administrator performs this task.

About this task

If you install the client software before you install the federated server, the installation program automatically sets the required environment variables for the data sources that you select. If you install the client software after you install the federated server, upgrade to a new version of the client software, or migrate to new hardware, you can use either of the following methods to set the environment variables:

Use the wrapper configuration tool to set the environment variables.
Manually set the environment variables.

This following table lists the required environment variables, by data source.

Table 1. Required environment variables, by data source
Data source	Required variable	Value
Informix	INFORMIXDIR INFORMIXSERVER	For INFORMIXDIR, the directory containing the Informix client software. For INFORMIXSERVER, the name of the default Informix server.
JDBC	Varies, depending on the installed JDBC driver. If you do not specify the JDBC driver package in the DRIVER_PACKAGE server parameter of the CREATE SERVER statement, you must specify the JDBC driver package in the "CLASSPATH" system environment variable. See the documentation of your JDBC driver for specific information on setting system environment variables.	File name and directory of the JDBC driver library.
Microsoft SQL Server	DJX_ODBC_LIBRARY_PATH	Directory containing the ODBC library.
ODBC	Varies, depending on the ODBC application.	Varies, depending on the ODBC application.
Oracle	ORACLE_HOME	Directory containing the Oracle client software.
Sybase	SYBASE, SYBASE_OCS	For SYBASE, the directory containing the Sybase client software. For SYBASE_OCS, the directory, version, and release of the client software.
Teradata	COPYLIB	Directory containing the Teradata client software.

Procedure

Open the db2dj.ini file.
The db2dj.ini file is added to the federated server during installation. By default, the file is in the location that the DB registry variable DB2_DJ_INI specifies. If the DB2_DJ_INI registry variable is not set, the file is in these locations:
- On UNIX, the file is in instancehome/sqllib/cfg/db2dj.ini, where instancehome is the home directory of the instance owner
- On Microsoft Windows, the file is in %DB2PATH%\cfg\db2dj.ini, where %DB2PATH% is the directory where the DB2® database system is installed. For example, C:\Program Files\IBM\sqllib.
Use the syntax variable_name=variable_value to set the value of the environment variable. If the variable_value is a file or directory name, you must specify the fully qualified path. For example, to set the INFORMIDIR variable to the directory informix in the home directory /home/user1, include this entry in the db2dj.ini file:
```
INFORMIXDIR=/home/user1/informix
```
From the DB2 command line, issue these commands:
```
db2stop
db2start
```
You stop and then restart the database instance to ensure that the environment variables take effect.
If you are configuring a multi-partition system, copy the db2dj.ini file to each partition.

Feedback