Archives of the TeradataForum

Message Posted: Mon, 18 Aug 2003 @ 21:15:48 GMT

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

Well, I tried a simulation with a blocked session using a Cognos user (X) in an Impromptu query session, and ETL user (Z) requesting an EXCL lock this is the results....

When X runs impromptu report, access lock is granted
When Z asks for exclusive lock, access blocked....

When X report is completed, residual blocking access lock remains
When X runs another report, residual blocking access lock remains
When X opens another catalog, residual blocking access lock remains
When X closes ALL catalogs, residual blocking access lock remains

When X terminates impromptu application (in Windows), access lock is released, Z is granted EXCL lock.

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