Re: Why this long transaction?

Dave Kosenko (davek@informix.com) wrote: : (Joe Lumbley) writes: : (Running into a long transaction, curious as to why) : |> Appropriate tbstat data follows: : The user and profile section (tbstat -up) would be helpful in trying to : figure this out. : (tbstat output deleted) Sorry, didn't save it. All that the user data showed was the daemons and one user process, the one that was rolling back the table from about 600K rows down to 0 rows. Profile was nothing extraordinary, in fact it should have zeroed out at the restart anyway. Thanks, Joe : 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 -- =========================================================================== 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! ===========================================================================