Archives of the TeradataForum

Message Posted: Mon, 18 Aug 2003 @ 17:31:38 GMT


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

Subj:		Re: Sessions holding locks after query completes?

From:		Dempsey, Mike

My guess would be that Cognos is maybe using transaction semantics. If they issue a BT; before the query then the lock will remain until the next ET; ...which may not be until the next request is submitted ... so if the session is Idle that would be never.

...Just a thought.

Mike Dempsey
Teradata Client Tools.