Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 09 Nov 2006 @ 12:54:01 GMT


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


Subj:   Orphaned/Frozen Spool
 
From:   Durrani, Haris

I seem to be having a weird situation. Queries that normally used to run fine now complain of an out of spool space error. Further investigation discovered that the spool space on 1 of the 30 vprocs has is 50% utilized irrelevant of whether I am running a query or not. It doesnt matter if I log off or on. The currentspool for vproc 1 in the dbc.diskspace for my user shows up as 50% utilized always. This is effectively cutting my total spool space in half and preventing running of queries. Any ideas or utilities that can be used to reclaim this frozen spool?


Haris



     
  <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