Choosing an Installation System for DB2 LUW

To install Oracle GoldenGate for DB2 LUW, you can use either of the following configurations:

  • Install Oracle GoldenGate on the DB2 LUW database server.

  • Install Oracle GoldenGate on another server, and configure Oracle GoldenGate to connect remotely to the database server through DB2 Connect. All of the Oracle GoldenGate functionality that is supported for DB2 LUW is supported in this configuration. To use this option, proceed to Choosing and Configuring a System for Remote Capture or Delivery.

To Use Remote Delivery to the DB2 LUW System Using DB2 Connect

  1. For the intermediary system, select any supported for the DB2 for LUW database to be the system that Oracle GoldenGate is installed on.
  2. Install and run DB2 for LUW on the selected remote system so that the Replicat process can use the supplied DB2 Connect driver.
  3. Catalog the DB2 target node in the DB2 for LUW database on the remote system by using the following DB2 command:
    catalog tcpip node db2_node_name remote DNS_nameserver DB2_port-number
  4. Add the target DB2 database to the DB2 for LUW catalog on the intermediary system by using the following DB2 command:
    catalog db database_name as database_alias at node db_node_name 

    Note:

    Refer to the IBM DB2 LUW documentation for more information about these commands.

  5. Install Oracle GoldenGate. For CA, see Installing Oracle GoldenGate for Non-Oracle Databases. For MA, see Installing Microservices Architecture for Oracle GoldenGate.
  6. Specify the DB2 target database name with the Replicat parameter.TARGETDB when you configure the Oracle GoldenGate processes.