Archives of the TeradataForum

Message Posted: Wed, 18 Apr 2012 @ 10:13:27 GMT

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

Hi,

I think you're on the right track.

When Teradata is running on a laptop:

- the hard disk is used for Perm space. Whether or not this disk is raid protected or not is basically irrelevant to Teradata.

- Spool files may or may not be held in RAM, that really depends on the size of the spool file and the amount of RAM that TD has available to it. This is the same consideration as if you have TD running on a 'normal' SMP or MPP system

- Temp space may again be held in memory or written to disk. Same considerations as for Spool files.

Memory

NO, you do not need to make manual allocation of memory for AMPs. Some memory is reserved for each vproc (AMP, PE etc) at startup. The amount is controlled automatically (I think by PDE, but that's largely irrelevant), you can't change it. At any point in time, other memory may be dedicated to an AMP, but once the AMP has finished with a piece of memory it will then be released back into the pool of available memory for use "as needed".

The "shared nothing" architecture applies to both SMP and MPP systems.

Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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