Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Out of spool spcae on disk
From:   Dennis Calkins


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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016