Archives of the TeradataForum

Message Posted: Thu, 10 Mar 2005 @ 14:59:03 GMT

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

Teradata RDBMS SQL Reference - Statement and Transaction Processing 7 ? 7

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.

You can review all the active locks and determine which other user locks are blocking your transactions if you have the performance monitor MONITOR SESSION privilege and an application that uses the Performance Monitor/Application Programming Interface.

Christopher Platt
Teradata Systems Administration

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