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

cdr modify replicate

The cdr modify replicate command modifies replicate attributes.

Syntax

Read syntax diagramSkip visual syntax diagram>>-cdr modify replicate--+-------------------------+------------>
                         |                    (1)  |
                         '-| Connect Option |------'
 
                  .--------------------------------.
                  V                                |
>--+-----------+----+----------------------------+-+------------>
   '- --name=n-'    |                      (2)   |
                    +-| Conflict Options |-------+
                    |                   (3)      |
                    +-| Scope Options |----------+
                    |                       (4)  |
                    +-| Frequency Options |------+
                    |                     (5)    |
                    '-| Special Options |--------'
 
              .-----------------.
              V                 |
>--replicate----+-------------+-+------------------------------><
                '-participant-'
 
Notes:
  1. See page Connect Option.
  2. See page Conflict Options.
  3. See page Scope Options.
  4. See page Frequency Options.
  5. See page Special Options.
Element Purpose Restrictions Syntax
participant Name of a participant in the replication The participant must be a member of the replicate. Participant
replicate Name of the replicate to modify The replicate name must exist. Long Identifiers

The following table describes the option to cdr modify replicate.

Long Form Short Form Meaning
--name=n -n n Removes the name verification attribute from a master replicate. For more information, see Creating Strict Master Replicates.

Usage

The cdr modify replicate command modifies the attributes of a replicate or of one or more participants in the replicate. You can also change the mode of a participant. If the command does not specify participants, the changes apply to all participants in the replicate.

For attribute information, see cdr define replicate.

To add or delete a participant, see cdr change replicate.

If you change the conflict-resolution rule with cdr modify replicate, you must also specify the scope with the---scope option, even if you are not changing the scope.

The attributes for cdr modify replicate are the same as the attributes for cdr define replicate, with the following exceptions:

Special Options

Read syntax diagramSkip visual syntax diagramSpecial Options:
 
   .---------------------------.
   V                           |
|----+-----------------------+-+--------------------------------|
     +- --ats--+-y-+---------+
     |         '-n-'         |
     +- --ris--+-y-+---------+
     |         '-n-'         |
     +- --firetrigger--+-y-+-+
     |                 '-n-' |
     '- --fullrow--+-y-+-----'
                   '-n-'
 

The following table describes the special options to cdr modify replicate. For more information on these options, see Special Options.

Long Form Short Form Meaning
--ats y | n -A y | n Activates (y) or deactivates (n) aborted-transaction spooling for replicate transactions that fail to be applied to the target database.
--firetrigger y | n -T y | n Causes the rows inserted by this replicate to fire (y) or not fire (n) triggers at the destination.
--fullrow y | n -f y | n Specifies to (y) replicate the full row and enable upserts or (n) replicate only changed columns and disable upserts.
--ris y | n -R y | n Activates (y) or deactivates (n) row-information spooling for replicate row data that fails conflict resolution or encounters replication-order problems.

Examples

The following example modifies the frequency attributes of replicate smile to replicate every five hours:

cdr modify repl --every=300 smile

The following example modifies the frequency attributes of replicate smile to replicate daily at 1:00 A.M.:

cdr modify repl -a 01:00 smile

The following example modifies the frequency attributes of replicate smile to replicate on the last day of every month at 5:00 A.M., to generate ATS files, and not to fire triggers:

cdr modify repl -a L.5:00 -A y -T n smile

The following example changes the mode of the first participant listed to receive-only and the mode of the second to primary:

cdr mod repl smile "R db1@server1:antonio.table1" \
                   "P db2@server2:carlo.table2"

See Also

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