cdr suspend replicate

The cdr suspend replicate command suspends delivery of replication data.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-cdr suspend replicate--+--------------------------+---------->
                          |                      (1) |   
                          '-| Connect Option   |-----'   

   .-----------.   
   V           |   
>----repl_name-+-----------------------------------------------><

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

Copyright© 2018 HCL Technologies Limited