Archives of the TeradataForum

Message Posted: Wed, 06 Dec 2006 @ 17:03:33 GMT


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

Subj:		Re: Out of spool space

From:		Dieter Noeth

Anomy.Anom wrote:

I am running an SQL which keeps running out of spool space. I have reset the spool running the dbc macro, then when I query the dbc.diskspace I see the following. I?m not sure why I am running out of space at < ? the spool allowed to this user. All of the databases above this database have at least double the size for spool (at least 300 GB). Is there anything else I need to look at?

Is there a profile assigned to that user?

Check dbc.diskspace.MaxProfileSpool vs. MaxSpool

Dieter