Re: Why this Long Transaction

Stuart Litel writes: |> I strongly suggest if a "revovery" takes more than short period of time you |> could be encountering this famous bug. This depends a lot on your configuration. Fast recovery must rerun all the transactions that took place since the time of the last checkpoint, then roll back any of those transactions that were not committed before the system went down. If you have your system configured so that checkpoints are not happening very frequently, you must expect fast recovery to take some time. To get some idea of time between checkpoints, check your online log. Each checkpoint completed will ahve a message with a time stamp. The average time between checkpoints before the system went down can be derived from this. The longer the interval, the longer you should expect fast recovery to take. Dave Disclaimer: These opinions are not those of Informix Software, Inc. ************************************************************************** "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