Home Page for the TeradataForum

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020