Re: "tbmode -z" doesn't kill - or even wound!

Eric Warner (Eric@northop.demon.co.uk) wrote: : I've had some formal training where I was told "Don't ever use kill -9 : to kill an Informix process - use tbmode -z instead." "EVER!" And a pretty sound piece of advice it is, too, although it actually only applies to the sqlturbo, sqlexec, and tbinit/oninit processes (not killing, I mean; tbmode -z only works on sqlturbo's and DSA xid's). : I needed to kill off a telnet login today for the first time, so <open : book> tbstat -u to get the pid then tbmode -z pid to kill it. Not. Well, it doesn't always work as well or as fast as we'd like... : Hmmm, ps -ef then try to tbmode -z the parent process. Nope. But if your parent process (4GL program? ESQL program? I-SQL process?) was still around, then I'd say the first option should be to kill THAT. tbmode -z will not affect the front-end, and it IS safe to kill that. At which point, if things go well, your back-end should clean itself up and then go away (no telling how long that might take, though). : Hmmmmmm, called The Bearded One who tutted for a while and then finally : killed it with "kill". : So the question to you experienced folk out there is "Is tbmode -z just : one of those Good Things that nobody actually does in real life or was : I just unlucky?" Actually, I'd say you were just lucky that the kill didn't hose your OnLine instance. June ---- June Tong Informix Software ---- ---- Senior Consultant (415) 926-6140 ---- ---- International Support junet@informix.com ---- ---- Location-du-jour: Taipei, Taiwan ----