Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Aug 2006 @ 20:04:35 GMT


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


Subj:   AWTs used to Lock Tables
 
From:   Bharat.Verma

I would like to understand if an AMP allocates an AWT to lock a table if the table is already locked by another query. Let's say that 2 transactions need to acquire table level lock on the same table. The first transaction acquires the lock, and the queries from this transactions hold on to the lock for a while. When the second transaction comes along while the first one is still running, then does the AMP first check the lock table before allocating an AWT to lock the table, or does it allocate the AWT to lock the table anyway? In the latter case, the AWT will be wasted until the first transaction completes and releases the table level lock.


Cheers

Bharat Verma



     
  <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: 15 Jun 2023