Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Shared nothing architecture for SMP and MPP
From:   Dave Wellman


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.


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.



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

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