Archives of the TeradataForum

Message Posted: Wed, 14 Mar 2001 @ 10:26:47 GMT

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

Is there a way via BTEQ (therefore using SQL and the data dictionary view) to see the status of a session?

In particular, to see wether it has an open transaction (active or idle) and to see the objects on which it is placing a lock.

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