DRINTERVAL configuration parameter

Use the DRINTERVAL configuration parameter to specify the maximum number of seconds between flushes of the data-replication buffer, whether to use HDR SYNC mode, or whether to use the synchronization mode that is specified by the HDR_TXN_SCOPE configuration parameter.

onconfig.std value
DRINTERVAL 0
values
-1 = Use HDR SYNC mode. Replication is synchronous if the primary server uses unbuffered logging.

0 = The value of the HDR_TXN_SCOPE configuration parameter determines the synchronization mode for HDR data replication.

positive integers = Use HDR ASYNC mode. The positive integer is the maximum number of seconds between flushes of the data-replication buffer.

takes effect
After you edit your onconfig file and restart the database server.
When you reset the value dynamically in your onconfig file by running the onmode -wf command.
When you reset the value in memory by running the onmode -wm command.

Usage

The DRINTERVAL configuration parameter controls replication latency, and is used to set the replication synchronization.

If used with unbuffered logging, HDR SYNC mode is the same as the nearly synchronous mode that is set through the HDR_TXN_SCOPE configuration parameter.

Table 1. Matrix of DRINTERVAL, HDR_TXN_SCOPE, and logging settings, and their resulting HDR replication modes.
DRINTERVAL HDR_TXN_SCOPE Logging Result
-1 n/a buffered Asynchronous replication
-1 n/a unbuffered Nearly synchronous replication
0 FULL_SYNC buffered Fully synchronous replication
0 FULL_SYNC unbuffered Fully synchronous replication
0 ASYNC buffered Asynchronous replication
0 ASYNC unbuffered Asynchronous replication
0 NEAR_SYNC buffered Nearly synchronous replication
0 NEAR_SYNC unbuffered Nearly synchronous replication
positive integer n/a buffered Asynchronous replication
positive integer n/a unbuffered Asynchronous replication

Copyright© 2018 HCL Technologies Limited