Archives of the TeradataForum
Message Posted: Fri, 06 Mar 2003 @ 21:46:08 GMT
| 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
| 
