Re: Safe to kill sqlturbo process?

informix@noboagye.noboa_corp.com.ec (Javier Puente) writes: > Timothy M. Hood wrote: > } > } Francis Small wrote: > } > > } > I'm using Informix Online 5 (HP-UX 9) and am under the impression that > } > doing a `kill -9' on an sqlturbo process is a major bozo no-no, and > } > can shut the database server down if the process holds a latch or is > } > "inside a write call". My question is: is it safe to do a simple > } > kill? This sends the SIGTERM signal to the process, which I believe > } > is an accepted method of allowing a process to terminate gracefully. > } > } 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. > } > } Tim > > Yes, that's the recomended way. But I doesn't work in all the cases. > > What to do in such situations?????? As another poster said: try sending SIGPIPE. Often that works after a while. Another possibility is to suspend it (send SIGSTOP, kill -STOP) and check with tbstat -u to see if it is in a critical section (3rd field under 'flags' different from 'X') and tbstat -s to see if it holds any latches. If both are false, you may be able to stop it with SIGKILL without the engine going down. Otherwise, you send SIGCONT, and another SIGSTOP, then check again. This is a last resort. You must be desperate to use it, and if you use it you are on your own. -- 'yvind Gjerstad Systems dept Tollpost-Globe AS N-6301 'ndalsnes/Norway E-mail: ogj@it.tollpost.no Phone: +47 7122 6663 Fax: +47 7122 6694