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 query for your birthday date should be in hours,minute and seconds format?
what types of copies can be made with the COPY Utility ?
What are the uses of db2 optimizer?
where will u check for sqlcode ?
What is sqlcode -811?
7 Answers Accenture, CTS, TCS,
How do I add a column to a table in db2?
Describe the elements of the SELECT query syntax?
How do I delete a column in db2?
how can u retrieve the data from null values using applicaion program.
before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?
What is ibm db2 client?
Is db2 a database?