Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 13:46:49 GMT


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

Subj:		Re: Lock Statement causing Deadlocking

From:		Victor Sokovin

It is possible to exhaust Lock Manager resources. Any transaction that requests a lock when Lock Manager resources are exhausted aborts. In such cases, row hash locking for DDL statements can be disabled.

That's a good suggestion but wouldn't the error code be 2971 then, as per

www.teradataforum.com/teradata/20031009_230918.htm ?

Regards,

Victor


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

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2005 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023