Add Extract for Db2 for i

Extract is a process that runs against the source data source connection and extracts, or captures, data. Learn to add an Extract for Db2 for i databases in OCI GoldenGate.

Before you begin

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

• Prepare you database users and privileges for Oracle GoldenGate

• Create a connection to Db2 for i and associate the connection to the Db2 for i 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, select Add TRANDATA (plus icon).

  3. For Schema Name, enter the database schema name, and then select Submit.

Add an Extract

1. In the OCI GoldenGate deployment console navigation menu, select Extracts.

2. On the Extracts page, select 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. Select 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. Select Next.

   3. On the Managed Options page, complete the optional fields as needed, and then select 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.

   1. On the Parameter file page, can edit the parameter file in the textarea 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. Select Create and Run to start the Extract. If you select Create, you can manually start the Extract later from the Extracts page.

You return to the Extracts page, where you can select the Extract process to view its details.