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

Explain about cursor stability?

623


What is access path in db2?

565


What is consistency token in db2?

642


What is the syntax for seeing the columns and data types of a table in the db2 database?

578


What is cascading rollback?

623






What are the bind parameters ibm db2?

624


What are the various isolation levels possible?

649


Where can you declare a cursor in a cobol-db2 program?

604


Which component is responsible for processing sql statements and selecting access paths?

671


What is isolation level in db2?

577


Comment whether the cursor is closed during commit or not.

676


What is concurrency?

711


What is dclgen in db2?

678


what is the role of the cursor in db2?

643


What is buffer pool?

613