Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 11 May 2004 @ 19:44:30 GMT


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


Subj:   Re: Help on time of aborting transaction
 
From:   Hassinger, Bill

If you know how mush perm space the table had before the transaction started, you can use dbc.tablesize to see how much current perm is being used vs the final perm. You can use periodic size change to see how fast the base table is growing for an estimate of remaining time.

Rule of thumb, it takes 3 times longer to rollback then transaction processing. This will increase based on the number of NUSI's on the base table.


Bill H


P.S. I had a table that took 3 days to rollback.



     
  <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