How Plan is created while executing the query using SPUFI?
Answers were Sorted based on User's Feedback
Answer / guest
Plan is already created during the installation of the DB2I
tools.
| Is This Answer Correct ? | 1 Yes | 1 No |
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 |
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 |
What is an access path?
How to resolve -803 sql code in DB2?
How to find the number of rows in a db2 table?
How to create db2 table in mainframe?
Explain the function done by data manager?
What are the levels of isolation available with DB2V4
What is declare cursor?
What is a base table?
can any body explain about plan and pakage in detail....
What is meant by concurrency?
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
how can u nderstand the sql stmts executed successfully or not ?