vaxzee

Informix Dynamic Server – Logical log files are almost full – backup is needed

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

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 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.

10:48:42  Logical log files are almost full – backup is needed.

10:48:42  Checkpoint Completed:  duration was 0 seconds.

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

This entry was posted on November 23, 2009 at 1:06 pm and is filed under Sysadmin. Tagged: hang, informix, log, logical, logicallog. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site. ( Catalog our articles)

Source: http://setaoffice.com