DYNAMIC_LOGS

onconfig.std value

None (this parameter is not in the onconfig.std file)

if not present

2 (Default)

range of values

0 = Turn off dynamic-log allocation.

1 = Set off the "log file required" alarm and pause to allow manual addition of a logical-log file. You can add a log file immediately after the current log file or to the end of the log file list.

2 = Turn on dynamic-log allocation. When the database server dynamically adds a log file, it sets off the "dynamically added log file" alarm.

takes effect

When the database server is shut down and restarted

utilities

Add a Logical-Log File

refer to

The following material:

• LTXEHWM
• LTXHWM
• Logical logs in the IBM Informix Administrator's Guide

If DYNAMIC_LOGS is 2, the database server automatically allocates a new log file when the next active log file contains an open transaction. Dynamic-log allocation prevents long transaction rollbacks from hanging the system.

If you want to choose the size and location of the new logical-log file, set DYNAMIC_LOGS to 1. Use the onparams -a command with the size (-s), location (-d dbspace), and -i options to add a log file after the current log file.

Even when DYNAMIC_LOGS is turned off, you do not have the same risks as in previous database server versions. In Version 9.3 and later, if the database server hangs from a long transaction rollback, you can shut down the database server, set DYNAMIC_LOGS to 1 or 2, and then restart the database server.