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 |
How do you pull up a query which was previously saved in qmf?
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is a cursor?
How can you compare table column after update and before update?
i have one file having 100 of records? i want to display it like 20 records in one column and 20 records in another column total 40 records per page ? how ?
What does the REORG Utility do?
What is buffer pool and list some of them?
What db2 400?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is the latest version of ibm db2?
What is the role of the data page in the db2 database?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!