Answer / 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...

Answer / shaikdada

please give me the answer

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

How Plan is created while executing the query using SPUFI?

3 Answers  

---

Which is faster delete or truncate?

0 Answers  

---

What is ALTER ?

3 Answers  

---

how can we retrieve the 100 records of the file ?

2 Answers   IBM,

---

Name some fields from SQLCA.

2 Answers  

---

I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.

5 Answers  

---

What is a DBRM, PLAN ?

3 Answers  

---

What is the SQL Communications Area and what are some of its key fields?

1 Answers  

---

What is the difference between spufi and qmf?

0 Answers  

---

In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?

2 Answers   Wipro,

---

Can you access the DB2 Directory table using SQL?

3 Answers  

---