Delay application of log records on an RS secondary server

You can delay the application of log records on an RS secondary server to prepare for disaster recovery scenarios.

You enable the delayed application of log files by setting the DELAY_APPLY configuration parameter. You can manually edit the onconfig file and restart the server, or you can change the value dynamically using the onmode -wf command. When setting the value of DELAY_APPLY you must also set LOG_STAGING_DIR. If DELAY_APPLY is configured and LOG_STAGING_DIR is not set to a valid and secure directory, then the server cannot be initialized.

Set DELAY_APPLY using both a number and a modifier. Number can contain up to three digits and indicates the number of modifier units. Modifier is one of:
  • D (or d) for days
  • H (or h) for hours
  • M (or m) for minutes
  • S (or s) for seconds

See Informix® Administrator's Reference for more information.

To delay the application of log files on the RS secondary for four hours:
onmode –wf DELAY_APPLY=4H
To delay the application of log files for one day:
onmode -wf DELAY_APPLY=1D
To disable delayed application of log files:
onmode –wf DELAY_APPLY=0