Interested to Buy Any Domain ? << Click Here >> for more details...
What is buffrpool? Where we use it ?
- 2 Answers
- 14104 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 is meant by concurrency?
Can you access the DB2 Directory table using SQL?
How do you leave the cursor open after issuing a COMMIT? (for DB2 2.3 or above only)
what is dynamic cursor?gives syntax for this?
What is db2 command?
Why use RUNSTAT Utility?
What is meant by index cardinality?
What is view db2?
How can we read records for specific member in CL? AND rpg?
what is the role of the cursor in db2?
What is dclgen in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
COBOL 
