What is a buffer pool?
Answers were Sorted based on User's Feedback
Answer / s
Buffer pool are areas of virtual storage that temporarily
stores tablespace pages and index pages.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / raja
yes what is said above is right. the reason for maintaining
a buffer pool is to minimise the time required for a page
to be accessed for IDMS. the buffer pool is the place which
is searched first by the IDMS for a page.
| Is This Answer Correct ? | 0 Yes | 0 No |
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
Explain various types of locks in db2?
is it possible to get -811 error when you use cursors. why?
How to handle null values in db2
How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?
how will i display the duplicate record's from a table... i don't want to eliminate ...i want to display the duplicate record...for example in my table i have 10 record's like record no(1,2,3,4,2,9,6,1) in this ...so i want to receive duplicates...
Explain about rct in db2?
What is the maximum length of sqlca?
What is catalog database in db2?
What is the result of open cursor statement?
What keyword does an SQL SELECT statement use for a string search?
What can the SET option of the Repair Utility accomplish?