Archives of the TeradataForum
Message Posted: Fri, 06 Mar 2003 @ 21:46:08 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|