Note Applies to only HotStandby (HSB) configurations.
SET SAFENESS {1SAFE | 2SAFE | DEFAULT}
Access requirements
Database user
Usage
Use the SET SAFENESS statement to specify whether the HotStandby (HSB) replication protocol is synchronous (2-safe) or asynchronous (1-safe). For more information, see Replication protocols in HotStandby.
The SET SAFENESS statement sets the safeness level for the current session.
Parameters, clauses, keywords, and variables
▪ 1SAFE: The transaction is first committed on the primary server and then transmitted to the secondary server.
▪ 2SAFE: The transaction is not committed before it has been acknowledged by the secondary server.
▪ DEFAULT: Value set with HotStandby.SafenessLevel, or if not set, the server default value.