Interested to Buy Any Domain ? << Click Here >> for more details...
What is buffrpool? Where we use it ?
- 2 Answers
- 14005 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 |
Which components manage deadlocks in db2?
What is explain in db2?
What is read-only cursor?
What is database reorganization?
What is a view? Why use it?
What does the REORG Utility do?
A Table feild is declared as Decimal(7,2). I want to insert the decimal in to this column thru cobol-db2 program. How should I declare my local input file variable or any suggestion?
How do you insert a record with a nullable column?
What is a db2 tablespace?
Is the primary key a clustered index?
what is the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What is an alias and how does it differ from a synonym?
COBOL 
