Re: Killing of sqlturbo

In article <C66sLz.Mw@rnihd.rni.sub.org> klaus@rnihd.rni.sub.org (Klaus Brand) writes: >Hi Netlanders, > >i have a question about killing sqlturbo processes. > >What happens when I kill sqlturbo or sqlexec with a kill -9 ??? Bad career move. When you kill an sqlturbo with a -9 it stops the process in its tracks without giving it a chance to clean up resources it may hold. In some circumstances killing an sqlturbo with a -9 can bring your whole OnLine instance crashing down around you. This happens when, for example, you kill -9 an sqlturbo in a critical section. You can kill an sqlturbo with -15, -13, -3, or -2 without much bad happening, but -9 is right out. >I am asking this because we got programs from a company which kill >sql processes in the manner described above. You might want to investigate how these programs issue the kill -9. If they go through the shell, you could build a wrapper for kill that would look for an argument of sqlexec or sqlturbo and not allow it (or at least modify it to a -15). >In regards, >Klaus. >-- >Dipl.-Inform. Klaus Brand | >Telekom Entwicklungszentrum Darmstadt | UN*X ist das schwierigste >Standort Mannheim | Textadventure, das zur Zeit