cdr stop replicateset

The cdr stop replicateset command stops capture and transmittal transactions for all the replicates in a replicate set.

Syntax

Notes:

¹ See Connect Option.


Element	Purpose	Restrictions	Syntax
repl_set	Name of replicate set to stop.	The replicate set must exist	Long Identifiers
server_group	Name of database server group on which to stop the replicate group.	The database server groups must be defined for Enterprise Replication.

Usage

The cdr stop replicateset command causes all replicates in the replicate set repl_set to enter the inactive state (no capture, no send) on the database servers in the server_group list.

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

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

If you run this command while direct synchronization or consistency checking with repair is in progress, that repair process will stop. (Consistency checking continues; only the repair stops.) Direct synchronization and consistency checking repair cannot be resumed; you must rerun cdr sync replicate or cdr check replicate command.

When you run the cdr stop replicateset command, an event alarm with a class ID of 62 is generated, if that event alarm is enabled.

You can run this command from within an SQL statement by using the SQL administration API.

Examples

The following example connects to the database server paris and stops the replicate set accounts_set on server groups g_utah and g_iowa:

cdr sto replset --connect=paris accounts_set g_utah g_iowa