Re: Remains in recover mode.

Tom Shapiro (toms@erl.aldis.com.au) wrote: : Hi netters, : My sad tale. : Running V 4.10 on Sequent S200, about 50 terminals. : Entered a select in isql to return a few rows into temp file with no : log. Unfortunately, due to bad input it returned 1000's, and soon : ran out of log space. (why? I did say with no log). : With terminals dying all around I killed the isql. : The turbosql remained, valiantly rolling back the log I expect. : As all the terminals were still jammed (I cannot tell a lie) I : killed the turbosql, and informix died. ....... : Next, of course, I tried to start informix, using the tbmonitor. : It entered recovery mode, politely displayed "please wait" and started : drawing dots at the bottom of the screen. : A sad previous experience led me to believe that things would stay : that way for 24+ hours, so after 2 hours, with the user threatening : my life, I restored from the previous days archive - thereby losing : half a day's work. : While admitting guilt (to forgive is devine but not co policy) : - what should I have done. : I did not want the temp table anyway. : Is there a way to start informix and skip recover? : I have seen tbzero referred to in previous em's, is this the only : answer? : Thanx in advance for any help (perhaps I should start reading those : @#$%^&* job ads that keep cluttering the net). : ______/ ______/ _ | ______/ : / / / | / toms@erl.aldis.com.au : / ____/ / | / : / / / /___ | / Tel (613) 647 9720 : ________/ _______/ __/ __| ________/ Fax (613) 647 9799 Inteligencia can solve this problem by running the backup on the OnLine instance after it crashed! This would allow you to restore the databases to the state they were in without losing work. ******************************************************************************** __ _ _ __ () , _ / ) // ' ) ) /`-'| // / _/_ / / __. // _ /--' / / o // /___/> __ / /__/_(_/|_</_</_ / \\ o /__-<_<_</_/_) (__/ (_<__ Dale R. Gilbert DGC/4GL email: dgc@netcom.com 1256 Cabrillo Ave., Suite 250 FAX: (310) 320-3579 Torrance, CA 90501 VOICE: (310) 320-4300 ******************************************************************************** Inteligencia: The ONLY Row Level Backup/Restore Solution for Informix OnLine(r) ******************************************************************************** -- ******************************************************************************** __ _ _ __ () , _ / ) // ' ) ) /`-'| // / _/_ / / __. // _ /--' / / o // /___/> __ / /__/_(_/|_</_</_ / \\ o /__-<_<_</_/_) (__/ (_<__ Dale R. Gilbert DGC/4GL email: dgc@netcom.com 1256 Cabrillo Ave., Suite 250 FAX: (310) 320-3579 Torrance, CA 90501 VOICE: (310) 320-4300 ******************************************************************************** Inteligencia: The ONLY Row Level Backup/Restore Solution for Informix OnLine(r) ********************************************************************************