Home | Previous Page | Next Page   Appendix A. Command-Line Utility Reference >

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 page 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.

Warning:
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.

Examples

The following example connects to the database server stan and suspends the replicate house:

cdr sus repl --connect=stan house

See Also

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]