What is buffrpool? Where we use it ?
Answers were Sorted based on User's Feedback
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 |
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 |
What is the SQL Communications Area and what are some of its key fields?
What do you mean by commit and rollback?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is a composite index and how does it differ from a multiple index?
Define db2 and its databases?
Mention a credible reason why select* is never given preference in an sql program that has been embedded.
how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE
What is temporal table in db2?
i want to know how the commit option works,how it save the changes? it will update the database or what ? where we can see these saved changes?
how we will do null data selection in cobol-db2 program
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;