Include the replicate SQLDML clause with the create replication definition or alter replication definition command to replicate SQL statements in a multisite availability (MSA) environment.
This code segment displays the syntax for create and alter database replication definitions:
[[not] replicate setname [in (table list)] ]
where:
setname = DDL | tables | functions | transactions | system procedures | SQLDML | ‘options’
replicate 'UDIS' in (tb1,tb2)
replicate SQLDML in (tb1,tb2)
create database replication definition dbrepdef with primary at ds1.pdb1 not replicate ‘S’ not replicate ‘U’ in (T) go
create database replication definition dbrepdef_UD with primary at ds2.pdb1 replicate 'UD' go
alter database replication definition dbrepdef with primary at ds1.pdb1 replicate 'UD' in (tb1,tb2) go
You can use multiple replicate clauses in a create database replication definition. However, for an alter database replication definition, you can use only one clause.
If you do not specify a filter in your replication definition, the default is the not replicate clause. Apply alter database replication definition to change the SQLDML filters. You can either specify one or multiple SQLDML filters in a replicate clause.
You can use multiple clauses to specify a table multiple times in the same definition. However, you can use each of U, D, I, and S only once per definition. For example:
create database replication definition dbrepdef with primary at ds2.pdb1 replicate tables in (tb1,tb2) replicate 'U' in (tb1) replicate 'I' in (tb1,tb2) go