Prerequisites for Installing Oracle GoldenGate for Db2 for i

Learn the prerequisites for installing Oracle GoldenGate for a Db2 for i database.

General Requirements

  • Portable Application Solution Environment (PASE) must be installed on the system.

  • Java 8 must be installed on the IBM i and the Linux host system where GoldenGate for IBM i will run.

  • OpenSSH is recommended to be installed on the system. OpenSSH is part of the IBM Portable Utilities licensed program and allows SSH terminal access to the system in the same manner as other Linux system.

  • A library/schema should be dedicated to each deployment of Oracle GoldenGate on the IBM i system. The value of the library/schema is taken from the Replication Schedma property.

  • The IBM Db2 for i Program temporary fixes (PTFs) that are required by release for Oracle GoldenGate are detailed in the following tables:

    IBM i7.3 Group PTF Level Name Notes

    SF99730

    23257

    Cumulative PTF

    NA

    SF99731

    12

    All PTF groups except cumulative PTF package

    .
    IBM i7.4 Group PTF Level Name Notes

    SF99740

    23313

    Cumulative PTF

    NA

    SF99741

    9

    All PTF groups except cumulative PTF package

    NA
    IBM i7.5 Group PTF Level Name Notes

    SF99750

    23306

    Cumulative PTF

    NA

    SF99751

    5

    All PTF groups except cumulative PTF package

    NA

    These required PTFs are the levels at which Oracle GoldenGate has been tested against for the 23ai releases. To check the group PTF levels, you must use the WRKPTFGRP command from a 5250 terminal session and check for the specific PTFs with the commands shown in the preceding tables. The specific extra PTFs must be at least temporarily applied.

Choosing an Installation Operating System

Oracle GoldenGate for Db2 for i operates remotely on Intel Linux systems. A few componenets will be automatically copied to the IBM i systems.

Oracle GoldenGate for Db2 for i supports the IBM i Access ODBC Driver 64-bit. For more information, see Supported ODBC Driver and ODBC Driver for IBM i Access Client Solutions.

Consider the following:

  • The best performance is seen with a system that has the lowest network latency to the IBM i system that you use. Although it is possible to run over a wide area network, the performance suffers due to the increased network latency.

  • No special requirements beyond what capture already has for Oracle GoldenGate delivery. Because this Oracle GoldenGate release is a fully-remote distribution, the former Oracle GoldenGate Db2 for i remote product is no longer shipped separately. However, Windows is not supported in Oracle GoldenGate for Db2 for i in this release. If you still require delivery to Db2 for i from Windows, then Oracle GoldenGate Db2 for i remote 12.3 is still available.

Supported ODBC Driver

Starting from Oracle GoldenGate release 21.12, Oracle GoldenGate for Db2 for i supports the IBM i Access ODBC Driver 64-bit version 1.1.0.27 or higher.

See Linux, macOS, and PASE Application Packages for more information on IBM i Access ODBC Driver and follow the steps provided to install IBM i Access application package for the Linux operating system.

In addition, install unixODBC driver manager to be used with the Db2 ODBC driver on all supported Linux operating systems. For example, to install the unixODBC driver manager on the Red-Hat Linux operating system, use the yum command. See Installing the unixODBC driver manager for more information.

After the IBM i Access ODBC Driver and the unixODBC driver manager are installed successfully, add appropriate values in the odbcinst.ini and odbc.ini files to register the driver and the system.

You can test if the DSN and drivers are configured properly by testing the connection using the isql command. For example:

isql -v DSN user password