Archives of the TeradataForum

Message Posted: Wed, 14 Apr 2004 @ 07:21:12 GMT

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

<-- Anonymously Posted: Wednesday, April 14, 2004 00:47 -->

Michael McBride

I want to clarify your comment in your earlier posts

Access Locking will not prevent contention in this scenario if you are using MLOAD or any DML such as table renames that require an EXCLUSIVE LOCK. The reason being is the COGNOS query tool (Impromptu) does not release locks, even access locks unless you have specifically set the read parameter to "READ UNCOMMITTED".

You can still query the Table being Multiloaded using an Access Lock. We are using views with Access Locking. So do we still need to have the 'READ UNCOMMITTED' option in Impromptu. And if we are using Views with Access Locking to develop Cognos Cubes, can we say that we will not have any locking contentions. We rarely drop or rename anything.

Thanks

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