Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2 Answers
- 8870 Views
- Cap Gemini, IBM, Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sridhar
when the user connect to a database he open a session with PE
there after submit a query.
PE take the query and check the syntax,verify it rights for that PE create session.
session is nothing but logical connection b/w user and Application,it verify the authentication and authorization user, if it k it continues the process.
Next PE perform the parser.
query rewrite mechanism
Optimization
Generate
PE dispatch the response to given Request(User).
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / 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 |
How to copy 1 million records from one DB to another, Which is effective interms of performance?
How to view every column and the columns contained in indexes in teradata?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
What is the function of parser component in teradata?
which option is used to restart the fastexport script ?
Write a program to show the parser component used in teradata?
what is single value and Multivalue ?
What are the components used in smp and massively parallel processing (mpp) machines?
What is multi insert?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the different functions performed in development phase?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Teradata 
