Re: Power problem leaves transaction lock hanging

Mike Lemon <mdl@interpath.com> wrote: Mike, Shutdown OnLine when it comes back up fast recovery will get rid of the lock for you. > >Well it had to happen. Due to some construction in the office, a user's PC running >a 4GL program on my AIX server lost power and the program was terminated. >Unfortunately, this didn't close the transaction she was in properly, and the >document she was modifying is still locked. I checked the engine (Online 5.02), and >there are no parentless sqlturbo processes to terminate with tbmode. > >The books seem to have little to say about such a problem, except for how to track a >transaction through the system. Is there any information out there on how to remove >the lock on the data? > >-- > >Mike Lemon >mdl@interpath.com > > _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ Gordon E. Hooker MACS PCP 25 Clarke Street Ripley Queensland Australia Phone 61-7-32940555 Email gordonh@acslink.net.au _/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/ It is far far better to remain silent and appear a fool then to open ones mouth and remove all doubt. Anon.