Interested to Buy Any Domain ? << Click Here >> for more details...
How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7701 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
How is the value function used?
How do I optimize a query in db2?
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
How do I add a column to an existing table in db2?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Why select is not preferred in embedded sql programs?
What does the sqlcode of -818 pertain to?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
Return code 100 means?
What is the result of open cursor statement?
what is diffrence b/w file-aid tool and file-aid utility???
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
COBOL 
