Answer / rahul nittala

The concept of packages came from this particular problem
which was faced earlier:
when there were no packages, all the dbrms for a respective
program have to be bound directly to the plan. In such
cases, whenever there was any change made to any calling or
called program within the plan, all the modules had to be
bound to their individual dbrm and then all the dbrms had
to be bound to the plan. To avoid this, the concept of
package was introduced which was just an address location
in the memory and not a physical entity. By introducing the
package concept, it was not necessary to bind all the
individual dbrms again, only that module to which change
was done had to be bound to that respective package. There
will be a one - to - one relation between a dbrm and a
package. A package actually stores the address of the dbrm.

Answer / s

Packages are single bound DBRM. When there is an change
made to the application pgm, it requires only the bind of
the package as opposed to binding the whole plan if the
DBRM was directly bound to the plan.

Answer / deepak dada

packages is which contains the optimised path for
accessing the db2 packages cannt be executed by itself it
can be executed when is cotained in plan

Can any one tell me about Restart logic in DB2.

2 Answers  

---

i want to maintain uniqueness on pdf without make lf??????????

0 Answers  

---

Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,

---

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers  

---

What if we fail to give values in columns declared as NOT NULL ?

3 Answers   Cap Gemini,

---

---

What will the DB2 optimizer do?

2 Answers  

---

assume ther are 5000 records in a database and want to fetch using cursor. cursor fetches only 3000 records and fetch is not happening for remaining 2000 records. why it happens and how to rectify it

1 Answers   TCS,

---

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

0 Answers   HeadStrong,

---

What is lock contention?

1 Answers  

---

What does the RUNSTATS Utility do?

4 Answers  

---

How do I create a view in db2?

0 Answers  

---

How is deadlock resolved?

0 Answers  

---