Answer Posted / 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 |
Post New Answer View All Answers
what is the role of the cursor in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
Explain package in db2 and its advantages?
How to find the number of rows in db2 tables?
What is reorg and runstats in db2?
What do you mean by commit and rollback?
What is schema in db2?
What is the maximum number of columns in a db2 table?
What is the default page size of buffer pools?
What is precompiler in db2?
How can you do the explain of a dynamic sql statement?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
Comment whether the cursor is closed during commit or not.
What is temporal table in db2?
Why select is not preferred in embedded sql programs?