Prerequisites for Installing Oracle GoldenGate for Db2 LUW

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

Choosing an Installation System for Db2 LUW

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

To connect Oracle GoldenGate remotely, choose from the following options to connect to Db2 LUW:
- Db2 Connect v10.5 or greater
- IBM Data Server Client v10.5 or greater
- IBM Data Server Runtime Client v10.5 or greater
If Oracle GoldenGate does not connect remotely to the Db2 LUW server, refer to point 3.
For remote capture/apply, catalog the remote database server to configure Oracle GoldenGate to connect remotely to the database server. See Choosing and Configuring a System for Remote Capture or Delivery.
Install Oracle GoldenGate, and provide the values for the following environment variables during installation:
- LD_LIBRARY_PATH should have the path to installed client/server lib64 directory.
- DB2INSTANCE should be set to the value of the local instance on the server where Oracle GoldenGate will be running.

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 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:

Install and run Db2 for LUW on the remote server that has DB2 Connect.
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
```
Catalog the Db2 target node in the Db2 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
```
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.
Download and install the Oracle GoldenGate build that is appropriate for the Db2 LUW database on the remote server.