Using the cdr start replicate Command

About this task

To add a new participant to an existing replicate

Procedure

  1. Declare server delta to Enterprise Replication.
    For example: 
    cdr def ser -c delta -I -S g_alpha g_delta

    At the end of this step, all servers in the replication environment include information in the syscdr database about delta, and delta has information about all other servers.

  2. Add delta as a participant to replicate zebra.
    For example: 
    cdr cha rep -a zebra "dbname@g_delta:owner.table1"

    This step updates the replication catalog. The servers alpha, beta, and gamma do not queue any qualifying replication data for delta because the replicate on delta, although defined, has not been started.

  3. Start replication for replicate zebra on delta. 
    cdr sta rep zebra g_delta -S g_alpha -e delete

    The -S g_alpha option specifies that the server alpha be used as the source for data synchronization.

    The -e delete option indicates that if there are rows on the target server, delta, that are not present on the synchronization data server (alpha) then those rows are deleted

    Do not run any transactions on delta that affect table table1 until you finish the synchronization process.