PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT
IS THE USE OF PACKAGE?
Answer Posted / vaneesh khurana
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 |
Post New Answer View All Answers
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What's The Error Code For Unique Index Voilation?
Explain about rct in db2?
What language is db2 written in?
Highlight all the advantages that are attached to a package.
Is db2 free?
What does runstats do in db2?
What are db2 objects?
Define buffer pool.
What are packages in db2?
How do I import data from excel to db2?
What is db2? Explain.
Which command is used to remove all rows from a table?
What is release/acquire in bind?
Why do we bind in db2?