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 1: Create the OCI GoldenGate resources

First, create the deployments and connections:
  1. Create the source Db2 for z/OS deployment.

    Tip:

    In the Create deployment panel, ensure you select Db2 for z/OS for type.
  2. Create the target Oracle Database deployment.

    Tip:

    In the Create deployment panel, ensure you select Oracle for type.
  3. While the service creates the deployments, create the source and target connections:
  4. Assign each connection to their respective deployment.

    Tip:

    • Assign the Db2 for z/OS connection to the Db2 for z/OS deployment.
    • Assign the Autonomous Database connection to the Oracle deployment.
  5. After the Db2 for z/OS deployment is in an Active state, click Download Library on the deployment details page. Install and configure the Extract components in the zip to your source Db2 for z/OS instance before you perform any Extracts on the instance.

Task 2: Set up the source deployment

Before you begin, ensure your source Db2 for z/OS deployment is in an Active state.
  1. On the source Db2 for z/OS deployment details page, click Launch console.
  2. Add and run an Extract.

    Note:

    Ensure that you:
    • Add transaction information (TRANDATA) to enable supplemental logging.
    • The Extract is running and capturing source changes before you move on to the next step.
  3. Add a credential that the target OCI GoldenGate deployment console can use to connect to the source deployment:
    1. In the navigation menu, click User Administration.
    2. Click Add New User (plus icon).
    3. Complete the fields as follows, and then click Submit:
      1. For Authenticated by, select Password from the dropdown.
      2. For Role, select Operator.
      3. For Username, enter ggsnet.
      4. Enter a password twice for verification.

Task 3: Set up the target deployment

  1. From the target Oracle Autonomous Database deployment details page, click Launch console.
  2. Add the source GoldenGate credential:
    1. In the navigation menu, click DB Connections.
    2. On the Credentials page, click Add DB Connection, and then complete the fields as follows, and then click Submit:
      1. For Credential Alias, enter an alias.
      2. For User ID, enter ggsnet.
      3. For Password, enter the password from Task 2 step 4.
  3. Add and run a Target-Initiated Path:
    1. Click Receiver Service
    2. On the Receiver Service page, click Add Target-Initiated Path (plus icon).
    3. Complete the Add Path fields with the following values:
      1. On the Path Information page, enter a Path Name.
      2. On the Source Options page:
        1. For Source Protocol, select wss.
        2. For Source Host, click Copy next to the Console URL value on the source Db2 for z/OS deployment details page, and then paste the value.

          Tip:

          Ensure that you remove the https:// and any trailing forward slashes (/) from the URL.
        3. For Port Number, enter 443.
        4. For Trail Name, enter the two-character name of the Extract created in Task 2.
        5. For Domain, enter the username of the credential created in Task 2 (ggsnet).
        6. For Alias, enter the source deployment alias from Task 2.
        7. Click Next.
      3. On the Target Options page, enter the two-character name for the Target Trail, and then click Next.
      4. On the Managed Options page, click Create Path and Run.
  4. Verify that the Target-Initiated Path is created and running.

Task 4: Replicate data

  1. In the source Db2 for z/OS deployment, click Distribution Service and verify theDistribution Path is running.
  2. In the target Oracle Autonomous Database deployment, add and run a Replicat.
  3. After the Replicat is running, you can monitor performance.
  4. Manage Trail files