DBINTERVAL

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 ------------------------------ #Informix

You probably mean DRINTERVAL ? But why "0, then no replication" ? DRINTERVALconfiguration parameter has everything you need to know about this. ------------------------------ Andreas Legner ------------------------------

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 ------------------------------