What is buffrpool? Where we use it ?
- 2 Answers
- 12288 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 does it mean if the null indicator has -1, 0, -2?
what is the sqlcode -501
Define db2 and its databases?
What is the difference between cursor stability and repeatable read isolation levels?
What technique is used to retrieve data from more than one table in a single SQL statement?
What is the difference between SYNONYM and ALIAS?
How many sub queries can you combine together ?
Are views updateable?
Explain packages.
What are the full forms of spufi and dclgen and why are they used?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
What is a host variable?
COBOL 
