Add and Extract for Db2 for z/OS

Learn to add an Extract for Db2 for z/OS databases.

Before you begin

Before adding and running an Extract to capture data from the source, ensure that you:

Add an Extract

To add an Extract:
  1. In the OCI GoldenGate deployment console, on the Administration Service Home page, click Add Extract.
  2. In the Add Extract panel, on the Extract Information page, complete the following fields as needed, and then click Next:
    • Select an Extract Type:
      • Integrated Extract
      • Initial Load Extract
    • Enable Downstream Capture (optional), if applicable
    • Enter a Process Name, no more than 8 characters long.
    • Enter a Description (optional) to help you distinguish this process from others.
  3. On the Extract Options page, complete the following fields as needed, and then click Next:
    • Select the Source Credentials:
      • Domain
      • Alias
    • Registration options:
      • Enter the Commit Sequence Number (CSN).
      • For Share, choose a method to share the LogMiner data directory:
        • Automatic: allows the system to choose the method for sharing.
        • None: doesn't share the dictionary.
        • Extract Name: shares the LogMiner dictionary for this Extract.
      • Enable Optimized to optimize Extract registration.
    • Extract Trail:
      • Enter a Name for the Extract process.
      • Enter a Subdirectory name to set a custom location for the generated Trail file.
      • Enter Trail Sequence to set the starting number for Trail files.
      • Enter a Trail Size to set the max size for the generated trail file.
      • Select an Encryption Profile. The Local Wallet profile is selected by default if an encryption profile wasn't created.
      • Select an Encryption Algorithm:
        • NONE
        • AES256
        • AES192
        • AES128
  4. The Downstream Capture page applies only if Downstream Capture is selected on the Extract Information page.
  5. On the Managed Options page, complete the following optional fields as needed, and then click Next:
    • Profile Name
    • Critical to deployment health
    • Auto Start
    • Auto Restart

    Note:

    Adding a profile and configuring Auto Start and Auto Restart options enables your deployment to restart automatically after a network disruption. See Configure managed processes to learn more.

  6. On the Parameter File page, you can edit the parameter file in the text area to list the table details to capture. For example:
    table source.table1;

    Note:

    GoldenGate uses Greenwich Mean Time (GMT) by default. Use SETENV to override the default setting for the Extract. This change applies only to the Extract process and not the deployment.
    setenv (TZ="US/Eastern")
setenv (TZ="GMT+5")
  7. Click Create and Run to create and start the Extract. If you click Create, then you can manually start the Extract later from the Administration Service Home page.
You're returned to the Administration Service Overview page, where you can view the status of the Extract process. Select Details from the Extract Action menu to view process information, checkpoint, statistics, paramters, and reports.