Participant definitions
You must define a participant for each server that is involved in the replicate definition by running the cdr define replicate command. Each participant in a replicate must specify a different database server.
Each participant definition includes the following information:
- Database server group name
- Database in which the table to be replicated resides
- Table name
- Table owner
- Participant type
For a primary-target replication system, you can specify the participant type as primary, receive-only, or send-only.For a primary-target replication system, you can specify the participant type as primary or receive-only. If you do not specify the participant type, Enterprise Replication defines the participant as update-anywhere, by default.
- SELECT statement and optional WHERE clause