beautypg.com

IBM Data Server DB2 User Manual

Page 161

background image

Chapter 4. Deploying applications with DB2

147

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 \clidriver\cfg on the Linux and UNIX systems and
\clidriver on the Windows systems.

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-3 shows the environment variables.

Table 4-3 DB2 registry variables supported as environment variables

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.

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