Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 30 Aug 2010 @ 14:42:01 GMT


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


Subj:   ETL jobs get aborted due to deadlock issue
 
From:   Shindhe, Naveen

Hi,

This is with regard to DataStage 8.1 with Teradata 13

We do have few ETL jobs which try to insert or update the same table at the same time.

Due to which we get the error "RDBMS code 2631: Transaction ABORTed due to deadlock."

Please let me know will this work LOCKING FOR WRITE

Please let me know what can be done to avoid the deadlock issue.


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