LOG_STAGING_DIR configuration parameter

Use the LOG_STAGING_DIR configuration parameter to specify the location of log files received from the primary server when configuring delayed application of log files on RS secondary servers.

onconfig.std value
Not set.
values (first parameter)
Any valid, secure directory.
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 LOG_STAGING_DIR configuration parameter specifies the directory where log files sent from the primary are stored in the following circumstances:
  • The DELAY_APPLY configuration parameter is set on an RS secondary server to delay the application of logs
  • The STOP_APPLY configuration parameter is set on an RS secondary server to stop the application of logs
  • An RS secondary server must temporarily buffer logs
  • The LOG_INDEX_BUILDS parameter is set on the HDR secondary server, and the HDR secondary server is processing checkpoints
Delaying the application of log files allows you to recover quickly from erroneous database modifications by restoring the data from the RS secondary server.

The directory specified by the LOG_STAGING_DIR configuration parameter must be secure. The directory must be owned by user informix, must belong to group informix, and must not have public read, write, or execute permission.

The directory should have enough space to hold all the logical logs that are staged. Choose a directory capable of storing at least twice the total logical logs on the primary server. To estimate the storage size, multiply the value of the LOGBUFF configuration parameter with the value of the LOGFILES configuration parameter, and then double that value.

To see information about the data being sent to the log-staging directory set for a RS secondary server, run the onstat -g rss verbose command on the RS secondary server.

If the write to the staging file fails, the RS secondary server raises event alarm 40007.


Copyright© 2019 HCL Technologies Limited