Interested to Buy Any Domain ? << Click Here >> for more details...
What is a buffer pool?
- 2 Answers
- 6573 Views
- I also Faced
- E-Mail Answers
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 |
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I start db2 in windows?
What is a collection in db2?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
How many buffer pools are there in DB2?
What do you mean by storage group (stogroup)?
How do I import a csv file into db2?
What is the use of reorg in db2?
What is the reason behind not using select * in embedded sql programs?
What is a thread?
What is meant by isolation level?
COBOL 
