Managing database replication definitions

A table, a function, a transaction, DDL, or a system stored procedure can be a replicated object. A database replication definition specifies filters for replicated objects—either including or excluding the same or entire replicated object from replication. For example:

create database replication definition rep_1C
  with primary at PDS.pdb
    replicate tables in (table1, table2)
    not replicate functions in (fc_a)
    not replicate system procedures
    replicate transactions
    replicate DDL

In this example, we are replicating:

• table1 and table2

• All functions except fc_a

• All transactions

• Supported DDL commands

We are not replicating:

• Any database tables except table1 and table2

• Function fc_a

• Any system procedures

See “create database replication definition” in the Replication Server Reference Manual for complete syntax and usage information.