HELP ME PLEASE : Waiting for Next Logical Log File to be Freed

botocabrini · #1 (**permalink**) 03-06-02, 14:30

Wed Mar 6 12:02:07 2002

12:02:07 Event alarms enabled. ALARMPROG = '/opt/informix/etc/log_full.sh'
12:02:07 Booting Language <c> from module <>
12:02:07 Loading Module <CNULL>
12:02:07 Booting Language <builtin> from module <>
12:02:07 Loading Module <BUILTINNULL>
12:02:12 Informix Dynamic Server 2000 Version 9.20.UC1 Software Serial Number
AAC#J435394
12:02:14 Informix Dynamic Server 2000 Initialized -- Shared Memory Initialized.
12:02:14 Physical Recovery Started.
12:02:14 Physical Recovery Complete: 3 Pages Restored.
12:02:14 Logical Recovery Started.
12:02:18 Waiting for Next Logical Log File to be Freed

[color=blue]botocabrini@hotmail.com

rnealejr · #2 (**permalink**) 03-06-02, 15:49

Basically, you are hosed. You had a long transaction hose your system. Please check the following onconfig parameters: LTXHWM, LTXEHWM and LBU_PRESERVE. You will have to contact tech support to help you through this one. Good luck.

muratmy · #3 (**permalink**) 05-17-02, 05:23

Set your LTAPEDEV to /dev/null and give a try with oninit -s , before calling tech support...

Murat

dananio · #4 (**permalink**) 05-20-02, 12:44

command 'oninit -s' bring server to quiescent mode ,
you haven't to do that , You can set LTAPEDEV to /dev/null
and run command ontape -a it's backing up your logical log into /dev/null
or you instert your tape cartidge into your tape device mount it and set LTAPE point to it and run command ontape -a your bakcup is in your tape device