How many buffer pools are there in DB2?
Answers were Sorted based on User's Feedback
Answer / sabahat khan
50 4K size Buffer Pool BP01 to BP49
10 8K size Buffer Pool 8KBP0 to 8KBP9
10 16K size Buffer Pool 16KBP0 to 16KBP9
10 32K size Buffer Pool 32KBP0 to 32KBP9
Is This Answer Correct ? | 15 Yes | 0 No |
What is a base table?
what are stage one indexable predicates?
What are the Isolation levels possible ?
What is normalization and what are the five normal forms?
What are the benefits of using the db2 database?
How to insert more than one record using insert?
What are the different types of base tables?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
What is the FREE command?
What is meant by repeatable read?
i hav created a program and moved to production but failed to create the table which is been used in the program. the program shows error as soon as it is moved or installed in production or shows error during its runtime. what is the sqlcode for this error
What is the COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?