DBA > Job Interview Questions > DB2 ( IBM Database 2 ) Interview Questions

What is the function of buffer manager ?

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions