5.8 Connecting to DB2 z/OS (On-Premises)

You can use Oracle GoldenGate Classic for Non-Oracle (DB2 z/OS) on Oracle Cloud Marketplace to remotely capture and apply data to DB2 z/OS Database on-premises or across Oracle Cloud platforms. This allows you to enable replication between cloud services in a scalable fashion and centrally manage the replication processes.

Use Cases for Replication

Use Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) to replicate data between data resources in the following use cases:

• Migrations
• Data Distribution
• Real-Time Data Warehousing
• Operational Reporting

Prerequisites

Ensure that the following are set up before you begin replication:

• Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS)
• Oracle DB2 Source or Target Database

To configure DB2 for replication, see: Configuring Oracle DB2 z/OS for Replication.

• Configuring Oracle DB2 z/OS for Replication
  

5.8.1 Configuring Oracle DB2 z/OS for Replication

There is no default ODBC driver installed in Marketplace, you need to install your ODBC driver. The Admin Server does not run upon the virtual machine creation. You need to start it up once ODBC driver is properly installed and configured. For more information, see Setting up for DB2 z/OS.

To prepare your Oracle DB2 z/OS database for replication, perform the tasks that are outlined in Requirements for Installing Oracle GoldenGate for DB2 z/OS in Installing Oracle GoldenGate Guide and Preparing Your Database and System for Oracle GoldenGate chapter of Using Oracle Goldengate for Heterogenous Databases Guide.