Informix

nested-group-icon.png

DB2

Expand all | Collapse all

DBINTERVAL

  • 1.  DBINTERVAL

    Posted 17 days ago

    Dears,

                What will happens if set DBINTERVAL value to   -1 . As I know default is 30 seconds and if 0 , then no Replication. But no idea of -1 value.

    Thanks

    Amit Patel



    ------------------------------
    AMIT PATEL
    ------------------------------



  • 2.  RE: DBINTERVAL

    Posted 17 days ago

    You probably mean DRINTERVAL ?  But why "0, then no replication" ?

    DRINTERVAL configuration parameter has everything you need to know about this.



    ------------------------------
    Andreas Legner
    ------------------------------



  • 3.  RE: DBINTERVAL

    Posted 17 days ago

    See Andreas's response, but I wanted to be clear, DRINTERVAL is NOT used to stop replication. The effect of setting DRINTERVAL to 0 depends entirely on the setting of HDR_TXN_SCOPE. It sets the replication mode to ASYNC, NEAR_SYNC, or FULL_SYNC depending on what HDR_TXN_SCOPE is set to. Setting DRINTERVAL to -1 sets the replication mode to ASYNC or NEAR_SYNC depending on each database's logging mode, BUFFERED or UNBUFFERED respectively. Setting DRINTERVAL to a positive value puts all databases into ASYNC mode with the specified maximum flush delay making HDR behave much like RSS.



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------