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
- 16132 Views
- Tech Mahindra, Wipro, I also Faced
- E-Mail Answers
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 to access db2 tables in mainframe?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
What is bind package and plan in db2?
How to connect to db2 database from windows command line?
What is cloudant database?
What does sqlcabc has?
What is package in db2 mainframe?
Explain the benefits you can get from mainframe connect?
When do you specify the isolation level?
What db2 400?
What is difference between isnull and coalesce?
List down the data types in the db2 database.
How do you stop a db2 database in linux?
What is db2 and what is the use of db2 optimizer?
How does cobol compile db2 program?
