Setting Up Bidirectional Replication Support for DDL in MSA

Learn to set up bidirectional replication support for MSA.

1. Create a bidirectional MSA replication environment.
2. Grant “set session authorization” privilege to the maintenance user on the destination database, as shown in the following example:

   grant set session authorization to maint_user

3. Alter the connection of the destination database to set dsi_replication_ddl configuration parameter to “on” to enable bidirectional DDL replication, as shown in the following example:

   alter connection to dataserver.database set dsi_replication_ddl on

4. Replicate DDL transactions.