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 do you need to do before you do EXPLAIN?
What is index cardinality?
What is access path in db2?
Request to database but database is not available so what is was abend is raised?
In which column of which DB2 catalog would you find the length of the rows for all tables?
Describe the elements of the SELECT query syntax?
How does coalesce work?
Explain in brief how does db2 determine what lock-size to use?
Explain about rct in db2?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
How many buffer pools are there in DB2?
What should be specified along with a cursor in order to continue updating process after commit?