Replicate data from Db2 for z/OS to Autonomous Data Warehouse
Learn to replicate data from a Db2 for z/OS sytem to Autonomous Data Warehouse using OCI GoldenGate.
Before you begin
To successfully complete this quickstart, you must have:
- An existing on premises Db2 for z/OS database, with a GoldenGate user created and properly secured
- An existing Autonomous Data Warehouse instance in your Oracle Cloud tenancy, with the GGADMIN user unlocked
- Network connection from your on premises system to your Oracle Cloud tenancy using either FastConnect or VPN
- The appropriate VCN security rules to allow connection from your private subnet to your on premises Db2 for z/OS through TCP/IP
Task 2: Set up the source deployment
Before you begin, ensure your source Db2 for z/OS deployment is in an Active
state.
Task 3: Set up the target deployment
- From the target Oracle Autonomous Database deployment details page, click Launch console.
- Add the source GoldenGate credential:
- Add and run a Target-Initiated Path:
- Verify that the Target-Initiated Path is created and running.
Task 4: Replicate data
- In the source Db2 for z/OS deployment, click Distribution Service and verify theDistribution Path is running.
- In the target Oracle Autonomous Database deployment, add and run a Replicat.
- After the Replicat is running, you can monitor performance.
- Manage Trail files