Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 25 Feb 2002 @ 19:22:33 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Spool Space and Skewedness
From:   Geoffrey Rommel

  Hi, How does adding more spool space to one's account skew the data distribution on the system?  

It doesn't. The spool space assigned to each user is not physically allocated; it is simply a number in the data dictionary. When the user runs a query, the spool space total is divided by the number of AMPs; if the quotient is exceeded on any one AMP, the user is out of spool.

If a user's spool space is increased, queries that used to fail with "out of spool" messages may run, or they may fail after a longer time. This could cause more contention with other sessions for physical disk space. As long as the spool limits are reasonable, however, you won't see much of a change.

  What's the min and max limit?  

Min = 0
Max = spool space allocated to the owner of that user. For instance, if DBA1 creates user USER1 under owner BUNCHOFUSERS, USER1 cannot have a greater spool allocation than BUNCHOFUSERS does.

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023