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

• Download the required library file from the Db2 for z/OS deployment details page and install the Extract components to your instance.
• Prepare your database for Oracle GoldenGate
• Created a Db2 for z/OS connection and associated the connection to the Db2 for z/OS deployment
• Ensure that you enable table-level supplemental logging by adding TRANDATA. If schema-level supplemental logging is already enabled, you can skip these steps.
  1. In the OCI GoldenGate deployment console, expand DB Connections, and select your source database.
  2. Next to TRANDATA Information, click Add TRANDATA (plus icon).
  3. For Schema Name, enter the database schema name, and then click Submit.

1. In the Administration Service navigation menu, click Extracts.
2. On the Extracts page, click Add Extract (plus icon).
3. The Add Extract form consists of four pages. Complete the Add Extract form as needed:
   1. On the Extract Information page:
      1. Select an Extract type:
         • Change Data Capture Extract
         • Initial Load Extract
      2. Enter a Process Name.
      3. (Optional) Enter a Description.
      4. Click Next.
   2. On the Extract Options page:
      1. Select when to Begin:
         • Now
         • Custom time
         • Position in Log
         • End of Log
      2. Enter the Extract Trail details:
         • Name (can only be two characters.)
         • Subdirectory
         • Trail Size
         • Trail Sequence
         • Trail offset
      3. Select the Source Credentials Domain and Alias from the dropdowns.
      4. Click Next.
   3. On the Managed Options page, complete the optional fields as needed:
      1. Select a Profile Name.
      2. Enable Critical to deployment health.
      3. Enable Auto Start.
      4. Enable Auto Restart.
      5. Click Next.
   4. On the Parameter file page, 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")

4. Click Create and Run to start the Extract. If you click Create, you can manually start the Extract later from the Extracts page.