Warm Standby and SQL Statement Replication

Learn how to configure warm standby applications support for SQL statement replication.

By default, warm standby applications do not replicate the DML commands that support SQL statement replication. To use SQL replication, you can:

Create table replication definitions using replicate SQLDML and send standby clauses.
Set the WS_SQLDML_REPLICATION parameter to on. The default value is UDIS.

However, WS_SQLDML_REPLICATION has a lower precedence than the table replication definition for SQL replication. If your table replication definition contains a send standby clause for a table, the clause determines whether or not to replicate the DML statements, regardless of the WS_SQLDML_REPLICATION parameter setting.