Re: FW: Can't free logical logs

Excelent!!.=20 This utility where is? At 12:44 PM 5/20/98 +0100, you wrote: >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 >> >> >> > > Informix Costa Rica Soporte T=E9cnico Sistemas Integrales de Computaci=F3n