Re: Talking Heads (head hunters) and killing turbos

Ignoring the Headhunter stuff deliberately :-) > Back to techie stuff. Fellow just walked in fearing for his life because > he 'kill'ed an sqlturbo and then got a 'no shared memory' when he tried again. > Of course he had crashed the engine - which was not a nice thing to do. > Will 6.0 solve this problem? Or is there a solution? Or is this a 'problem' > in the sense that it is a recognized danger which should be gaurded against. > I suppose we could chmod on kill so that only root/informix could run it, but > that doesn't sound very smart either. > > cheers > j. Jack, This is basically a problem with Unix not Informix. My understanding is that Kill -9 is an interrupt that is untrappable by the program. Basically the O/S sees the interrupt and zaps the program. Result engine dies without clearing up its mess result corrupted Online engine, data, indexes, shared memory and no way out except recovery from your last backup!!!! Everybody has this problem. This is not a good idea. Informix can sometimes help recover your engine which they do somewhat cautiously and remotely. The techniques used to do this are not on general release because they are dangerous to Online engine health and the best solution is not to get in the mess!! You have a number of solutions. 1) Go to a trusted/secure unix implementation and take the performance hit and hassle. 2) Train the people involved never to do a kill -9. Ha! Ha! Ha! 3) Protect the kill command as you suggest above!! If they let you! 4) Put everything in menus and forget the word unix :-) 5) Jump off a cliff. :-)) 6) Pray (Any deity, it doesn't really matter - They won't help) :-))) Cheers - Jim My opinions are my own. They may vary with time but they remain MINE! ---------------------------------------------------------------------- Name: Jim Gordon Internet: jgordon@ssf-sys.DHL.COM Company: DHL Systems Inc Phone: (415) 375-5222 (Work) Address: 700 Airport Blvd. #300 (415) 882-9728 (Home) Burlingame, CA 94010-1937 Fax: (415) 375-5019 ----------------------------------------------------------------------