All Forums Teradata Applications
gbansal 18 posts Joined 02/11
11 Sep 2014
Questions on Inside AMP

Hello Guys ,
 
I have some basic questions .
 if you guys can help that will be really helpful.
 

  1. Memory which used by AMP
    1. Vdisks
    2. Ram
    3. Spool Space
    4. FSG Cache
  2. Is  FSG Cache memory is same as Spool space where data is moved when Joins takes Place
  3. Each AMP has its own RAM , So Ram is not FSG Cache memory . It’s memory is fixed in AMP or it is also decided by PDE as same is done for FSG
  4. Initially, Data is distributed across AMPs so where we store this data on . is its Vdisk or Pdisks . Vdisk is combination of Pdsiks ?
  5. If Possible can please someone provide image for what inside a AMP ?
Tags:
Raja_KT 1246 posts Joined 07/09
12 Sep 2014

Too many questions :)
You can have a look at this link :
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111A/appc.038.79.html
There are some more links too about TVS and you can get more info and then  more also about Intelligent memory.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

gbansal 18 posts Joined 02/11
14 Sep 2014

Hi Raja,
Actually i have read this article .  I got confused when i was reading article on Joins Working.
During Joins , the data is moved from vdisk to either in Spool Space or FSG cache ?
In Hash Joins , Joins takes place inside RAM .
So I am not sure FSG Cache is what ?
 

Raja_KT 1246 posts Joined 07/09
15 Sep 2014

FSG cache stores the most recently used database segments. When Teradata Database needs to read a data block, it checks and reads from cache instead of from disk, whenever possible.FSG purges least recently used data.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

gbansal 18 posts Joined 02/11
15 Sep 2014

Hi raja,
 
Same thing happens in spool space as well ?
So my doubt is FSG Cache is unused Spool Space or Unused RAM memory ?

agnitc 9 posts Joined 11/14
28 Dec 2014

Hi can someone please throw some light on the above questions please. I am also having the same query.

Mikec 28 posts Joined 03/09
29 Dec 2014

As these are really Teradata Database focused questions you would be best to ask them over in the Database forum where the DBS engineers are more likely to see them (this forum is intended for questions about the Application's like CIM, DCM etc).

You must sign in to leave a comment.