3 Installing Oracle GoldenGate for DB2 LUW Databases

Learn how to install Oracle GoldenGate for DB2 LUW databases.

Topics:

• Choosing an Installation System for DB2 LUW
  
• Choosing and Configuring a System for Remote Capture or Delivery
  

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 Installing for all Platforms.

• 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, see Installing for all Platforms.
6. Specify the DB2 target database name with the Replicat parameter TARGETDB when you configure the Oracle GoldenGate processes.

Choosing and Configuring a System for Remote Capture or Delivery

In a remote installation, you install Oracle GoldenGate on a server that is remote from the source or target database server. This server can be any Linux, UNIX, or Windows platform that Oracle GoldenGate supports for the DB2 for LUW database. The Oracle GoldenGate build must match the version of DB2 LUW that is running on the installation server.

In this configuration, the location of the database is transparent to Extract and Replicat. Extract can read the DB2 logs on a source DB2 LUW database server, and Replicat can apply data to a target DB2 LUW server.

To Configure Remote Capture or Delivery:

1. Install and run DB2 for LUW on the remote server that has DB2 Connect.
2. Catalog the remote server in the DB2 source or target database by using the following DB2 command.

   catalog tcpip node db2_node_name remote remote_DNS_name
   

3. Catalog the DB2 target node in the DB2 for LUW database on the remote server by using the following DB2 command:

   catalog tcpip node db2_node_name remote remote_DNS_name server remote_port_number

4. Add the DB2 source or target database to the DB2 catalog on the remote server 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. Download and install the Oracle GoldenGate build that is appropriate for the DB2 LUW database on the remote server.