Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 21 Dec 2006 @ 19:54:14 GMT


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


Subj:   Re: Mload and BTEQ update script contention
 
From:   Dieter Noeth

Mark Jahnke wrote:

  What will happen if an BTEQ script is updating a table, and then an Mload comes in to the same table and tries to update it?  


MLoad applies special locks to the table header, which prevents DDL. And it requests an access lock, which is upgraded to a write lock at the beginning of Application Phase.

So it's probably running until begin of the application phase and then it's blocked until BTEQ finishes.


  Alternatively, what will happen if the Mload is updating a table and a BTEQ script tries to update the table.  


BTEQ is blocked until MLOAD finishes, if MLOAD is already in the Application Phase.


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