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.
The system administrator performs this task.
Data source | Required variable | Value |
---|---|---|
Informix | INFORMIXDIR |
For INFORMIXDIR, the directory |
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, |
For SYBASE, the directory |
Teradata | COPYLIB | Directory containing the Teradata client software. |