Archives of the TeradataForum
Message Posted: Mon, 25 Feb 2002 @ 19:22:33 GMT
| 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
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.