Interested to Buy Any Domain ? << Click Here >> for more details...
What is buffrpool? Where we use it ?
- 2 Answers
- 13987 Views
- Tesco, I also Faced
- E-Mail Answers
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 |
How to connect to db2 database from windows command line?
How do I copy a table in db2?
What is db2 connect?
What are the three DB2 date and time data types and their associated functions?
What statistic will tell the DBA how must space can be reclaimed from dropped table spaces on the next reorg run?
What's the difference between DB2 active log and archive log? Thanks a lot...
What is dynamic SQL?
Suppose there are many duplicate records in a Db2 table. What is the query to retrive only duplicate records?
What is JOIN and different types of JOIN.
What is the clustering index in the db2 database?
what is the syntax for FOR UPDATE CLAUSE in cursor declaration and how can u update using cursor? is it possible to update multiple rows at a time.
what is copy pending and check pending ?
COBOL 
