Interested to Buy Any Domain ? << Click Here >> for more details...
What is buffrpool? Where we use it ?
- 2 Answers
- 13909 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 |
What are some characteristics of columns that benefit from indexes?
How many buffer pools are there in DB2?
when we are trying to update db2 rows. if the program abends . how we will know that the last successful update row was
List down the data types in the db2 database.
What is an access path?
Can you define an Index if the table size less than 10 PAGES?
What is Declaration Generator(DCLGEN)?
What is the maximum No of rows per page?
What is the connection string to connect to the DB2 Database ?
What is database reorganization?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does an outer join do?
COBOL 
