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

The next thing to configure is setting the DB2INSTANCE environment variable on the service so that the driver knows what instance to connect to.

Open /etc/sysconfig/WriteBackExtreme

Add this line:

DB2INSTANCE=[your_db_istance]

Replace [your_db_istance] with your db instance.

Reboot the WriteBackExtreme service afterwards.