IBM BD2

The IMB DB2 Database integration will connect trough ODBC. Therefore you need to have the ODBC driver installed on the machine where the WriteBackExtreme application is also located.

Download the drivers for your system at https://www.ibm.com/docs/en/db2-warehouse?topic=db2-downloading-clients-drivers

The downloaded package contains a readme file that describes the instructions for your platform.

Windows

Use the following commands to setup the driver and ODBC configuration

./db2cli.exe install -setup
./db2cli.exe writecfg add -database [database] -host [host] -port 50000
./db2cli.exe writecfg add -dsn [dsn_name] -database [database] -host [host] -port 50000
./db2cli.exe registerdsn -add -dsn [dsn_name]

Replace the [host], [database] and [dsn_name] to your situation.

Validate the ODBC using this command:

./db2cli.exe validate -dsn [dsn_name] -connect -user [username] -passwd "[password]"

Linux

Once the driver is installed under /opt/ibm/dsdriver, the next step is to configure ODBC by updating the /etc/odbc.ini file.

[IBMDB2]
Driver=/etc/ibm/dsdriver/lib/libdb2o.so

Last updated

Was this helpful?