Configuring IBM Data Server Driver for ODBC and CLI

You must configure the driver and application runtime environment before your application can use the driver successfully. Perform the following steps:

￿Configure aspects of driver behavior such as data source name, performance options, connection options, and user name by updating the db2cli.ini initialization file.

There is no support for CLP, you must update db2cli.ini file manually. This file is located at <install_dir>\clidriver\cfg on the Linux and UNIX systems and <install_dir>\clidriver on the Windows systems.

Note: If you have multiple copies of the driver installed, each copy has its own db2cli.ini file. Ensure that you make changes to the correct copy.

￿Configure the application environment variables:

Optional: Because there is no support for CLP, DB2 registry variables are supported as environment variables. Set any applicable DB2 environment variables corresponding to its equivalent DB2 registry variables.

Table 4-3shows the environment variables.

Table 4-3 DB2 registry variables supported as environment variables

Type of variable

Variable names

 

 

General variables

DB2ACCOUNT

 

 

 

DB2BIDI

 

 

 

DB2CODEPAGE

 

 

 

DB2COUNTRY

 

 

 

DB2GRAPHICUNICODESERVER

 

 

 

DB2LOCALE

 

 

 

DB2TERRITORY

 

 

System environment variables

DB2DOMAINLIST

 

 

Communications variables

DB2_FORCE_NLS_CACHE

 

 

 

DB2SORCVBUF

 

 

 

DB2SOSNDBUF

 

 

 

DB2TCP_CLIENT_RCVTIMEOUT

 

 

Performance variables

DB2_NO_FORK_CHECK

 

 

Chapter 4. Deploying applications with DB2 147

Page 161
Image 161
IBM Configuring IBM Data Server Driver for Odbc and CLI, DB2 registry variables supported as environment variables