cdr suspend replicateset

The cdr suspend replicateset command suspends delivery of replication data for all the replicates in a replicate set.

Syntax


1  cdr suspend replicateset?  %Connect Option  (1) +  repl_set
Notes:
Element Purpose Restrictions Syntax
repl_set Name of replicate set to suspend. The replicate set must exist. Long Identifiers

Usage

The cdr suspend replicateset command causes all the replicates in the replicate set repl_set to enter the suspend state. Information is captured, but no data is sent for any replicate in the set. The data is queued to be sent when the set is resumed.

Attention: When a replicate set is suspended, Enterprise Replication holds the replication data in the send queue until the set is resumed. If a large amount of data is generated for the replicates in the set while it is suspended, the send queue space can fill, causing data to be lost. Enterprise Replication does not synchronize transactions if a replicate in a replicate set is suspended. For example, a transaction that updates tables X and Y will be split if replication for table X is suspended.

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

When you run the cdr suspend replicateset command, an event alarm with a class ID of 56 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 default database server specified by $ONEDB_SERVER and suspends the replicate set accounts_set: 
cdr sus replset account_set