solidDB Help : solidDB reference : SQL: Statements : SET : SET SAFENESS
  
SET SAFENESS
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.
Example
SET SAFENESS 1SAFE;
Go up to
SET