What is the function of buffer manager ?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is the function of buffer manager ?

The buffer manager is the DB2 component responsible for physically transferring data betwwen an external medium and (virtual) storage (perform the actual I/O operations ). It minimizes the amount of physical I/O actually performed with sophisticated buffering techniques (i. e. read - ahead buffering and look-aside buffering ).

(Continued on next question...)

Other Interview Questions

• In a DB2-CICS program which is acts as co-ordinator and which is participant?
• How do you define a correlated name ?
• What is the STOSPACE Utility used for ?
• What is an access path?
• What is the function of the Data Manager?
• Explain transactions, commits and rollbacks in DB2?
• Can you define an Index if the table size less than 10 PAGES?
• What happens to the PLAN if index used by it is dropped?
• What is the syntax required for the creation of a cursor ?
• How will you delete duplicate records from a table ?
• More...