Interested to Buy Any Domain ? << Click Here >> for more details...
What is a buffer pool?
- 2 Answers
- 6437 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 |
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
Who uses db2?
What is the use of dclgen in db2?
what is the steps followed in EXPLAIN Process or EXPLAIN command. (Explain is for identifying the optimized access path but how or what is the steps for doing the EXPLAIN)
Where is the access path logic created by the DB2 Optimizer stored?
what is SMP/E? and what are the major steps of it? thanks...
What are the prerogatives?
I have a main program (A) where we delete some rows in table in a cursor, and we commit it in sub program(B). What will happen - will we get an error or not?
How to check last update on table in db2?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
How to define the a field which accepts value till 99999.99 in db2
What is DYNSLT keyword? How do you perform selection using DYNSLT
COBOL 
