Explain in detail about buffer manager and its functionalities?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB2 Interview Questions

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

0 Answers   IBM,


What are the 2 sqlcodes that are returned?

0 Answers  


What db2 400?

0 Answers  


Explain what a plan is?

3 Answers   CTS,


If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?

6 Answers  






Before you give the explain statement, what are the prerogatives?

0 Answers  


What is isolation level?

4 Answers  


How do I handle -911 (deadlock) error in a db2 program so that the program will never abend?

3 Answers   CTS, IBM,


Explain the function of data manager.

0 Answers  


Return code 100 means?

6 Answers   Cap Gemini,


How does cobol compile db2 program?

0 Answers  


What is cascading rollback?

0 Answers  


Categories