Re: Remains in recover mode.

In article <2n0g9k$da5@emory.mathcs.emory.edu>, toms@erl.aldis.com.au (Tom Shapiro) says: >Hi netters, >My sad tale. > >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). You aren't logging, but you are in a transaction. Any time you create a table, even temp, you start an implicit transaction. Everyone else's entries filled the log. A tblog would show that you only had a begin work and some chunk alloc logs, but that serves as an "anchor" to hold the log cycle they were in, and all following logs. >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. ....... No matter how much the users yap, *NEVER* kill -9 the sqlturbo, it's worse than having them wait. If you're entering orders and such online, run with logging on and back up your logs periodically during the day. Also, your mother says eat your vegetables (-;. On the brighter side, I've had good luck prodding sqlturbo with kill -13 and kill -15. It almost always forces the rollback to start (you can tell if it's started rolling back by looking at tbstat -u. If there's an R instead of X, it's rolling back -- just wait. It has to paw through all the log entries. >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. See above. >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? TBZERO is the only way I know of. A released, supported tbzero would be very nice. We've needed similar from time to time. There really isn't any other way after Informix won't come up. Jim Burks jburks@promus.com Database Administrator The Promus Companies