Archives of the TeradataForum
Message Posted: Wed, 24 Nov 2010 @ 09:54:51 GMT
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:
Thanks for your explanation.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|