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 Receiver Path:
- Verify that the Receiver Path is created and running.
Task 4: Replicate data
- In the source Db2 for z/OS deployment, click Distribution Service and verify the Distribution 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
Replicate data from Db2 for z/OS to Autonomous Data Warehouse
Copyright ©2024,
Oracle and/or its affiliates.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customer access to and use of Oracle support services will be pursuant to the terms and conditions specified in their Oracle order for the applicable services.