Archives of the TeradataForum
Message Posted: Fri, 05 Sep 2003 @ 10:45:19 GMT
| Subj: | | Re: Spool Space Problems |
| |
| From: | | Narayan Murthy K S |
Check view DBC.DiskspaceX rather than DBC.Diskspace to check what is the limit that is currently set for your user/database.
PeakSpool is just an indication of the maximum spool that was ever used before it was reset by the ClearPeakDisk Macro.
The CurrentSpool that was used by a transaction may not get released as soon as the job has stopped or completed. The collection
is done on a last use basis - may be the reason for the delay in the correct value to be reflected.
Narayan.
| 
