Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 06 Mar 2003 @ 21:46:08 GMT


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


Subj:   Ghost Spool on some AMPs
 
From:   Rohit Revo

I have noticed that while querying on DBC.DiskSpace I found that there was a value in the CurrentSpool column for 2/3 users who had not used the system since last two three days. But the Current Spool was present for these users on some of the AMPs.

The values for sum(Current Spool) i.e. Sum of CurrentSpool on some AMPs for these users was very small 112 MB, 17MB and 2 MB. We have a 2.8 Terabytes disk plus the same for RAID 1 purpose. Interestingly the Sum(PealSpool) showed as 0 for these users. We run the ClearPeakDisk Macro everyday in the morning.

Clearly this is some residual ghost spool. Has anyone of you faced this issue. What is the best way to flush out this spool? Can it happen more often. Best ways to deal with this?


Thanks

ROHIT



     
  <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