IBM BD2

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