Home |
Previous Page | Next Page Logging and Log Administration > Managing Logical-Log Files >
Monitor the following event alarms that dynamically added
log files trigger (see Table 38). When
each alarm is triggered, a message is written to the message log. For more
information, see the chapters on event alarms and configuration parameters
in the IBM Informix Administrator's Reference.
You can include the onparams command to add log files
in your alarm script for event class ID 27, log file required. Your script
can also execute the onstat -d command to check for
adequate space and execute the onparams a -i command
with the location that has enough space. You must use the -i option to add the new log right after the current log file.
Table 38. Event Alarms for Dynamically Added Log Files
| Class ID |
Severity |
Class Message |
Message |
| 26 |
3 |
Dynamically added log file log_number |
This message displays when the database server
dynamically adds a log file.
Dynamically added log file log_number to DBspace dbspace_number. |
| 27 |
4 |
Log file required |
This message displays
when DYNAMIC_LOGS is set to 1 and the database server is waiting for you to
add a log file.
ALERT: The oldest logical log log_number contains records from an open transaction transaction_address. Logical logging will remain blocked until
a log file is added. Add the log file with the onparams -a command, using the -i (insert) option, as in:
onparams -a -d dbspace -s size-i
Then complete the transaction as soon
as possible. |
| 28 |
4 |
No space for log file |
ALERT: Because the oldest logical log log_number contains records from an open transaction transaction_address, the server is attempting to dynamically add
a log file. But there is no space available. Please add a dbspace or chunk.
Then complete the transaction as soon as possible. |
Table 39 shows the actions that the
database server takes for each setting of the DYNAMIC_LOGS configuration parameter.
Table 39. DYNAMIC_LOGS Settings
DYNAMIC_
LOGS |
Meaning |
Event Alarm |
Wait to Add Log |
Dynamic Log Add |
| 2 (default) |
Allows automatic allocation of new log files to prevent
open transactions from hanging the system. |
Yes (26, 28) |
No |
Yes |
| 1 |
Allows manual addition of new log files. |
Yes (27) |
Yes |
No |
| 0 |
Does not allocate log files but issues the following message
about open transactions:
WARNING: The oldest logical-log file log_number contains records from an open transaction transaction_address, but the dynamic log feature
is turned off. |
No |
No |
No |
Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]