Add a Replicat for Db2 for i

Discover how to add a Replicat for a Db2 for i target in OCI GoldenGate.

Before you begin

Ensure that you add a Checkpoint table for the Replicat to restart without recapturing reapplying transactions should a disruption occur.

In the OCI GoldenGate deployment console navigation menu, expand DB Connections, and select your target database.
Select Add Checkpoint (plus icon).
For Checkpoint Table, enter the target schema name, and then select Submit.

To add a Replicat for an Db2 for i target in Oracle GoldenGate 26ai:

In the OCI GoldenGate deployment console navigation menu, select Replicats.
On the Replicats page, select Add Replicat (plus icon).
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
    Learn about different Replicat types.
  2. Select 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. Select 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. Select 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.*;
```
Select Create and Run to start the Replicat. If you select 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.