Archives of the TeradataForum

Message Posted: Thu, 03 Apr 2003 @ 17:26:27 GMT

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

Hi,

When you create a User you are allowed to specify the amount of SPOOL SPACE (disk space for intermediate results) a user is allowed to use cumlative to all the queries they have running at any given time.

If the user exceeds this allotment you get this error. To see how much you are allowed and whether you have ever gotten close to that allotment execute.

SELECT vproc,MaxSpool,PeakSpool
from DBC.DiskSpace
where DatabaseName = user
order by 3;

If PeakSpool is close to MaxSpool on ANY amp you have exceeded your allotment at some time in the past.

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