What is the logical entity between plan and Package?

Answer Posted / sridhar reddy

When ever a main progran is executed it is going to create
a DBRM for example if the main program calls n sub programs
then these n sub program need N DBRM's A total of N+1 DBRMs
are needed. A Plan is required to run These DBRM's .
Instead of placing all these DBRM's in a plan , for each
DBRM one package is created & these packages inturn call a
plan.
Instead of placing DBRM's in a plan a package is created
because if we modify any thing no need recompile all the
DBRM's
posted by Sridhar BhumiReddy

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to get the ddl of a table in db2?

673


What db2 400?

673


What is view db2?

620


What is buffer pool in the db2 database?

610


How does db2 sample database connect?

566






What are concurrency issues?

626


What do you mean by between and in? Is between inclusive of specified range values?

662


What language is db2 written in?

593


What are the rules for db2 programming?

639


Discuss about db2 bind?

664


What is the physical storage length of date data type?

722


What is db2 instance?

590


What is bind plan?

604


What is copy pending and check pending in db2?

570


How can you classify the locks in db2?

627