alter database replication definition

Description

Changes an existing database replication definition.

Syntax

alter database replication definition db_repdef
	with primary at srv.db
	{ [ not ] replicate DDL | [ not ] replicate set }
	[ with dsi_suspended ]

set ::= { tables | functions | transactions | system procedures }
	[ in { [ owner1. ] name1 [, [ owner2. ] name2 [, ...] ]

Parameters

db_repdef: Name of the database replication definition.

server_name.db: Name of the primary server/database combination. For example: TOKYO.dbase.

[ not ] replicate DDL: Tells Replication Server whether or not to send DDL to subscribing databases. If “replicate DDL” is not included, or the clause includes “not,” DDL is not sent to the replicate database.

[ not ] replicate setn

Tells Replication Server whether or not to send a set of tables, functions, transactions, or system procedures to the replicate database.

If replicate tables, functions, or transactions clause is omitted (or “not” is included), Replication Server replicates all instances of the omitted set.

If system procedures is omitted (or “not” is included), Replication Server replicates no system procedures.

owner

An owner of a table or a user who executes a transaction. Replication Server does not process owner information for functions or system procedures.

You can replace owner with a space surrounded by single quotes or with an asterisk.

A space (‘ ‘) – indicates no owner.
An asterisk (*) – indicates all owners. Thus, for example, *.publisher means all tables named publisher, regardless of owner.

name

The name of a table, function, transaction, or system procedure.

You can replace name with a space surrounded by single quotes or with an asterisk.

A space (‘ ‘) – indicates no name. For example, maintuser.’ ‘ means all unnamed maintenance user transactions.
An asterisk (*) – indicates all names. Thus, for example, robert.* means all tables (or transactions) owned by robert.

with dsi_suspended: Tells the replicate Replication Server to suspend the replicate DSI. Can be used to signal need to resynchronize databases.

Examples

Example 1

Changes the database replication definition rep_1C to filter out table2. The replicate DSI will be suspended.

alter database replication definition rep_1C
    with primary at PDS.pdb
    not replicate tables in (table2)
    with dsi_suspended

Usage

When alter database replication definition is executed, Replication Server writes an rs_marker to the inbound queue. alter database replication definition does not take affect until the marker reaches the DIST, which gives the DIST time to incorporate the changes in the Database Subscription Resolution Engine (DSRE).
Altering a database replication definition may desynchronize the primary and replication databases. See the Administration Guide for instructions for resynchronizing databases.