What is a DB2 plan?

Answer Posted / ganesh

A db2 plan contains collections which in turn contains
packages.
A package contains the exectauble format of the sql
statements placed in the DBRM which was created during the
pre-comlie step.

Is This Answer Correct ?    9 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can the firstname and the lastname from the emp table be concatenated to generate complete names?

746


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


How do you concatenate the firstname and lastname from emp table to give a complete name?

602


Mention the location where the output received from explain statement is stored.

628


What db2 400?

677






How many databases can be created inside an instance in db2 ?

599


what is the sqlcode -501

11303


Name the various locking levels available?

633


What is ibm db2 client?

523


Explain various types of locks in db2?

689


What is coalesce in db2?

682


Define buffer pool.

626


Explain about mirror activator disk mirroring?

560


What is the use of db2?

586


Are views updateable?

643