Re: Unix kill -9 and Informix SE???

In <Cn8tIz.5D1@boi.hp.com> harry@boi.hp.com () writes: > On a HP 9000/800 system with 9.0 that I access, users are >knocked off after a period of time by a script that looks for idle >processes ( terminals ). From what I have found out, they use >"kill -9" against the set of processes attached to a particular >terminal. The terminals are running isql 4.1 against an Informix >SE database. > (1) How should the program kill sqlexec processes, isql sessions, > etc. that are lying around? The program should kill _all_ processes associated with the terminal. Preferably all leafs processes upwards. > (2) Is there a definitive set of steps in how this should be > done? If so, what are those steps? It should issue SIGTERM (kill -15) to the processes first to request orderly shutdown, wait a while, and if they're still alive, then only should a SIGKILL (kill -9) be issued. > (3) What are the possible side effects of using "kill -9" on a > sqlexec process ( especially with the isql session in an > update or insert state )? > It's possible that some buffers won't be flushed, along with processes hanging around -- as you describe further on. [..side effects described..] That's a new one! >Harry Lynch >harry@hpdmm43.boi.hp.com -- Jonathan Chen E-mail : jonc@pinnacle.co.nz Pinnacle Software Ltd Voice : +64.9.489.7020 Auckland, New Zealand Fax : +64.9.489.7040