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 db2 stogroup?
What are db2 tables?
What is reorg and runstats in db2?
What is the reason behind not using select * in embedded sql programs?
How does cobol compile db2 program?
Can you define an Index if the table size less than 10 PAGES?
what is the certification that has a good value for a practioner in mainframes but not habving much knowledge on db2 related stuff?
What techniques will be used to avoid deadlock??
Is ibm db2 free?
What is precompiler in db2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is phantom read in db2?