IBM QUESTION
As all we know PE takes the SQL Request and it will give
responce for that query. what is the internal process
happening.how it is taking that sql from the system?????
thanks in Advance
Answer Posted / tdguy
When a SQL is submitted, processing starts with PE.PE
checks for syntax, checks for security and handles
sessions. Then it builds a plan. This plan is communicated
to the BYNET. Based on the plan, BYNET signals the
appropriate AMPS. AMPS inturn, retrieve or store the data
in the respective vdisks. Communications between the
components involve acknowledgement and response signals.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do you verify a complicated sql?
Difference between stored procedure and macro?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What are default access rights in teradata? What explicit right can be given to a user?
What are the frequently used data types in teradata?
How to eliminate product joins in a teradata sql query?
How is MLOAD Client System restarted after execution?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the uses of client software involved in teradata?
Name the five phases that come under MultiLoad Utility.
What are the main components of teradata system?
What is meant by a dispatcher?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
Explain the term 'primary key' related to relational database management system?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?