Filter
Top Products
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 <install_dir>\clidriver\cfg on the Linux and UNIX systems and
<install_dir>\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