Re: Why this Long Transaction

Joe Lumbley writes: |> : What kind of machine are you running on that the rollback takes that long? |> : Whenever we've seen a rollback that long, it never came out of recovery and |> : we had to call support to set aside recovery with a tbzero. |> |> Pyramid MIS 12/9 (Nine processor machine). Very fast machine, but it |> seems that the rollbacks for inserts (into logged tables) takes forever.... |> Tell me about tbzero...... Don't get all excited about it. Tbzero is a progrram advanced support put together to get those customers who have gotten stuck in fast recovery due to insufficient log space back up and running. It accomplishes this by locating teh last checkpoint entry in the logs and modifying one of the fields in the structure (the one that records the number of transactions active at the time of the checkpoint) to 0. After this is done, tbinitis run. When it reads that checkpoint entry from the log, it it told that no transactions were active at the time of the checkpoint, and fast recovery is then done. No recover is actually done, so any incomplete transactions recorded against the database will remain. Any transactions applied to records in the buffer cache but not flushed to disk are lost. Tbzero should only be considered when your system is frozen in fast recovery (I mean truly frozen, not just taking a long time). 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