Archives of the TeradataForum

Message Posted: Wed, 13 Nov 2002 @ 15:41:21 GMT

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

Dave,

I was under the impression that Locking Logger did not catch all locks, but simply those locks that cause some form of blocking.

From the Teradata RDBMS Utilities Vol. 2 L-Z. (V2R4.01)

When the Locking Logger option is enabled in the DBS Control Utility, the Teradata RDBMS maintains ongoing logs of transaction identifiers, session identifiers, lock object identifiers, and the lock levels associated with executing SQL statements that have been delayed because of database lock contention.

Glen

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