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 a host variable?
What is a clustering index?
What is a DB2 catalog?
How to resolve -407 sql code in DB2?
what is dynamic cursor?gives syntax for this?
What is meant by the attachment facility?
What are the disadvantages of PAGE level lock?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is catalog database in db2?
What are the isolation levels possible ?
What are types of indexes?
What is Call attach facility? How does it work?