Re: Orphaned sql turbo processes.

In article <snickerCwLK6F.G06@netcom.com>, <snicker@netcom.com> writes: > While we're on the subject... > At my current job all the programmers were told to never, ever kill > a sqlturbo process, but to get the DBA to do it. I, of course, totally > ignore this policy when I need to bail out of a long querey. I use kill -15. > There seems to be some concern that if you are doing an update to the > Informix database and you do a kill -15 on the process, that sqlturbo > will not clean up any locks. I always assumed it was smart enough to clean > up after itself as long as you didn't do a kill -9. > Does anyone out there confer or am I off base? > We use Informix 4.11 on the Pyramid. I remember getting a notice from informix - actually in the Turbo (3.xx) days that warned that killing an active sqlturbo process could lead to corruption in the db. Specifically the tbmode -z option which (i happen to know) did a kill -15?? on the process. I'm also guilty of doing the same thing and it was ok but I was always nervous afterwards.