cdr change replicate

>>-cdr change replicate--+-------------------------+------------>
                         |                    (1)  |
                         '-| Connect Option |------'
 
                        .-----------------------.
                        V                       |
>--+- --add--replicate----participant--modifier-+-+------------->
   |                       .-------------.        |
   |                       V             |        |
   '- --delete--replicate----participant-+--------'
 
>--+---------------+-------------------------------------------><
   +- --verify-----+
   '- --autocreate-'

Notes:

See page Connect Option.

Element	Purpose	Restrictions	Syntax
modifier	Specifies the rows and columns to replicate		Participant Modifier
participant	Specifies the database server and table for replication	The participant must exist.	Participant
replicate	Name of the replicate to change	The replicate must exist.	Long Identifiers

The following table describes the options to cdr change replicate.

Long Form	Short Form	Meaning
--add	-a	Add participants to a replicate.
--autocreate	-u	For use with master replicates only. Specifies that if the tables in the master replicate definition do not exist in the databases on the target servers, then they are created automatically. However, the table cannot contain columns with user-defined data types. The tables are created in the same dbspace as the database.
--delete	-d	Remove participants from a replicate.
--verify	-v	For use with master replicates only. Specifies that the cdr change template command verifies the database, tables, and column data types against the master replicate definition on all listed servers

Usage

Use this command to add or delete a participant from a replicate. You can define a replicate that has zero or one participants, but to be useful, a replicate must have at least two participants. You cannot start and stop replicates that have no participants.

Important:

Enterprise Replication adds the participant to the replicate in an inactive state, regardless of the state of the replicate. To activate the new participant, run with the name of the server group. See cdr start replicate.

Examples

The following example adds two participants to the replicate named repl_1: db1@server1:antonio.table with the modifier select * from table1, and db2@server2:carlo.table2 with the modifier select * from table2:

cdr change repl -a repl_1 \
   "db1@server1:antonio.table1" "select * from table1" \
   "db2@server2:carlo.table2" "select * from table2"

The following example removes the same two participants from replicate repl_1:

cdr change repl -d repl_1 \
   "db1@server1:antonio.table1" \
   "db2@server2:carlo.table2"