Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 20 Mar 2006 @ 20:41:41 GMT


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


Subj:   Rollback at Teradata
 
From:   Anomy.Anom

Experts,

I have a 2 million records load insert statement started by SQL Assistant that ran for 9 minutes and now is rollingback for 3 days with High priority. The target table has 100 million records. I'm using Ttools release 7.0. I did not collect recent statistics on my primary index and join columns. I did not delete any secondary indices before run it.

I know that rollbacks usually take a minimum of 1.5 to 2 times longer then the time it took for the job to run prior to rollback starting, and occasionally they can take much longer, like 200 to 300 times as long as the original job such as delete statement running in ANSI mode that do not have a commit statement immediately following the delete statement. But my situation is an Insert statement that ran 9 minutes and its rolling back for 3 days.

What can you say about rollback process at Teradata? Is there any ways to speed it up? Any best practicies?


Thanks in advance



     
  <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