Home
AdministeringIn addition to administering the database server, you can tune performance, replicate data, and archive data.
System administrationThese topics contain concepts, procedures, and reference information for database and database server administrators to use for managing and tuning HCL Informix® database servers.
Administrator's GuideThe Informix® Administrator's Guide provides the information required to administer HCL Informix®.
High availability and scalabilityA successful production environment requires database systems that are always available, with minimal if any planned outages, and that can be scaled quickly and easily as business requirements change.
High-availability cluster configuration
Remote standalone secondary servers
Delayed application of log recordsTo aid in disaster recovery scenarios, you can configure RS secondary servers to wait for a specified period of time before applying logs received from the primary server.
Stop the application of log recordsYou can halt the application of log records on an RS secondary server to prepare for disaster recovery scenarios.

Stop the application of log records

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

You stop the application of log files on the RS secondary server by setting the STOP_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 STOP_APPLY you must also set LOG_STAGING_DIR. If STOP_APPLY is configured and LOG_STAGING_DIR is not set to a valid and secure directory, then the server cannot be initialized.

See Informix® Administrator's Reference for more information.

To stop the application of log files on the RS secondary server immediately, run the following command:

onmode –wf STOP_APPLY=1

To stop the application of log files at 11:00 p.m. on April 15th, 2009:

onmode –wf STOP_APPLY=2009:04:15-23:00:00

To resume the normal application of log files

onmode –wf STOP_APPLY=0

Rate this topic

5 stars 4 stars 3 stars 2 stars 1 star

Comment on this topic.

By clicking this box, you acknowledge that you are NOT a U.S. Federal Government employee or agency, nor are you submitting information with respect to or on behalf of one. HCL provides software and services to U.S. Federal Government customers through its partners immixGroup, Inc. Contact this team at https://hcltechsw.com/resources/us-government-contact. Do not include any personal data in this Comment box.