Re: Why this Long Transaction?

Ken Miles (kenm@vcd.hp.com) wrote: : Joe Lumbley (jlumbley@netcom.com) wrote: : > Folks, Deleted my blah.blah, blah.... : I'm following up two days after the original post and hope you are not : still in "fast recovery" but these symptoms bear a very strong resemblance : to a deadlock I had with 5.0 about a year ago. My LTXHWM was 70% also : and it just never came out of a fast recovery because I ran out of log : space before the rollback completed. Did tbstat -l show that you were : making progress on your logfiles? Yep, the logfiles were moving right along. I have 1.2 gig of logs to be able to handle some monster transactions, so I wasn't really worrying about the long transaction.....I just wondered why OnLine ***THOUGHT*** I was in a long transaction when I was still 30% below my low water mark. BTW, the rollback finished within 3 minutes of the estimate I had made by extrapolating tbstat -t data. Still, it was an 11 1/2 hour fast recovery. Moral of the story.......don't ever let anybody shut down your database when you have long inserts or deletes going on. The rollback will be while your system is down and it will be a killer. : In my case I had to do a recover from the daily archive. I have since : set LTXHWM/LTXEHWM to 45/50% respectively and no one will ever convince : me to raise them. I consider the Informix defaults of 80/90 BTW to be : downright dangerous. Criminal, almost.... : My $.02 contribution to your survival guide with Informix! Ask someone else who's gotten burned by 80/90 what it's worth, and I'll bet you get answers a bit bigger than $.02 :-) : Ken Miles : Vancouver Division : Hewlett-Packard -- =========================================================================== jlumbley@netcom.com (Joe Lumbley) "If you believe that my statements Database Administrator represent my company, please send The Tigon Corporation money and I'll send you stock" Dallas, Texas Watch for my _INFORMIX DBA SURVIVAL GUIDE_ in Fall '94 from Prentice Hall! ===========================================================================