Prerequisites
Last updated: 2026-11-16The following section describes the prerequisites for working with Qlik Replicate and the IBM DB2 for z/OS target endpoint.
Both the IBM Data Server Driver for ODBC and CLI driver and the IBM Data Server Driver for JDBC and SQLJ driver need to be installed on the Replicate machine. When installing on Linux, you can choose between installing the full ODBC client package or installing just the data server client.
IBM Data Server Driver for ODBC and CLI driver setup
Supported drivers
Replicate supports ODBC and CLI driver version 11.5.9 and version 12.1.4. The setup instructions use version 12.1.4.
Replicate on Windows
- Download IBM Data Server Client 12.1.4 (v12.1.4_ntx64_client.exe) from IBM Fix Central.
- Install it on the Qlik Replicate Server machine.
Replicate on Linux
When installing on Linux, you can choose between installing the full ODBC client package or installing just the data server client.
Linux ODBC client package
If you prefer, you can install the data server client only as described in Linux data server client below.
In the following procedure, replace <version-number> with 12.1.4.
-
Download the IBM Data Server Driver for ODBC and CLI <version-number> (v<version-number>_linuxx64_server_dec.tar.gz) from IBM Fix Central. Select the driver version and platform required for your installation.
-
Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.
-
Unzip v<version-number>_linuxx64_server_dec.tar.gz and extract the files. Then run the installation, choosing the “CLIENT” option.
For guidance, see Installing the Db2 driver package on Linux.
-
If the Replicate machine does not have a DB2 instance, create a DB2 instance by running the following commands:
adduser <db2_instance_name>
/opt/ibm/db2/V<version-number>/instance/db2icrt <db2_instance_name>
-
Change the working directory to <Replicate_Install_Dir>/bin.
-
Add the DB2 driver location to the Linux library path.
To do this, add the following line to the site_ arep_login.sh file as follows:
export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/path/lib
where path is the CLIENT path to the driver.
Example (with db2clnt1 as the instance name):
export LD_LIBRARY_PATH=\$LD_LIBRARY_PATH:/home/db2clnt1/sqllib/lib:/home/db2clnt1/sqllib/lib64/gskit
export DB2INSTANCE=db2clnt1
-
Optionally, confirm that the driver location was copied:
cat site_arep_login.sh -
Add the following entry to the odbcinst.ini file under /etc:
[IBM DB2 ODBC DRIVER]
Driver = /home/db2clnt1/sqllib/lib/libdb2o.so
fileusage=1
dontdlclose=1
-
Start the Replicate service and optionally confirm that it has started as described in Replicate server procedures.
Linux data server client
(missing or bad snippet)IBM Data Server Driver for JDBC and SQLJ driver setup
Supported drivers
Replicate supports the IBM Data Server Driver for JDBC and SQLJ packages for Db2 versions 11.5.6, 11.5.8, and 12.1.4. The setup instructions use the 12.1.4 package.
Replicate on Windows
From IBM Fix Central, select IBM Data Server Client Packages version 12.1.4 and download v12.1.4_jdbc_sqlj.tar.gz for Windows.
Extract the contents and copy the db2jcc4.jar file to <REPLICATE-INSTALL-DIR>\java
The default location is C:\Program Files\Attunity\Replicate\java.
Replicate on Linux
From IBM Fix Central, select IBM Data Server Client Packages version 12.1.4 and download v12.1.4_jdbc_sqlj.tar.gz for Linux.
Extract the contents and copy the db2jcc4.jar file to <REPLICATE-INSTALL-DIR>/java.
The default location is /opt/attunity/replicate/java.
Application compatibility
The APPLCOMPAT bind option must be set to V12R1.