Re: tbzero, logs, high water marks

In article <2nscv1$oi7@emory.mathcs.emory.edu>, naomi@anasazi.com (Naomi Walker) says: > >} 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..... > We have to get Informix to tbzero one of our two large databases about once a year on the average. Not very often, I'd say, but when we do, it has to be done. It always occurs after a "hard" crash, with a LOT of update activity going on, and a long time (for us) since the last checkpoint (e.g. 10-15 min). >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. Ditto. Our MIS-12 ES's are very stable now. Jim Burks jburks@promus.com Database Administrator The Promus Companies Memphis, TN USA