Connect to DB2 UDB

Execute the ECDA environment script to point to odbc.ini file to connect to DB2 UDB.

In the UNIX environment, the ODBC driver allows you to establish a centralized ODBC system information file that you can control. To do so, set the environment variable ODBCINI by executing the ECDA environment script to point to the qualified path name of the centralized file, provided by the ECDA installation. For example:

For C shell:

DC_SYBASE.csh

For Bourne or Korn shell:

DC_SYBASE.sh

Executing this script sets ODBCINI to install_dir/DC-15_0/connectivity/odbcini.

Remember, there must be an [ODBC] section in the system information file that includes the InstallDir keyword. Be sure that the keyword value is in the path to the directory install_dir/DC-15_0/connectivity.

Define Datasource Entries
To create and configure datasource entries for DRDA, edit the odbc.ini in the required parameters settings.
Example of an odbc.ini File for DB2 UDB on AS/400 or z/OS
An example of the DSN template for DB2 UDB. You must edit the section of the file that applies to your site.
Example of an odbc.ini File for DB2 UDB on Windows or UNIX
An example of the DSN template for DB2 UDB on Windows or UNIX. You must edit the section of the file that applies to your site.

Parent topic: Configure Data Sources for ECDA Option for ODBC