Re: Bring Online down in middle of transaction rollback?

Firstly it should not take the whole 8 hours to rollback, but it will not rollback quickly. Secondly in some versions, pre v7 I have seen this behaviour, but not since, there can be problems with logical recovery if the system runs out of locks while rolling back a transaction. Otherwise there should be no problem. I dont think there is a more gracefull way of recovering. Regards, Jason On Mon, 03 Nov 1997 21:55:51 -0800, Cosmo Lee <"* N O - S P A M * cosmo"@echonyc.com> wrote: >What is the effect of bringing Online down in the middle of a >transaction being rolled back? Is it meant to recover gracefully from >this kind of thing? If so, in reality, does it actually do so (recover >gracefully, that is)? > >I've got a client who pulled a bone-headed move of running two huge >deletes at the same time. After eight hours, the 800,000 row locks have >been exhausted, and all users are locked out of the database. So, we're >going to have to wait another eight hours, at least, for the >transactions to roll back. > >I'm wondering if there are any ways to speed this process. One thought >that came to mind was to bring Online down, add more locks, then bring >it back up. My concern is whether Online is meant to recover gracefully >from being shut down in a middle of a transaction rolling back. 800,000 >rows is a lot to modify, so I'm a bit queasy about interrupting that >kind of transaction. Anybody w/ experience like this? > >Is there some other way that I could speed this process to get users >access to the DB more quickly? > >As far as I can tell, there is not way to add more locks while Online is >running. Please tell me if I'm incorrect. > >TIA. > >-- >* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * >ADDRESS ALTERED TO FOIL SPAMMERS: Remove "*NO-SPAM*" to reply. > >Cosmo Lee Multi-User Computer Systems Brooklyn, NY > > "JUST SAY 'NO' TO SPAM" >* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * > > Jason Harris Informix DBA Westpac Banking Corporation NOTE: I add all these address at the bottom of people who spam me Now when their extractors extract my e-mail address they will also end up spamming each other. wtcjr@ix.netcom.com Shevsky@hotmail.com speech@speechrecognition.com SmartBiz@NevWest.com slender@juice4u.net sbliss@earthfriends.com ron@moneyaction.com removeme@gwh.net rocco@lostvegas.com market@DRAWBRIDGE.NET Foxyrusski@mail-response.com emaster@email-man.com waynesmail@earthlink.net