How many Buffer pools are there in DB2 and what are they?
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 collection in db2 bind?
Explain about dbrm.
What is runstats and reorg in db2?
What is buffer pool?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
can all users have the privilage to use the sql statement select * (dml)?
what is the responsibility of the construction superintendent
what are bind concepts in db2 cobol?
What is db2 instance?
What is a db2 cursor?
What are catalog tables in db2?
What is the physical storage length of time data type?
What is a page in db2?
Explain about cursor stability?
What db2 400?