Re: Can't free logical logs

In my personal experience: For other time, never reboot the machine or the Online, first backup the logs! This is posibly in Online .03 and the next engines, i don't know in 5.01. Now only restore!! :-( In this version of the online, long transaction is very dangerous!, before of realize this, I set the continous backup of logical logs or set the database to no-transactions. Other idea?? Along time ago, with Online 4.xx, fix the problem by this: (Only= luck!) 1. First try restore the database, but, the Online say: logical logs full wish backup? 2. And think this the solution, say yes, and push other data-tape, and the Online backup some percent of the logs! 3. I repeat the first step and the second, until the logs are= empty!!! 4. I don't needed restore the Database. Eureka!! Lucky!! I don't try after of this time this experience, and know what this is not correct!! If you try, set to don't write mode the data-tape of the restore!!! Take care of this!!! =20 Thanks. Gustavo Note: Excuse the bad english!! :-) At 06:41 PM 5/19/98 +0100, you 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:=20 > > >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