solidDB Help : solidDB reference : SQL: Statements : SET : SET SYNC : SET SYNC MODE
  
SET SYNC MODE
Note Applies to only solidDB Advanced Replication configurations.
SET SYNC MODE {MAINTENANCE | NORMAL}
Access requirements
SYS_ADMIN_ROLE or SYS_SYNC_ADMIN_ROLE role
Usage
Use the SET SYNC MODE statement to set the current catalog sync mode to either Maintenance mode or Normal mode.
The SET SYNC MODE statement applies only to catalogs that are involved in synchronization (that is, master catalogs or replica catalogs, or a catalog that is both a master and a replica catalog in a multi-tier hierarchy).
You can execute the statement only on the current catalog. If you want to change the catalog sync mode for more than one catalog, then you must switch to each catalog in turn (by using the SET CATALOG statement) and then execute the SET SYNC MODE statement for the current catalog.
For more information about Maintenance mode, see Considerations for using maintenance mode.
Return values
For details on each error code, see Error codes.
 
Error code
Description
13047
No privilege for operation.
13133
Not a valid license for this product.
25021
Database is not master or replica database. This operation only applies to master and replica databases.
25088
Catalog already in maintenance mode. You have set the mode on already.
25089
Not allowed to set maintenance mode off. Someone else has set the mode on so you can not set it off.
25090
Catalog is already in maintenance mode. Someone else has set the mode on so you can not set it on.
25091
Catalog is not in maintenance mode. You tried to set mode off and it is not currently on.
Example
SET SYNC MODE MAINTENANCE SET SYNC MODE NORMAL
Go up to
SET SYNC