How many buffer pools are available in db2?
- 2 Answers
- 6661 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
What are the rules for db2 programming?
What is ibm db2 client?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How do I copy a table in db2?
Is ibm db2 open source?
How Plan is created while executing the query using SPUFI?
How many buffer pools are there in DB2?
What are the disadvantages of PAGE level lock?
What is a cursor?
What is a root page?
What are common abends
What is db2? Explain.
COBOL 
