Yesterday we had a problem with an Informix Dynamic Server that wasn’t going to Online Mode. The problem was that the Logical log was full and it hang the Informix Dynamic Server

root@hp-ux:/ # tail -f /usr/informix/onlinep.log

Sun Nov 22 10:48:32 2009

10:48:32  Event alarms enabled.  ALARMPROG = ‘/usr/informix/etc/log_full.sh’
10:48:33  Booting Language <c> from module <>
10:48:33  Loading Module <CNULL>
10:48:33  Booting Language <builtin> from module <>
10:48:33  Loading Module <BUILTINNULL>
10:48:38  Informix Dynamic Server 2000 Version 9.21.FC5     Software Serial Number
10:48:38  Informix Dynamic Server 2000 Initialized — Shared Memory Initialized.

10:48:38  Physical Recovery Started at Page(4:21673).
10:48:38  Physical Recovery Complete: 0 Pages Examined 0 Pages Restored.

10:48:38  Logical Recovery Started.
10:48:38  10 recovery worker threads will be started.
10:48:41  Logical Recovery Complete.
0 Committed, 0 Rolled Back, 0 Open, 0 Bad Locks

10:48:42  Logical log files are almost full – backup is needed.
10:48:42  Dataskip is now OFF for all dbspaces
10:48:42  Checkpoint Completed:  duration was 0 seconds.
10:48:42  Checkpoint loguniq 5951, logpos 0x18018

10:48:42  Dropping temporary TBLspace 100120, recovering 8 pages.

The problem was solved when someone ran ontape -c and it backed up the log to the tape.