Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

What is buffrpool? Where we use it ?

Answers were Sorted based on User's Feedback

What is buffrpool? Where we use it ?..

Answer / s

Bufferpools are areas of virtual storage where DB2
temporarily stores the pages of tablespaces and indexes.

Is This Answer Correct ?    12 Yes 0 No

What is buffrpool? Where we use it ?..

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

More DB2 Interview Questions

Why select is not preferred in embedded sql programs?

0 Answers  

Explain the use of the WHERE clause.

2 Answers   IBM,

how can you copy records present in a flat physical file to a database file(physical file).please explain in rpg400 with a simple example

1 Answers   CTS,

what is the name of the default db2 catalog database?

3 Answers   IBM,

How and when does the db2 enforces the unique key?

0 Answers  

How to execute stored procedures?

0 Answers  

if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..

4 Answers   IBM,

Can there be more than one cursor open for any program?

0 Answers  

When do you use the IMAGECOPY?

4 Answers  

wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?

2 Answers  

What is the syntax required for the creation of a cursor?

1 Answers  

What is EXPLAIN?

1 Answers