Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2010 @ 14:38:30 GMT


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


Subj:   ETL jobs hanging
 
From:   Shindhe, Naveen

Hi,

We do have a below update query, we do not have any PI or USI in WHERE clause.

     UPDATE target_table SET col_b = :a WHERE col_c = :ix;

We do execute the above query from DataStage.

They are 30 countries which are started in intervals of 1 minute.

Most of the time ETL jobs use the above query at a time which results in hanging. Due to which each ETL job will take long time to complete.

Please let me know any resolution/suggestion for this.


Thank You,

Naveen



     
  <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