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

What is multi row fetch in db2?

614


What is scrollable cursor in db2?

596


What is the advantage in De-normalizing tables in DB2?

758


Mention the way of highlighting as well as putting a cursor to use in a cobol program.

639


How do I delete a table in db2?

655






What is commit in db2?

602


Define buffer pool.

636


How will you return the number of records in table?

525


What is performance tuning db2?

631


What is the difference between bind and rebind in db2?

868


what is utility for parm lib

1894


Can one database have multiple instances?

587


What is nvl in db2?

638


Where can you declare a cursor in a cobol-db2 program?

610


What is page size in db2?

569