Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 02 Jun 2008 @ 21:03:59 GMT


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


Subj:   Re: Exclusive locking with volatile
 
From:   Dieter Noeth

DAVID WILLIAMS wrote:

  We are running using the same userid and on mulitple concurrent sessions. The ETL creates and uses volatile tables with the same name in each session.  


  Will blocking occur by exclusive locks on the DDL of the Create Volatile Table and Drop Table statement?  


Just explain a "create volatile table" and you'll see no locks at all:

     1) First, we create the table header.

     2) Finally, we send out an END TRANSACTION step to all AMPs involved
        in processing the request.

The same for "drop table".


Dieter



     
  <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