cdr suspend replicate
The cdr suspend replicate command suspends delivery of replication data.
Syntax
Notes:
- 1 See Connect Option.
| Element | Purpose | Restrictions | Syntax |
|---|---|---|---|
| repl_name | Name of the replicate. | The replicate must be active. | Long Identifiers |
Usage
The cdr suspend replicate command causes the replicate repl_name to enter the suspend state (capture, no send) for all participants.
Attention: When a
replicate is suspended, Enterprise Replication holds the replication
data in the send queue until the replicate is resumed. If a large
amount of data is generated for the replicate while it is suspended,
the send queue space can fill, causing data to be lost. Enterprise
Replication does not synchronize transactions if a replicate is suspended.
For example, a transaction that updates tables X and Y will be split
if replication for table X is suspended.
If a replicate belongs to an exclusive replicate set, you cannot run cdr suspend replicate to suspend that individual replicate. You must use cdr suspend replicateset to suspend all replicates in the exclusive replicate set.
When you run the cdr suspend replicate command, an event alarm with a class ID of 55 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 stan and suspends the replicate house:
cdr sus repl --connect=stan house