In This Chapter

You must manage logical-log files even if none of your databases uses transaction logging. See Logical Log for background information on logical logs.

You must log in as either informix or root on UNIX to make any of the changes described in this chapter. You must be a member of the Informix-Admin group on Windows.

You perform these tasks when setting up your logical log:

• Before you initialize or restart the database server, use the LOGFILES parameter to specify the number of logical-log files to create.
• After the database server is online, estimate the size and number of logical-log files that your system will need.

  See Estimating the Size and Number of Log Files.

• If you do not want to use the default values, change the LOGSIZE and LOGBUFF configuration parameters.

  See Changing Logging Configuration Parameters.

• Add the estimated number of logical-log files.

  See Allocating Log Files.

You perform the following tasks routinely:

• Backing up a logical-log file
• Switching to the next logical-log file
• Freeing a logical-log file
• Monitoring logging activity and log-backup status

You perform these tasks occasionally, if necessary:

• Adding a logical-log file
• Dropping a logical-log file
• Changing the size of a logical-log file
• Moving a logical-log file
• Changing the logical-log configuration parameters
• Monitoring event alarms for logical logs
• Setting high-watermarks for transactions