Re: Safe to kill sqlturbo process?

Francis Small wrote: > > Timothy M. Hood (thood29@idt.net) wrote: > > : Use tbmode -z pid > > : where pid is the process id of the sqlturbo process. This is the nice > : way to kill the process without fear of engine death. > > I should have mentioned that it is the users that sometimes need to kill > the process. To use tbmode, you must be user root or informix. > > Francis > Try kill -15 or -16 (which is effective seems to depend on the version). The signal needs to be one which the server can catch. It will then rollback the current transaction. This may take a long time (rule of thumb - if it took a long time for the transaction to get this far it'll take a long time to get back out again). DO NOT BE TEMPTED TO ISSUE A MORE DRASTIC KILL - WAIT FOR ROLLBACK TO COMPLETE! Ian