Re: tbzero, logs, high water marks

In article <2npjlo$qdh@infmx.informix.com>, davek@somerset.informix.com (David Kosenko) says: > > >Jim Burks writes: >|> 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. >|> >|> Any suggestions? > >What is your checkpoint interval (CKPTINTVL) and how frequently are your >checkpoints actually occuring? Recovery should only be from the time of >the last checkpoint to the time of the crash, though incomplete transactions >do need to be rolled back (if you have very lengthy transactions that do a >lot of work, that could be a cause of the long recovery). I would not >recommend a CKPTINTVL of more than 15 minutes if time to restart is at all >an issue. > Our checkpoint interval is now 10 minutes. We had gone up to 30 min, but a 50 minute recover scared us back. Our recovery seems to be based also on the amount of time the oldest transaction has been active (number of in-use log files). ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ ~ Jim Burks jburks@promus.com ~ ~ Database Administrator / Systems Engineer ~ ~ The Promus Companies, Inc. Memphis, TN USA ~ ~ http://stargate.promus.com/public/jbb.html ~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~