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

What is a host variable?

3 Answers  


What is a clustering index?

2 Answers  


What is a DB2 catalog?

2 Answers  


How to resolve -407 sql code in DB2?

9 Answers   Cap Gemini,


what is dynamic cursor?gives syntax for this?

1 Answers   TCS,


What is meant by the attachment facility?

3 Answers  


What are the disadvantages of PAGE level lock?

3 Answers  


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.

0 Answers  


What is catalog database in db2?

0 Answers  


What are the isolation levels possible ?

3 Answers  


What are types of indexes?

0 Answers  


What is Call attach facility? How does it work?

1 Answers   Syntel,


Categories