Archives of the TeradataForum

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

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

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>>