Interested to Buy Any Domain ? << Click Here >> for more details...
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT
IS THE USE OF PACKAGE?
- 2 Answers
- 16139 Views
- Tech Mahindra, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
See there is not doubt that PLAN is an executable form of
DBRM and package is not the executable form.
Basically a DBRM can be linked to PLAN directly or a DBRM
can be linked to Package and that package can further linked
to the PLAN
Now if we directly link the DBRM with the plan then every
time we recompile the program(DBRM) we have to regenerate
the plan.
Whereas if we link the DBRM via package then every time we
recompile the program(DBRM) we only require to recompile the
Package.
Hence Binding through package prevents regeneration of plan.
1 more line I want to add just for knowledge.
If we regenerate the PLAN every time then all the other
Programs(DBRMs) which are attached to that same PLAN
required to be rebind thus take waste time.
Hope this answers your query...
| Is This Answer Correct ? | 27 Yes | 2 No |
How to fetch the uncommited data from table ?
What does an outer join do?
What do the initials DDL and DML stand for and what is their meaning?
What is a plan and package in db2?
What is CHECK PENDING ?
How does cobol compile db2 program?
What information is held in SYSIBM.SYSCOPY?
How to handle null values in db2
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What is the maximum number of tables that can be stored on a Partitioned Table Space ?
In terms of DB2 indexing, what is the root page?
COBOL 
