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. If you do not specify the participant type, Enterprise Replication defines the participant as update-anywhere, by default.
- SELECT statement and optional WHERE clause
Restriction: Do not create more than one participant definition
for each row and column to replicate. If the participant is the same, Enterprise Replication attempts
to insert or update duplicate values during replication. For example,
if one participant modifier includes WHERE x < 50 and another includes
WHERE x < 100, Enterprise Replication sends
the data for when x is between 50 and 100 twice.