Add a Replicat for Db2 z/OS
JavaScript must be enabled to correctly display this content
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:
- In the OCI GoldenGate deployment console Administration Service navigation menu, click DB
Connections.
- Click the database connect icon for the target database.
You can also expand the target connection in the navigation menu and then
click Checkpoint.
- Click Add Checkpoint (plus icon).
- 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:
- In the Administration Service navigation menu, click Replicats.
- On the Replicats page, click Add Replicat (plus icon).
- The Add Replicat form consists of four pages. Complete the form
as needed:
- On the Replicat Information page:
- Select a Replicat type:
- Classic Replicat
- Coordinated Replicat
- Parallel Replicat
- Click Next.
- On the Replicat Options page:
- Enter the Replicat trail details:
- Name (can only be two characters)
- Subdirectory
- Select the Target Credentials:
- Domain
- Alias
- Checkpoint Table
- (Optional) When to Begin
- Enter the Trail Position Sequence Number and RBA
Offset.
- Click Next.
- On the Managed Options page, complete the optional fields as needed:
- Select a Profile Name.
- Enable Critical to deployment health.
- Enable Auto Start.
- Enable Auto Restart.
- Click Next.
- On the Parameter File page, you can configure how the Replicat maps the source and target tables. For example:
MAP table.*, TARGET table.*;
- 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.