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

What is correlated subquery?

1 Answers  

Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?

1 Answers   UST,

what are stage one indexable predicates?

1 Answers  

What is the use of runstats in db2?

0 Answers  

run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...

0 Answers   IBM,

If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?

8 Answers   Accenture,

What is db2 connect?

0 Answers  

what is difference between Plan and Package

1 Answers   Syntel,

What does sqlcabc has?

0 Answers  

I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?

3 Answers  

What is a SELECT statement?

1 Answers  

What is the specific need of Plan and..where are the tables in DB2 are physically saved

3 Answers   Infosys,