How many buffer pools are available in DB2

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

(Continued from previous question...)

How many buffer pools are available in DB2

Ten 32K size buffer pools and fifty 4K size buffer pools (BP0 to BP49) default buffer pools are bp0, bp1 , bp2 and bp32

(Continued on next question...)

Other Job Interview Questions

• In which column of which DB2 catalog would you find the length of the rows for all tables?
• What is filter factor?
• an I alter a table when other user is selecting some columns ...
• B37 abend during SPUFI
• What is the easiest way to find out which programs are affected by change in a table's structure ??
• What are the advantages of using a PACKAGE?
• Which catalog tables stores referential constraints?
• Can we declare DB2 HOST variable in COBOL COPY book ?
• What does the RUNSTATS Utility do?
• What is EXPLAIN?
• More...