Archives of the TeradataForum

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

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

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