Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 05 Dec 2003 @ 15:20:15 GMT


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


Subj:   Re: Finding and removing locks
 
From:   Ferry, Craig

Thanks for all the input on how to remove locks. I need to know if there is a way to look for locks via an SQL. I need to be able to set up an automated process that does this at night. Another option for me would be if there is a way I can find out if there are any idle sessions and then abort the session if it has been idle for over a certain amount of time. Again this would have to be automated, so an SQL would be ideal.

I have tried to abort idle sessions via the alert tool in teradata manager but it doesn't appear to work (I will have to open an incident with NCR on this one).

Thanks again for any suggestions.

Craig



     
  <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: 15 Jun 2023