Answer / sunil1405

database rquest module(DBRM) , they are created after the
precompilation is performed. It contains executable host
SQL statements.

Plan is the output of bind process, of which the inout to
bind is DBRM. Plan contains host SQL statements.

Answer / mehdee

The above answer is right, but the 2nd part should change
to: PLAN is an executable module containing the access path
logic to one or more DBRMs and packages.

Answer / kundan kumar

DBRM :-database request module(DBRM) , they are created after the
pre-compilation is performed. It contains parsed SQL statements.
PLAN :- PLAN is an executable module containing the access path
logic to one or more DBRMs and packages created after bind process .

What is buffer pool and list some of them?

0 Answers  

---

Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?

2 Answers   Verizon,

---

What is lock escalation?

2 Answers  

---

i have a db2 variable how do u declare tht into working storage section ?

1 Answers   TCS,

---

How to resolve -805 error in DB2?

1 Answers   Cap Gemini,

---

How do I create a table MANAGER (EMP-NO, MANAGER) where MANAGER is a foreign key which references to EMP-NO in the same table? Give the exact DDL.

3 Answers  

---

What are the 2 sqlcodes that are returned?

0 Answers  

---

Which is faster delete or truncate?

0 Answers  

---

how to resolve -805 . how to see dbrm and package not found

2 Answers   IBM,

---

What is COPY PENDING status?

6 Answers  

---

How can you do the explain of a dynamic sql statement?

0 Answers  

---

How many buffer pools are available in db2?

2 Answers  

---