Oninit cdi / Archive
Talk to an expert →

Re: Rollback

Posted in 2006

Topics: Performance & Tuning, Installation, Setup & Upgrades, Transactions, Locking & Isolation, Platform-Specific Issues, Cloud, Docker & Containers, Versions, Editions & End-of-Life

Roy Mercer — — source: Usenet: comp.databases.informix

When we upgraded to 9.40.FC5 we had the same problem. Check with tech support on Bug: 153283 ROLLBACK PERFORMANCE IS EXTREMELY SLOW Not sure when it is fixed. Colin Dawson wrote: > Solaris 9 > IDS 9.40.FC8 > > A developer ran an updare on a table with 152M rows as follows: > > begin work; > lock table in exclusive mode; > update <table> set <col> = 0 where <col> is null; > > The update would have updated 122M of the 152M. I have LTXHWM set to 45 to > prevent excessive transactions such as this, it hit this threshold and > aborted - long transaction as expected after about 90 minutes. However, the > rollback is taking an extremely long time, i.e. 3 hours to process > approximately less than half of the updated records. Is this what is > expected. > > > > > Regards > > Colin > > There are 10 types of people in the world, those that understand binary and > those that don't > > _________________________________________________________________ > Be the first to hear what's new at MSN - sign up to our free newsletters! > http://www.msn.co.uk/newsletters

↪ replying to Roy Mercer
david@smooth1.co.uk — — source: Usenet: comp.databases.informix

Roy Mercer wrote: > When we upgraded to 9.40.FC5 we had the same problem. > Check with tech support on Bug: > 153283 ROLLBACK PERFORMANCE IS EXTREMELY SLOW > > Not sure when it is fixed. > > Bug 169412 fixed in UC6:- FIX FOR PTS-B#153283 CAUSES A WARNING MESSAGE IN ONLINE.LOG THAT IRRITATES CUSTOMERS. !! So the fix for the fix in in UC6 and above. The latest is UC8.

Glossary