How many Buffer pools are there in DB2 and what are they?
- 1 Answers
- 7157 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 |
Name the various locking levels available?
can any one expalin check point with an example?
can any body explain about plan and pakage in detail....
can we view the access paths created by dbrm ? how ? thx
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What is a data page?
How do I add a column to a table in db2?
What is the difference between cursor and select statement?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
difference between group clause and order clause
How does one remove entries from the SCT02 table?
COBOL 
