Replicate data from IBM Db2 for z/OS to Autonomous AI Lakehouse

Learn to replicate data from a IBM Db2 for z/OS system to Autonomous AI Lakehouse using OCI GoldenGate.

Before you begin

To successfully complete this quickstart, you must have:

• An existing on premises IBM Db2 for z/OS database, with a GoldenGate user created and properly secured

• An existing Autonomous AI Lakehouse 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 IBM Db2 for z/OS through TCP/IP

Task 1: Create the OCI GoldenGate resources

First, create the deployments and connections:

1. Create the sourceIBM Db2 for z/OSdeployment.

   Tip: In the Create deployment panel, ensure you select IBM Db2 for z/OS for type.

2. Create the target Oracle AI 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:

   • Create a IBM Db2 for z/OS connection.

   • Create an Autonomous AI Database connection for the target Autonomous AI Lakehouse.

4. Assign each connection to their respective deployment.

   Tip:

   • Assign the IBM Db2 for z/OS connection to the IBM Db2 for z/OS deployment.

   • Assign the Autonomous AI Database connection to the Oracle deployment.

5. After the IBM Db2 for z/OS deployment is in an Active state, select 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, select Launch console.

2. Add and run anExtract.

   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, select User Administration.

   2. Select Add New User (plus icon).

   3. Complete the fields as follows, and then select 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 deployment details page, select Launch console.

2. Add the source GoldenGate credential:

   1. In the navigation menu, select DB Connections.

   2. On the Credentials page, select Add DB Connection, and then complete the fields as follows, and then select 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 aTarget-Initiated Path:

   1. Select Receiver Service

   2. On the Receiver Service page, select 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, select Copy next to the Console URL value on the source IBM 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. Select Next.

      3. On the Target Options page, enter the two-character name for the Target Trail, and then select Next.

      4. On the Managed Options page, select Create Path and Run.

4. Verify that the Target-Initiated Path is created and running.

Task 4: Replicate data

1. In the source IBM Db2 for z/OS deployment, select Distribution Service and verify the Distribution Path is running.

2. In the target Oracle deployment, add and run a Replicat.

3. After the Replicat is running, you can monitor performance.

4. Manage Trail files