Re: killing sqlturbo

At 05:53 PM 9/12/97 EDT, you wrote: > > >Is there a way to kill a runaway sqlturbo process without bringing the >Informix engine down? Some of our programmers have had bad >experiences with this in the past. > >Thanks, > >Jason Williams > It's a bit involved. Do you have the OnLine Administrator's Guide? Look for tbmode -z as well as indepth explanation for how to deal with this. But before you use this, you'd have to make sure that: 1: The user is not in a critical section. 2: The user is not holding any latches. This is all i can remember offhand (manual is at work). This is for OnLine 5.x. Don't know what you'd do if you've got 7.x. The basic theory is that if the process was in the middle of a critical section (i.e. changing data) then if the process is killed abnormally it could leave your database in an inconsistent state (transaction incomplete) so OnLine aborts immediately. When the system is restarted, Fast Recovery will cause the affected transaction (as well as any that were open at the time of the abort) to rollback, thus leaving your database with it's integrity intact (and you with a few angry users!). That's all I remember. Hope it helps. Best regards, Nigel +-------------------------------------------------------------+ |Name : Edmund Nigel Gall Tel: (868) 636 3153 | |Title : Information Systems Specialist Fax: (868) 679 3770 | |Company: Process Plant Services Limited | |Address: Atlantic Avenue, Point Lisas Industrial Estate | | Point Lisas, Couva, Trinidad & Tobago, W.I. | +----- mailto:nigelg@ppsl.com ------ http://www.ppsl.com -----+