Interested to Buy Any Domain ? << Click Here >> for more details...
How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7585 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 dbrm? What it contains? When it will be created?
How do I optimize a query in db2?
How is a typical db2 batch pgm executed?
What is blu acceleration in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
define clustering index.
Define predicate?
What is the use of value function?
What parameters are used to control the free space in DB2?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How can the duplicate values be eliminated from db2 select?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is iseries database?
What is release/acquire in bind?
What is database alias db2?
