What is buffrpool? Where we use it ?

Answer Posted / pavan grandhi

Buffer pool is a process of caching currently retrieved or
probable pages for retrieval from secondary storage (hard
disks, drums etc.), on to the primary storage.

It is for faster read/write cycles.

Used in OS/RDBMS, DB2 too.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What type of database is db2?

506


What is rct?

732


What are iseries servers?

546


I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

1629


Is db2 a database?

554






What is the use of runstats in db2?

552


How can you quickly find out the # of rows updated after an update statement?

605


What does db2 stand for?

575


What is dbrm?

620


What are types of indexes?

572


Is it possible to create an Instance in DB2 using DB2 Control Center ?

604


What are the benefits of using the db2 database?

643


Can you tell me how can you find out the # of rows updated after an update statement?

588


What is page size in db2?

544


What is the advantage in De-normalizing tables in DB2?

721