Answer / s

Buffer pool are areas of virtual storage that temporarily
stores tablespace pages and index pages.

Answer / raja

yes what is said above is right. the reason for maintaining
a buffer pool is to minimise the time required for a page
to be accessed for IDMS. the buffer pool is the place which
is searched first by the IDMS for a page.

1. what if null values retrived from database and no null indicator mentioned in query. What is sql code.

1 Answers   Cap Gemini,

---

What is a synonym? How is it used?

2 Answers  

---

What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?

4 Answers  

---

Discuss about db2 bind?

0 Answers  

---

How and when does the db2 enforces the unique key?

0 Answers  

---

How do you Load a table ?? and what is Load replace ?

2 Answers   Xansa,

---

What is a buffer pool?

2 Answers  

---

In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)

9 Answers   IBM,

---

What is cursor with hold option in db2?

0 Answers  

---

database DSNDB01 means a.db2 catalog b.db2 directory c.BSDS d.active logs answer with reason please

1 Answers  

---

Where would you find information about the type of database authority held by the user?

2 Answers  

---

Which isolation level provides highest data integrity?

0 Answers  

---