How many buffer pools are there in DB2?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

How many buffer pools are there in DB2?

There are four buffer pools: BP0, BP1, BP2, and BP32.

(Continued on next question...)

Other Interview Questions

• What is the equivalent COBOL DATA Type for Decimal(x,y) in DB2 ?
• What are the different methods of accessing DB2 from TSO?
• Explain the use of the WHERE clause?
• Explain the use of the WHERE clause?
• What is IMAGECOPY
• What is a DB2 catalog ?
• What is Maximum number of rows per page
• What is the Manimum Length SQLCA and what is the content of SQLCABC?
• What is Declaration Generator ( DCLGEN )?
• What is cursor stability?
• More...