Questions on Inside AMP

Teradata Applications
Enthusiast

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 (1)
6 REPLIES
Enthusiast

Re: Questions on Inside AMP

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_111...

There are some more links too about TVS and you can get more info and then  more also about Intelligent memory.

Enthusiast

Re: Questions on Inside AMP

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 ?

Enthusiast

Re: Questions on Inside AMP

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.

Enthusiast

Re: Questions on Inside AMP

Hi raja,

Same thing happens in spool space as well ?

So my doubt is FSG Cache is unused Spool Space or Unused RAM memory ?

Enthusiast

Re: Questions on Inside AMP

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

Re: Questions on Inside AMP

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).