4 Oracle GoldenGate Classic for DB2 for z/OS
- Deploying Oracle GoldenGate Classic Architecture for DB2 for z/OS Platforms
- Finding Oracle GoldenGate for Non-Oracle (DB2 for z/OS) within the Oracle Cloud Marketplace
- Launching Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS)
- Getting Started with Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) Compute Node
- Working with Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS)
- Connecting to Data Resources
Deploying Oracle GoldenGate Classic Architecture for DB2 for z/OS Platforms
Using Oracle GoldenGate Classic Architecture on Marketplace, you can deploy and manage your deployment from a single location.
Here are the prerequisites which are required to deploy Oracle GoldenGate Classic:
- Oracle Cloud Account
- Access to compute node resources within Oracle Cloud Tenant
Parent topic: Oracle GoldenGate Classic for DB2 for z/OS
Finding Oracle GoldenGate for Non-Oracle (DB2 for z/OS) within the Oracle Cloud Marketplace
- Log in to Oracle Cloud Marketplace.
- From the Oracle Cloud Marketplace home page, use the search box under Applications and search for the keyword GoldenGate.
- From the Search Results, select Oracle GoldenGate for Non-Oracle.
Parent topic: Oracle GoldenGate Classic for DB2 for z/OS
Launching Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS)
Parent topic: Oracle GoldenGate Classic for DB2 for z/OS
Getting Started with Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) Compute Node
After deploying Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS), log in to the compute node and access Oracle GoldenGate Software Command Interface (GGSCI). For this, you need to identify the public IP address of the compute node where Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) is running. The following steps help you to identify the public IP address:
- Log in to your Oracle Cloud Console.
- Navigate to Compute -> Instances.
- Select the hyperlink name of the compute node. The public IP address is listed under Primary VNIC Information.
- To access the compute node where Oracle GoldenGate is running, connect as the
opc
account using SSH. For more information on how to access a node using theopc
account refer to Connecting to an Instance.
ssh -i <private-key-filename> opc@<public-id-address>
Installing DB2 drivers
- IBM Data Server Driver for ODBC and CLI v10.5 or later
- IBM Data Server Runtime Client v10.5 or later
- IBM Data Server Client v10.5 or later
- DB2 Connect v10.5 or later
For more information on these drivers, refer to Oracle GoldenGate Installation Guide
Running GGSCI
GGCSI
from home -> db2zos
directory (/home/opc/db2zos
). From here, after setting the above DB2
Driver environment, you can execute GGSCI.
- To start GGSCI, excute the following
commands:
$ cd db2zos $ ./ggsci
- In GGSCI, create sub directories:
ggsci>create subsirs
- Start manager:
ggsci>start manager
Working with Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS)
After deploying Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) on Oracle Cloud Marketplace, you can access the latest release of Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS).
Before you can start using Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS), there are a few tasks that you must perform to ensure that your environment is complete and ready to replicate your data. Before you begin data replication, you must perform the following tasks:
Topics:
- Configuring Source and Target Database for Replication
- Establishing Connectivity
- Configuring Capture Support
- Configuring Apply Support
Parent topic: Oracle GoldenGate Classic for DB2 for z/OS
Configuring Source and Target Database for Replication
Before you can begin replicating data, you should prepare the source or target database to support Oracle GoldenGate. To prepare your database, follow the steps listed in Installing Oracle GoldenGate for DB2 z/OS Databases chapter of Installing Oracle GoldenGate Guide. The steps listed here helps you to enable the requirements to capture and/or apply data to DB z/OS.
Establishing Connectivity
The Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) on Oracle Cloud Marketplace compute node acts as a hub where you can manage your connections to source and/or target DB2 databases. To do this, establish a network connection between OCI compute node and your source and/or target DB2 databases. For this, you have to install the required IBM DB2 connection libraries on the OCI compute node.
After installing the necessary IBM DB2 connection libraries, to establish connectivity from an Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) compute node to source and/or target DB2 databases, use the following options:
- IPSec VPN
- FastConnect
For establishing an IPSec VPN with OCI, refer to IPSec VPN documentation. For establishing a FastConnect connection, refer to the FastConnect documentation.
Configuring Capture Support
Before installing Remote Extract, refer to Installing Extract Components section in Installing Oracle Goldengate Guide.
To build the remote extract, perform the following steps within Oracle GoldenGate for Non-Oracle:
Connecting to Data Resources
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 move data from on-premises to the cloud or from on-premises to on-premises, perform the tasks listed in the following sections:
- Configuring Oracle DB2 z/OS for Replication
- Configuring Oracle GoldenGate Classic for Non-Oracle (DB2 z/OS) Compute Node
Parent topic: Connecting to Data Resources
Configuring Oracle DB2 z/OS for Replication
To prepare your Oracle DB2 z/OS database for replication, perform the tasks that are outlined in Installing Oracle GoldenGate for DB2 z/OS Databases chapter of Installing Oracle GoldenGate Guide and Preparing the DB2 for z/OS Databases for Oracle GoldenGate chapter of Using Oracle Goldengate for Heterogenous Databases Guide.
Parent topic: Connecting to DB2 z/OS (On-Premises)
Configuring Oracle GoldenGate Classic for Non-Oracle (DB2 z/OS) Compute Node
To establish connection from Oracle GoldenGate Classic for Non-Oracle (DB2 for z/OS) compute node to your on-premise DB2 z/OS database, you must establish connectivity between OCI and on-premise database. To do this, you can use the following options:
- IPSec VPN
- FastConnect
For establishing an IPSec VPN with OCI, refer to IPSec VPN documentation. For establishing a FastConnect connection, refer to the FastConnect documentation.
Parent topic: Connecting to DB2 z/OS (On-Premises)