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 alias in db2?
How to resolve deadlock issue
Give the name of some fields form sqlca.
What is host variable in db2 cobol?
What is the physical storage length of timestamp data type?
How to run db2 command in windows?
What is the clustering index in the db2 database?
How do I delete a table in db2?
Who uses db2?
What is difference between alias and synonym in db2?
What is bind in db2?
Which component is responsible for db2 startup and shutdown?
What is db2 command?
What is package in db2 mainframe?
What is the role of union all and union