what is a plan and how do you refer the plan in the
program?

Answer Posted / harsha

plan is executable.it contains access path.we will refer
plan in jcl as plan name.generally all information abt the
plan will be there in sysibm.sysplan

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

638


How does cobol compile db2 program?

616


List out the buffer pools in db2

642


Explain correlated sub-queries.

593


Explain about mirror activator disk mirroring?

564






What is page size in db2?

569


How do you select a row using indexes in db2?

657


Why db2 is called db2?

601


What is the latest version of ibm db2?

750


How do I delete a column in db2?

688


What are union and union all?

546


How is the value function used?

613


Highlight all the advantages that are attached to a package.

635


How to resolve deadlock issue

18041


If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2

1588