Re: tbzero, logs, high water marks

} } > >> 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. } > > } > >Watch out for that tbzero. johnl wrote a pretty scathing rebuke of the use } > >of that program. It is truly a tool of last resort, its use may be worse } > >than having to restore from an archive. There is no way to guarantee the } > >state of your data after a tbzero (or something like that.) } > } > No, we don't use it because our logs fill up. We use it because sometimes } > after a system crash Informix won't recover. It either recovers for hours, } > or puts out a message in the Informix turbo log that it can't recover. } > } > We know that we may have to rebuild indexes after a tbzero. We've never } > seen any other ill effects. } > } We have never had a system crash that Informix could not deal with (at least } not in living memory.) We are running around 13 instances of OnLine on 7 } machines, 6 of them DEC System 5000/250's running Ultrix and 1 Alpha running } OSF/1. These systems have been in place for around 3 years. } } My question is: how often do you have to use tbzero? It seems to me that your We are running the same application, on the same platform as Jim (Pyramid MIS-ES) , and have not seen this type of problem on 4.1 informix Online. We used to see it a bit when we run Informix on a 486, and ran out of log space. Maybe we are lucky. Not to say we dont have other problems..... } platform is very unstable (at least compared to ours) if you keep losing time I dont agree. We love our Pyramids, and have very, very few problems with them. Like I said, maybe we just have good Pyramids, made on days when the employees were happy. Or maybe our pyramid service dudes did something different. } and having to restore from archives. Are there some system level parameters } that are causing these crashes? (memory, disk offsets, semaphores, whatever) } Is this behavior *normal* for other installations like yours? Does Informix } track this, did they tell you of any other similar situations? With such a heck, no. We often have to tell them. But then, they run on 147 bazillion platforms. } large database, are you running into any O/S limitations? We are I/O bound, } by a very large margin, and you must be even more so. Stay tuned for the new Pyramid Niles! We just did a benchmark, and were very impressed. -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona To get the full value of joy, you must have someone to divide it with. -- Mark Twain