Re: kill -9 again

In article <2prtid$3e8@emory.mathcs.emory.edu>, Will Hartung - Master Rallyeist <villy@collinscomp.com> wrote: >On a side note regarding kill -9 (or more appropiately, tbmode -z), I >don't know if I've ever seen a clean way to convince an sqlturbo that it >is doing a Bad Thing. ... > >Has anyone else encountered Queries from Hell like this? Has anyone seem >a tbmode WORK against a query like this? I don't think I've ever seen >tbmode work against a query that wouldn't just as easily be stopped by >killing the front end job. On a version of Informix On-line that I used for a long time (4.1, for Sco Unix 32v2) tbmode would have absolutely no effect on any process. Kill -9 was generally the only way to stop runaway processes; shutting down the engine wouldn't work because the engine won't shut down if there is a process still running. So you would have to do a tbstat -u and see if there was an "S" (latch flag) or "X" (critical section) anywhere, and if not blast away with kill -9. I've found Ix to be a pain to administer. They should not have designed it to crash if a process dies unexpectedly.