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
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.