Interested to Buy Any Domain ? << Click Here >> for more details...
How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7755 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 the maximum No of rows per page?
Explain dclgen.
What is the use of dclgen in db2?
Explain about dbrm.
Define sqlca.
What is the difference between nvl and coalesce?
What is deadlock in db2?
What is ibm db2 used for?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What are types of indexes?
What does db2 plan contain?
How to resolve deadlock issue
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is the use of commit in db2?
What is a collection in db2?
