Skip to main content

Prerequisites

ON THIS PAGE

Prerequisites

The following topic lists the prerequisites for using an IBM DB2 for iSeries endpoint in a Replicate task.

Note:

iAccess ODBC driver 7.1.0. is not supported.

Client

  • Windows: To work with an IBM DB2 for iSeries database as a source in Qlik Replicate, the iSeries ODBC driver (5770-XE1 IBM i Access for Windows) must be installed on the Replicate Server machine.

    The minimum supported version is 12.64.

    Note:

    When Replicate is installed on Windows Server 2016, use the 5733XJ1 IBM i Access Client Solutions instead.

    The driver is part of IBM i Access Client Solutions, which can be downloaded from the IBM web site by authorized IBM customers. Note that it is not necessary to install all of the IBM i Access Client Solutions components, only the ODBC driver (which is installed regardless of which components you choose to install).

  • Linux: To work with an IBM DB2 for iSeries database as a source in Qlik Replicate, the iSeries ODBC driver (5770-XL1 IBM i Access for Linux) must be installed on the Replicate Server machine.

    The minimum supported version is 12.64.

    The driver is part of IBM i Access Client Solutions, which can be downloaded from the IBM web site by authorized IBM customers. Note that it is not necessary to install all of the IBM i Access Client Solutions components, only the ODBC driver (which is installed regardless of which components you choose to install).

    After installing the Linux Driver, edit the file /etc/odbcinst.ini and add the following section:

    [IBM i Access ODBC Driver 64-bit]

    Description = IBM i Access for Linux 64-bit ODBC Driver

    Driver = /opt/ibm/iaccess/lib64/libcwbodbc.so

    Setup = /opt/ibm/iaccess/lib64/libcwbodbcs.so

    Threading = 0

    DontDLClose = 1

    UsageCount = 1

Change processing

  • All of the source tables for a given Replicate task need to be journaled to the same journal. The name of the journal and the library in which it is located must be specified in the endpoint settings. During the task, Replicate polls this journal for changes to the source tables.

    When you start journaling the source tables, the Record images parameter can be set to *BOTH (for capturing before and after images) or *AFTER.

    When the Record images parameter set to *AFTER. deleted records will contain NULL values in their data fields. To save a copy of the deleted record to the deleted record journal, you must set the Record images parameter set to *BOTH.

    Note:

    If you need to run several Replicate tasks (that replicate data from IBM DB2 for iSeries), it is more efficient (though not essential) to create a separate journal for each task. As only one journal can be specified per endpoint, you would also need to define a separate endpoint for each task.

  • The MINENTDTA parameter must be set to *NONE as *FILE (minimal logging) is not supported.