What is a buffer pool?

Answer Posted / s

Buffer pool are areas of virtual storage that temporarily
stores tablespace pages and index pages.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is the primary key a clustered index?

607


What is multi row fetch in db2?

601


Are views updateable?

642


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

576


How to retrieve rows from a db2 table in embedded sql?

721






What is dbrm? What it contains? When it will be created?

591


What is the physical storage length of date data type?

724


What are the full forms of spufi and dclgen and why are they used?

654


What is ibm db2 database?

532


What is the default page size of buffer pools?

644


How to take backup of table in db2?

599


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

744


How do I add a column to a table in db2?

616


How do I start db2 in windows?

559


If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?

698