How many buffer pools are there in DB2?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sqlca.

636


Explain about mirror activator disk mirroring?

544


What language is db2 written in?

588


How do you concatenate the firstname and lastname from emp table to give a complete name?

591


How can record locking be achieved in those DB2 versions which do not support it?

607






How to view db2 table structure?

579


What is db2? Explain.

593


Explain how can you do the explain of a dynamic sql statement?

637


What is with ur in db2?

740


How does db2 sample database connect?

557


Are views updateable?

631


What is phantom read in db2?

627


How to rename a table in DB2 ?

624


define clustering index.

607


List down the data types in the db2 database.

624