Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 20 Aug 2002 @ 21:41:34 GMT


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


Subj:   Deleting rows in a transient journal
 
From:   Bhupesh Singu

The size of the transient journal suddenly grew extremely large in the last week. I suspect it being generated by an abort request. The administration guides say that the obsolete rows are periodically deleted.

I was wondering, If it is possible to manually delete the rows in a transient journal (is it safe?). If so, how? and, can it be done using sql.

Also, Is there anyway to go back and find out, which user query or user caused this.


Thanks in advance.

-- Bhupesh



     
  <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