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 Receiver Path:
    1. Click Receiver Service.
    2. On the Receiver Service page, click Add Target-Initiated Path (plus icon).
    3. Complete the Add Path fields as follows:
      1. On the Path Information page, enter a Path Name, and then click Next.
      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 Advanced Options page, click Next.
      5. On the Filtering Options page, click Next.
      6. On the Managed Options page, click Create Path and Run.
  4. Verify that the Receiver Path is created and running.

Task 4: Replicate data

  1. In the source Db2 for z/OS deployment, click Distribution Service and verify the Distribution 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