Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 25 Jun 2009 @ 09:08:51 GMT


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


Subj:   Blocking processes in Teradata
 
From:   Chaim Sender

Hi all,

I have macros that load into a certain table via an ODBC connection - sometimes after the macro begins, an MLOAD job loading to the same table begins and this causes a blocking situation. The blocked MLOAD process is blocked already at the BEGIN MLOAD stage.

I've been told by our Teradata DBA and this situation is very detrimental to the overall performance of the entire Teradata database.

A closely related question - if two MLOADs are running and loading to the same table with TABLEWAIT so that one process waits for the other one (also causes blocking situation), does this decrease the overall Teradata performance?


Thanks!!

Chaim



     
  <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: 27 Dec 2016