Duration indicates whether the parameter value lasts for only the current transaction (T) or whether it lasts until changed (C).
R/W indicates whether the value can be only be read (R/O) or can be read and written/updated (R/W).
SYS_R_MAXBYTES_OUT
The maximum size of a single synchronization message can be set by database level system parameters. The SYS_R_MAXBYTES_OUT parameter sets the maximum length of messages sent from a replica database to the master.
The value of this parameter can be set only in the replica database.
If the master database receives a message longer than the value of SYS_R_MAXBYTES_OUT, solidDB® issues the following error message:
25042 - Message is too long (<number> bytes) to forward. Maximum is set to <number> bytes.
Example:
SET SYNC PARAMETER SYS_R_MAXBYTES_OUT ’1048576000’;
Factory Value: 2 GB. Valid values are between 0 - 2 GB. If 0 is specified, 2GB is used.
Duration: C (until changed)
R/W: R/W
SYS_R_MAXBYTES_IN
The maximum size of a single synchronization message can be set by database level system parameters. The SYS_R_MAXBYTES_IN parameter sets the maximum length of messages that can be received by a replica database.
If the master database sends a message longer than value of SYS_R_MAXBYTES_IN, the server issues the following error message:
25043 - Reply message is too long (<number> bytes). Maximum is set to <number> bytes.
Example:
SET SYNC PARAMETER SYS_R_MAXBYTES_IN ’1048576000’;
Factory Value: 2GB. Valid values are between 0 - 2 GB. If 0 is specified, 2GB is used.
Duration: C (until changed)
R/W: R/W
SYS_SYNC_ID
This parameter is for internal use only. Do not set it.
Factory Value: N/A
Duration: N/A
R/W: R/O
SYS_SYNC_KEEPLOCALCHANGES
If the replica is read-only, setting this parameter to yes reduces processing load and storage requirements at Replica. The ALTER TABLE SET SYNCHISTORY statement is not required for replica tables in that case, and thus history table are not created at the replica. With this setting, all the local changes and row inserts (if made) are kept despite the refresh operation.
Factory Value: No
Factory Value: Valid until changed
R/W: R/W
SYS_SYNC_OPERATION_TYPE
When the replica gets a REFRESH request from the master, the parameters SYS_SYNC_OPERATION_TYPE and SYS_SYNC_RESULTSET_TYPE provide the replica with information about what operations the master originally performed on this data. The primary purpose of the parameters is to indicate whether an UPDATE operation occurred on the master and was converted into a DELETE+INSERT pair on the replica. For more information, see Handling UPDATE triggers.
The possible values of the SYS_SYNC_OPERATION_TYPE parameter in DELETE triggers are:
▪CURRENT_TENTATIVE_DELETE (set when deleting the current locally updated value of a row prior to executing the reply message in replica)
▪OLD_OFFICIAL_DELETE (set when deleting a row that was deleted in master)
▪OLD_OFFICIAL_UNIQUE_DELETE (set when the master sends a row to be added to the replica, but a similar row already exists on the replica. With this parameter value, the old official row is deleted before the new row is added to the replica)
▪OLD_OFFICIAL_UPDATE (set when executing a delete that was created as a result of an update in master)
The possible values of the SYS_SYNC_OPERATION_TYPE parameter in INSERT triggers are:
▪OLD_OFFICIAL_INSERT (set when restoring the old master value prior to executing the reply message in replica)
▪NEW_OFFICIAL_INSERT (set when inserting row that was inserted in master)
▪ NEW_OFFICIAL_UPDATE (set when executing an insert that was created as a result of an update in master)
If the trigger is fired by a local transaction (that is, not by synchronization logic), the value of this parameter is NULL.
Factory Value: None
Duration: T
R/W: R/W
SYS_SYNC_REPLICA_REFRESH_LOAD
This parameter defines the amount of system processing capacity (as percentage) that is used to perform a refresh in the replica. By default, full capacity is used (100).
If you want to reserve some capacity for local processing in parallel with refresh, set this parameter to a lower value.
Possible values are between 0 and 100. Value 0 means that the feature is disabled and full processor capacity is used.
Note To use this parameter, the corresponding solid.ini configuration parameter Synchronizer.ReplicaRefreshLoad must be set to 0 or 100.
Factory Value: 100
Duration: Valid until changed
R/W: R/W
SYS_SYNC_RESULTSET_TYPE
This parameter indicates whether the result set of a REFRESH operation is full or incremental.
Possible values of this parameter are:
▪FULL
▪INCREMENTAL
See also the discussion of SYS_SYNC_OPERATION_TYPE.
For more information about SYS_SYNC_RESULTSET_TYPE and SYS_SYNC_OPERATION_TYPE, see Handling UPDATE triggers.