How Plan is created while executing the query using SPUFI?

Answers were Sorted based on User's Feedback



How Plan is created while executing the query using SPUFI?..

Answer / guest

Plan is already created during the installation of the DB2I
tools.

Is This Answer Correct ?    1 Yes 1 No

How Plan is created while executing the query using SPUFI?..

Answer / arun chinnadurai

A package/plan is created is created for DB2I tools and the
authorization to execute that plan is given to Public.

Is This Answer Correct ?    0 Yes 0 No

How Plan is created while executing the query using SPUFI?..

Answer / mangesh

No Plan is get created while executing the query using
SPUFI. SPUFI , QMF are only tools to check the correctness
of your query , i.e where ur query is correct or u have
coded anythig wrong .

Is This Answer Correct ?    6 Yes 7 No

Post New Answer

More DB2 Interview Questions

wht is d/f between union and joins ?

2 Answers  


how can you access index

4 Answers   IBM, Tech Mahindra,


What is an inner join, and an outer join ?

1 Answers   CTA,


Is db2 a database?

0 Answers  


Which isolation level provides maximum concurrency?

0 Answers  


What is isolation level?

4 Answers  


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2

3 Answers  


Explain an outer join?

1 Answers  


How can you do the explain of a dynamic sql statement?

0 Answers  


What does an outer join do?

1 Answers   CTS,


Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....

1 Answers  


Categories