How many buffer pools are available in db2?

Answers were Sorted based on User's Feedback



How many buffer pools are available in db2?..

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.

Is This Answer Correct ?    3 Yes 0 No

How many buffer pools are available in db2?..

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.

Is This Answer Correct ?    2 Yes 3 No

Post New Answer

More DB2 Interview Questions

What is the difference between TYPE 1 index & TYPE 2 index

1 Answers   IBM,


When is the results table for the query in a DECLARE CURSOR statement created?

5 Answers  


My SQL is not performing well. Describe how will you fine tune it?

1 Answers   Accenture,


I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

2 Answers  


What is difference between alias and synonym in db2?

0 Answers  






Why db2 is called db2?

0 Answers  


What is buffer pool and list some of them?

0 Answers  


What is a correlated sub query?

2 Answers  


What is difference between *omit and *nopass?

1 Answers   IBM, TCS,


How to connect to db2 database from windows command line?

0 Answers  


what is contained in the DB2 node lock file? A) data base names B) data base users names C) license keys D) server names

5 Answers   Accenture,


What is buffer pool in the db2 database?

0 Answers  


Categories