Re: Safe to kill sqlturbo process?

David Coburn wrote: } } Javier Puente wrote: } >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 } >} > ... } >} } >} 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?????? } } The safest thing is to down the engine via tbmode -cky, then restart } it. Failing that, you are generally OK if the engine isn't in a } critical section (inside a write, etc.). In that case you run the } nearly certain risk of finding out if your last level 0 is any good or } not. } } You can tell what state it is in via the tbstat -u and checking out } the flags (flags with an X in position 3 are writing, if memory } serves), but the original response of tbmode -z pid is still safest. } } David David , I would like to avoid leave all my users from the system. Generally this happens in production time. Javier Puente