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 |
what is difference between random and sequence file access
Which component is used to execute the sql statements?
Are views updatable ?
what is datacom db?
What is the difference between Primary key and unique index?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
What is Declaration Generator(DCLGEN)?
What is the use of reorg in db2?
What kind of database is db2?
Name some fields from SQLCA.
What is the function of logging in the db2 database?