Re: Why this Long Transaction?

Jim Burks (jburks@promus.com) wrote: : In article <jlumbleyCKH6Hy.19r@netcom.com> jlumbley@netcom.com (Joe Lumbley) writes: : >Folks, : > : >I've run across something I'm not sure about and thought maybe the : >accumulated nettelligence could figure it out. : > My stuff deleted : Good question. Rollbacks can cause a long transaction to occur, but according : to your parameters, it shouldn't happen until 14 logs are full. Yeah, that's what bothered me..... : 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...... : Did yours finally come out? Yep, within 5 minutes of my estimated time of 11.5 hours. : ----------------------------------------------------------------- : Jim Burks jburks@promus.com : The Promus Companies : Memphis, Tennessee, USA -- =========================================================================== 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! ===========================================================================