Follow Our FB Page << CircleMedia.in >> 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  






Categories