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 define Teradata?
What are tpump utility limitations?
Explain teradata utilities. What is multiload, fast load, tpump?
What happens when a node suffers a downfall?
If RDBMS is halted what will you do ?
What is the function of parser component in teradata?
Explain the term 'tables' related to relational database management system?
How can bottlenecks be identified?
What is meant by a Channel Driver?
Why does varchar occupy 2 extra bytes?
What are the different design perspectives used in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the use of fallback?
How to run a query in teradata?
Differentiate primary key and partition key?