Archives of the TeradataForum

Message Posted: Tue, 11 Jul 2007 @ 01:51:01 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: How to find and kill a hanging thread?

From:		McCall, Glenn David

We have a process does some reports against TD but every so often it hangs when there is a TD maintenance/restart during the processing. TD seems just never returns when it goes off and the process just hangs.

Is there a way of detecting the hanging thread and kill it and let the process goes on (fail or retry)?

Perhaps I'm missing something, but wouldn't this be a question for the people who supplied the reporting process?

Either way, you probably need to supply more information. A generic question such as this can only get a generic response such as look at windows task manager (or ps on Unix) and kill the task associated with the reporting tool.

Having said that, I would not recommend killing processes as S.O.P. You should really look at:

a) Why Teradata is doing restarts and address that problem and/or

b) If the reporting tool must run when a restart is initiated (can't they be scheduled for different times) Fix the reporting process so that it can deal with the restarts.

I believe that when Teradata restarts your query will automatically resume - assuming your query wasn't the cause of the restart or the system was rebooted via admin command. If not, you will get an error code through ODBC/JDBC which your reporting process will need to deal with.

I hope this helps

Glenn Mc


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Attachments

Library

Quick Reference