Advanced replication system parameters are divided into the following categories:
Read-only system parameters
Read-only system parameters are maintained by solidDB® and can be read only by using the following syntax:
GET_PARAM(parameter_name)
The lifecycle of parameters in this category is one transaction, that is, values of these parameters is always initialized at the beginning of the transaction.
Updatable transaction-level system parameters
Users can set and update transaction-level system parameters using the following function call inside the transaction:
PUT_PARAM(parameter_name, value)
Updatable system parameters are used by solidDB® advanced replication to configure synchronization-related operations.
The lifecycle of parameters in this category is one transaction, that is, values of these parameters is always initialized at the beginning of the transaction.
Database catalog level system parameters
Database catalog level system parameters are set by using the followingsyntax:
SET SYNC PARAMETER(parameter_namevalue)
Parameters in this category are database catalog level parameters that are valid until changed or removed. They are specified as bulletin board parameters.
Full syntax and examples of usage of GET_PARAM(), PUT_PARAM() and SET SYNC PARAMETER functions are described in solidDB® SQL Guide.