Add a Replicat for Db2 z/OS

Discover how to add a Replicat for a Db2 z/OS target in OCI GoldenGate.

Add a Checkpoint Table

Before you add a Replicat, add a Checkpoint Table to ensure the Replicat can restart without reapplying transactions should a disruption occur.

To add a Checkpoint Table:
  1. In the OCI GoldenGate deployment console Administration Service navigation menu, click DB Connections.
  2. Click the database connect icon for the target database.
    You can also expand the target connection in the navigation menu and then click Checkpoint.
  3. Click Add Checkpoint (plus icon).
  4. For Checkpoint Table, enter the target schema name, and then click Submit.

Add the Replicat

To add a Replicat for a Db2 z/OS target in Oracle GoldenGate 23ai:
  1. In the Administration Service navigation menu, click Replicats.
  2. On the Replicats page, click Add Replicat (plus icon).
  3. The Add Replicat form consists of four pages. Complete the form as needed:
    1. On the Replicat Information page:
      1. Select a Replicat type:
        • Classic Replicat
        • Coordinated Replicat
        • Parallel Replicat

        Note:

        Learn about different Replicat types.
      2. Click Next.
    2. On the Replicat Options page:
      1. Enter the Replicat trail details:
        • Name (can only be two characters)
        • Subdirectory
      2. Select the Target Credentials:
        • Domain
        • Alias
        • Checkpoint Table
        • (Optional) When to Begin
      3. Enter the Trail Position Sequence Number and RBA Offset.
      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, you can configure how the Replicat maps the source and target tables. For example:
      MAP table.*, TARGET table.*;
  4. Click Create and Run to start the Replicat. If you click Create, you can manually start the Replicat later on the Replicats page.
You return to the Replicats page, where you can select the Replicat to view its details.