Answer / s

You can define:

50 4KB BP0-BP49
10 8KB BP8K0-BP8K9
10 16KB BP16K0-BP16K9
10 32KB BP32K0-BP32K9

The number of buffer pools you define is specific to the
DB2 sysbsystem and depends on the DB2 workload. If you dont
have enough real memory to support your bufferpools,
performance will affected severely because of paging.

Answer / manisha shukla

A buffer pool is main storage that is reserved to satisfy
the buffering requirements for one or more tablespaces or
indexes, and is made up of either 4K or 32K pages.

There are four buffer pools: BP0, BP1, BP2, and BP32.

what is main use of table space and index object? please its urgent

5 Answers   CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro,

---

Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..

1 Answers   HSBC,

---

What is dbrm? When it will be created?

0 Answers  

---

what is diffrence b/w file-aid tool and file-aid utility???

1 Answers  

---

What is multi row fetch in db2?

0 Answers  

---

What is database reorganization?

0 Answers  

---

what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?

3 Answers   Cap Gemini, Tech Mahindra,

---

Suppose if I need to update a column, how you do that using cursor?

2 Answers   Verizon,

---

What is an asychronous write?

1 Answers  

---

wht r the requirements for writing a cobol-db2 pgm ?

4 Answers   IBM,

---

what is the input to PLAN? what is the input to DBRM?

4 Answers  

---

what is difference between random and sequence file access

1 Answers   Syntel,

---