Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: User Locks on tables
 
From:   Glen Blood

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020