How Plan is created while executing the query using SPUFI?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of reorg in db2?

602


What is the physical storage length of timestamp data type?

644


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3118


Explain how can you do the explain of a dynamic sql statement?

649


What is dbrm library?

578






What is the difference between using bind () and rebind () methods of naming class?

790


How can we retrieve the total number of records in RPG & CLLE?

194


What are the 2 sqlcodes that are returned?

641


Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

2322


What does a deadlock mean in DB2?

653


What is dpf in db2?

664


What is a plan and package in db2?

621


What is the meaning concurrency in the db2 database?

634


Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference

749


What is data manager?

607