Skip to main content Skip to complementary content

Prerequisites

Last updated: 2026-11-06

The 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

  1. Download IBM Data Server Client 12.1.4 (v12.1.4_ntx64_client.exe) from IBM Fix Central.
  2. 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.

  1. 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.

  2. Stop the Replicate service and optionally confirm that it has stopped as described in Replicate server procedures.

  3. 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.

  4. 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/V11.5/instance/db2icrt <db2_instance_name>

  5. Change the working directory to <Replicate_Install_Dir>/bin.

  6. 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

  7. Optionally, confirm that the driver location was copied:

    cat site_arep_login.sh
  8. 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

  9. 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

  1. 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.

  2. 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

  1. 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.

  2. 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.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!