Archives of the TeradataForum

Message Posted: Wed, 23 Jul 2003 @ 12:04:53 GMT

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

<-- Anonymously Posted: Wednesday, July 23, 2003 08:02 -->

You can use the Alert Control Module of Teradata Manager to write the locks to a log. It will give the session number of the blocked session, logon id of the blocking session, and how many minutes it has blocked. I do not believe that it captures deadlocks, though :-(

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