Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2005 @ 10:22:00 GMT


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


Subj:   Flushing Residual Spool From Amps
 
From:   Young, Andrew

I am curious as to whether there is any way for a user (non-admin) to flush a stalled job from the system.

I have 3.8gig of residual spool, which sits on the amps (apparently migrating across random amps on a continual basis). This spool remains even after I have disconnected and reconnected, and made sure that I have dropped all volatile and global temporary tables. This spool has persisted since I first noticed it 2 weeks ago.

I asked our DBA's, but they implied that only a Teradata technician can flush away residual spool from the system. This seems unlikely. Is there a way for a standard user to flush all of their running jobs off the amps?


Andrew Young



     
  <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