Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Nov 2010 @ 09:54:51 GMT


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


Subj:   TD Request Processing
 
From:   Faible Mou

Hi,

I'm reading the "Introduction to Teradata Warehouse" Release 12.0, B035-1091-067A, March 2010.

Page 53~54 explains TD Request Processing at PE and AMP level. My questions regarding this are,

- When TD have multiple PEs, Do they work in parallel as well?

- If so, how the paralleled PE requests get serialized?

- For figure HD14A001 on page 53, AMP 1 will serialize the requests from PE1 and PE2, correct?

- If the PE1 job is an update request using UPI, will PE2 issue the all-AMPs request, and let the AMP 1 serialize requests from both PE1 & PE2, or will PE2 wait for the PE1 request to finish before issuing the all-AMPs request?


Finally, just want to confirm that it is PEs (not directly AMPs) that pass SQL results back to the clients, correct? If so, this task doesn't seem to have been covered in any of the following Parsing Engine Elements:

Parser
Optimizer
Generator
Dispatcher
Session Control

Thanks for your explanation.


FM



     
  <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: 27 Dec 2016