Archives of the TeradataForum

Message Posted: Fri, 31 Oct 2003 @ 11:17:59 GMT

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

<-- Anonymously Posted: Friday, October 31, 2003 06:14 -->

For the similar type of queries queries in the development environment you need to have a proportionate spool space for the users. Since spool space errors out from a single AMP which fails to provide the enough spool space you need to divide the spool space of 400 AMPs in production environment to the 80 AMPs of development environment.

Empirically, you may use ( 400 / 80 ) * (% of data in development environments w.r.t. the production environment).

Thanks...

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