Answer / s

Depends on how many Buffer pools you would like to define
to the system. You can use upto 50 4KB and 10 8KB, 10 16KB
and 10 32KB bufferpools

The minimum buffer pool storage that DB2 allocates
4KB 2000 pages
8KB 1000 pages
16KB 500 pages
32KB 250 pages

if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,

---

What is the reason behind not using select * in embedded sql programs?

0 Answers  

---

What does db2 stand for?

0 Answers  

---

How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)

2 Answers  

---

What language is db2 written in?

0 Answers  

---

AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE

2 Answers   Accenture,

---

What is the maximum No of rows per page?

0 Answers   IBM,

---

What is meant by isolation level?

3 Answers  

---

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers  

---

How do you insert a record with a nullable column?

2 Answers  

---

What is dbrm? What it contains?

0 Answers  

---

Hi Dude,this is Ram.could any one tell me aboue CURRENT OF clause in DB2. Thanks in advance.......

2 Answers  

---