FW: Can't free logical logs

Thanks to everyone who replied. The only solution was to call Informix as several of you, including Randy below, suggested. They logged into my machine and ran a utility called tbzero which cleared up the problem. Thanks again. Diane Houston ---------- From: Randy L. Cross To: Diane Houston Subject: Re: Can't free logical logs Date: 19 May 1998 22:29 Hope you have support contract with Informix. This situation required them to log in to my system and do some kind of magic. Making online think it had a free log file or something. I know of nothing else you can do. Good luck. rc On 19 May 98 at 18:41, Diane Houston wrote: > I am running OnLine 5.01 UDS on HP-UX 9.04. > > I had a problem with all logical logs full due to long transaction. I > was unable to resolve problem by methods from manual and unable take > off-line so I rebooted the system. OnLine now stuck in Recovery mode > although log shows: > > > Tue May 19 17:43:17 1998 > > 17:43:17 INFORMIX-OnLine Initialized -- Shared Memory Initialized > 17:43:18 Physical Recovery Started > 17:43:18 Checkpoint Completed > 17:43:18 Physical Recovery Complete: 0 Pages Restored > 17:43:18 Logical Log Files are Full -- Backup is Needed > > 17:43:19 Logical Log Files are Full -- Backup is Needed > > 17:43:20 Logical Log Files are Full -- Backup is Needed > > 17:43:21 Logical Log Files are Full -- Backup is Needed> > OnLine seems to think user dianeh still logged in > > USER INFORMATION > > Locks Disk Disk User > PID User Held Reads Writes > Status > > 383 root 0 6 > 2 ------D > 0 root 0 0 0 > ------D > 0 dianeh 0 0 0 > --T---- > 595 root 0 0 0 > ------M > 571 root 0 0 0 > ------M > > I have tried tbmode -c since status of log was U-B-L. > > Any other suggestions before I restore. > > Thanks in Advance > > > > Regards > Diane Houston > MedAS > OASIS Application Support > Villiers House, Room 135 > Tel: 19575 > > >