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
How to execute stored procedure in db2 command editor?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
How many types of page locks can be held in db2?
What is the physical storage length of date data type?
Explain the function done by data manager?
Which isolation level provides maximum concurrency?
What is the picture clause of null indicator variable?
How to compare data between two tables in db2?
What is the maximum size of varchar data type in db2?
What os does db2 run on?
How to resolve deadlock issue
What is the difference between cursor and select statement?
What is ibm db2 connect?
what is db2 restart?
How do you eliminate duplicate values in db2?