IBM InfoSphere Federation Server, Version 10.5

Setting the Microsoft SQL Server environment variables

The Microsoft SQL Server 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 before you begin this task.

The db2dj.ini file contains configuration information about the Microsoft SQL Server ODBC driver that is installed on your federated server.

There are required and optional environment variables for Microsoft SQL Server data sources.

If you installed the Microsoft SQL Server client software before you installed the Microsoft SQL Server wrapper, the required Microsoft SQL Server 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 Microsoft SQL Server client software before you installed the Microsoft SQL Server wrapper or if you want to set any of the optional environment variables.

Procedure

Use one of the following methods:

Method Step

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.

Method	Step
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. On federated servers that run UNIX, this file is located in the sqllib/cfg directory. On federated servers that run Windows, this file is located in the %DB2PATH%\cfg directory. 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: `DJX_ODBC_LIBRARY_PATH=/opt/odbc/lib ODBCINI=/opt/odbc/.odbc.ini`

Manually set the environment variables.

Edit the db2dj.ini file.

On federated servers that run UNIX, this file is located in the sqllib/cfg directory.
On federated servers that run Windows, this file is located in the %DB2PATH%\cfg directory.

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:

DJX_ODBC_LIBRARY_PATH=/opt/odbc/lib 
ODBCINI=/opt/odbc/.odbc.ini

To ensure that the environment variables are set on the federated server, recycle the DB2® instance with these commands:
```
db2stop 
db2start
```

What to do next

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

Feedback