PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT
IS THE USE OF PACKAGE?
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 |
Explain various types of locks in db2?
What is performance tuning db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
Which command is used to connect to a database in DB2 ? Give the Syntax.
What is the use of commit in db2?
PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?
2 Answers Tech Mahindra, Wipro,
What is correlated subquery?
When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?
How to fetch the uncommited data from table ?
How do you Load a table ?? and what is Load replace ?
What are the four lockable units for DB2?