Re: How do I kill a hung process on Informix ODS
Assuming 5.0x...try kill -2. If this doesn't work, try
kill -13 followed by kill -14.
Assuming 7.x...try the onmode -z (as suggested below).
If this fails, try killing the associated O/S process
(if any) using the scheme above.
If all this fails, then the process is probably in a
"critical code section". At this point, it is far
safer to bounce the DB engine, than to try to kill the
thread.
Never - never - never use kill -9 on a 5.0x SQLTURBO
process (unless you LIKE restoring from tape).
-d
At 11:05 10/28/97 +1300, Peter Tashkoff wrote:
}kill -9 pid can also crash your entire engine.
}Much nicer is:
}onmode -z sessid.
}This usually works.
}If not, by all means use kill (If risking a crash is OK). Sometimes a
simple kill will do the job without having to get too emphatic about things.
}rgds
}
}
}Peter Tashkoff <tashkop@iname.com>
}Zespri International Limited Std Disclaimers Apply
}All rights reserved. No party may use this document to vilify another.
}
}Zespri New Zealand Kiwifruit, The World's Finest
}
}
}>>> Thomas Tatum <thomas@koz.com> 28/10/97 04:51:54 >>>
}>>>>> "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
}
}
}