Re: tbzero, logs, high water marks

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. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney