Re: Can't free logical logs

In article <6juq47$ri7$1@news.xmission.com>, Sunil Thakkar <sunil0@hotmail.com> writes > >Sanjit, > >I dont think this will work. > >Once the system is in long transaction - recovery mode then it will >never complete the recovery as there are no free logs to log the >recovery, and till the system completes the recovery we cannot do >anything like this. > >The only alternative is to get the informix tech support to help us out. >I had faced it twice before and both the times they had helped me out in >about 30 minutes. >(this goes against all the theories about informix tech supprt not >providing any support). > >Thanks, >Sunil. > Yep! they compile a tool to add logical logs WITHOUT logging the addition!! I have a lot of respect for these boys and girls! They are one of the few people apart from Art Kagel (who has an unfair advantage with access to Informix developers) who beat me at Informix... > >From: Sanjit Chakraborty <sanjit@ccu-sn.in.dhl.com> >Date: Wed, 20 May 98 10:48:35 +0530 >To: informix-list@iiug.org >Subject: Can't free logical logs > >Hi Diane, > >Try the following steps - >1. Login as 'informix' and Set proper TBCONFIG. > >2. tbstat -u > take all 'PID' for all users other than root and informix users. > >3. tbmode -z PID > use this individually for all the PIDs. > >4. Login as 'root' and kill and PIDs with -15 option. > kill -15 PIDs > >5. Login as informix , set your TBCONFIG and increase the 'Logical > Log number' with some handful number from 'tbmonitor' for time > being. > >6. tbtape -a > take logical log backup. > >7. tbmode -ky > stop your informix > >8. tbinit > restart informix > >9. Change the logical log number to the previous status. > > >Bye, >Sanjit. >20/05/1998. > >************************ START OF FORWARDED MESSAGE >********************** > >>From : mail>diane.houston@bbc.co.uk >To : informix-list@iiug.org >Subject : Can't free logical logs >Date : 19/05/98 23:44 > > >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 > > > > > >______________________________________________________ >Get Your Private, Free Email at http://www.hotmail.com -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care