What is a buffer pool ?

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

What is a buffer pool ?

A buffer pool is main storage that is reserved to satisfy the buffering requirements for one or more tablespaces or indexes, and is made up of either 4K or 32K pages.

(Continued on next question...)

Other Job Interview Questions

• What is IMAGECOPY
• Name the different types of Table spaces?
• What is an access path?
• Is there any advantage to denormalizing DB2 tables ?
• How many sub queries can you combine together?
• Why might full image copies be faster to implement than an incremental image copy?
• Is DECLARE TABLE in DCLGEN necessary? Why it used?
• What is a lock?
• What are a precompiler?
• In which column of which DB2 catalog would you find the length of the rows for all tables?
• More...