How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 6824 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
What is host variable in db2 cobol?
Explain about rct.
What is the role of the data page in the db2 database?
What is database reorganization?
What parameters are used to control the free space in DB2?
What is the difference between drop table and delete table?
What is syscat in db2?
What is a buffer in memory?
What is a page in db2?
Why db2 is called db2?
What is the use of commit in db2?
What are the various isolation levels possible?
What is lock escalation in db2?
What are the full forms of spufi and dclgen and why are they used?
How to connect to db2 database from windows command line?
