Re: How do I kill a hung process on Informix ODS
Posted in 1997
I think the only thing you missed is the warning that a kill -9 on a
process in a critical section can crash your engine. Dave Kosenko did a
very nice write up years back on safely killing an Online process - should
be in the archives. I think it was called 'The killing of sqlturbo' or
somesuch.
cheers
j.
}Return-Path: <ilist@rmy.emory.edu>
}From: Taras Kopach <taras@evror.kiev.ua>
}Subject: Re: How do I kill a hung process on Informix ODS
}Date: Mon, 27 Oct 1997 20:56:47 +0200
}Reply-To: Taras Kopach <taras@evror.kiev.ua>
}Organization: EuroResource corp.
}Sender: informix-list-owner@rmy.emory.edu
}To: informix-list@rmy.emory.edu
}X-Informix-List-Id: <news.44524>
}
}
}
}Thomas Tatum wrote:
}
}> >>>>> "Kyle" == Kyle Campbell <kyle@fix.net> writes:
}>
}> Kyle> I don't have my Informix ODS manuals here at home and
}> Kyle> I'd like to kill a hung process on a remote site. What UNIX
}> Kyle> application can I use from the command line would kill a
}> Kyle> process.
}>
}> Kyle> Thanks in advance,
}>
}> Kyle> Kyle
}>
}> kill -9 pid
}>
}> --
}>
}> Thomas Tatum
}> thomas@rtp.koz.com
}> 919-489-5662 x32
}> 919-602-6521
}
} Easy, easy guys. The " kill -9 pid " is too ugly for Informix's process
}in critical section.
}And for the first time we must to log on the remote site. The easiest way
}is to use the "telnet" utility. Issue something like this:
} telnet remote_server_name
} If you are trusted on the remote server you can spawn a remote shell :
} rsh remote_server_name
}After you log on the remote server define the pid of a hanging process and
}issue command
} onmode -z pid
}Don't use this command three times one after another ( gives the same
}effect as "kill -9" ).
}There are also some soft "kill" options like "kill -15 pid " (see man
}kill) which don't kill a process without warning.
}You can also shutdown the Informix ODS using the onmonitor utility as last
}chance.
}
} Good luck,
} Taras.
}
}
}