cdr start replicateset

>>-cdr start replicateset--+-------------------------+---------->
                           |                    (1)  |
                           '-| Connect Option |------'
 
             .------------------.
             V                  |
>--repl_set----+--------------+-+------------------------------->
               '-server_group-'
 
>--+-------------------------------------------------------------------+-><
   '- --syncdatasource=data_server--+--------------------------------+-'
                                    '- --extratargetrows=-+-delete-+-'
                                                          +-keep---+
                                                          '-merge--'

Notes:

See page Connect Option.

Element	Purpose	Restrictions	Syntax
data_server	The database server from which the data is copied to all other database servers listed	The database server must be defined in Enterprise Replication.
repl_set	Name of replicate set to start	The replicate set must exist.	Long Identifiers
server_group	Names of database server groups on which to start the replicate set	The database server groups must be defined for Enterprise Replication.

The following table describes the cdr start replicateset options.

Long Form	Short Form	Meaning
--extratargetrows=	-e	Specifies how to handle rows found on the target servers that are not present on the data source server from which the data is being copied (data_server): delete: (default) remove rows and dependent rows, based on referential integrity constraints, from the target servers keep: retain rows on the target servers merge: retain rows on the target servers and replicate them to the data source server This option applies to the initial data synchronization operation only; it does not affect the behavior of the replicate.
--syncdatasource=	-S	Specifies the name of the database server to use as the reference copy of the data. This server is started even if it is not listed as one of the servers to start.

Usage

The cdr start replicateset command causes the replicates defined in the specified replicate set to enter the active state (capture-send) on the specified database servers and the source database server specified by the --syncdatasource option.

If the server_group list is omitted, the replicate set repl_set enters the active state for all database servers participating in the replicate set.

Because Enterprise Replication does not process log records that were produced before the cdr start replicateset command took place, transactions that occur during this period might be partially replicated. To avoid problems, either issue the cdr start replicateset command on an idle system (no transactions are occurring) or use the BEGIN WORK WITHOUT REPLICATION statement until after you successfully start the replicates in the replicate set.

If not all the replicates in a non-exclusive replicate set are inactive, the cdr start replicateset command displays a warning and only starts the replicates that are currently inactive.

Examples

The following example connects to the default database server specified by the INFORMIXSERVER environment variable and starts the replicate set accounts_set on the server groups g_hill and g_lake:

cdr sta replset accounts_set g_hill g_lake