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.