Answer Posted / srinivasa gudla

A package is single bound DBRM with optimized access paths.
It contains location identifier, collection Identifier and
package identifier.

A package can have multiple versions, each with it's own
version identifier

Advantages of Packages,
Reduce the Bind Time.
Versioning.
Can provide BIND options at programmer level.

As Ashish mentioned above, Plan contains packages list which
is nothing but Pointers. whenever you are doing changes in
SQL staetments related to particular DBRM . Then only that
particular Packages needs to be rebind not the Plan. This is
similar to recompiling a sub program not the main program.

What is dbrm? When it will be created?

964

---

What is bufferpool in db2?

989

---

What is node in db2?

992

---

How many types of page locks can be held in db2?

997

---

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1058

---

How does a cursor work?

931

---

What is dclgen (declaration generator)?

1012

---

What is check constraint in db2?

1016

---

What is the physical storage length of time data type?

1070

---

What is reorg and runstats in db2?

1151

---

What is a dbrm in db2?

972

---

Differentiate between cs and rr isolation levels? Where do you specify them?

1026

---

What is bind plan?

983

---

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3094

---

What is blu acceleration in db2?

1018

---