Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 06 Sep 2005 @ 13:58:00 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Flushing Residual Spool From Amps
From:   Victor Sokovin

  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?  

I think your DBAs might be right. If the residual spool has been hanging around for such a long time, something is probably wrong with it. We have had a few threads on spool management (if interested, you should be able to find them in the archives), and a few problems have been reported in this area.

Did you try to run a "wild" query which would potentially consume *all* available spool space? It might help get rid of the old spool file but I would not bet on it.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020