Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 11 Apr 2014 @ 15:07:28 GMT


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


Subj:   Re: ABORT sessions in ABORTING PHASE for more than 2hrs
 
From:   Pluebell, Fred

Remember that space is managed on a per-AMP basis. It doesn't matter how much total space you have left; if even one AMP is out of space, you are out of space.

The "DBC running out of space" was most likely due to highly skewed Transient Journal usage (in turn due to the highly skewed DELETE running).

The sessions remaining in ABORTING status were probably rolling back failed SQL units of work, which then had to scan through the unusually large (and skewed) Transient Journal.



     
  <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