What is a recovery log?

DB2 ( IBM Database 2 ) Interview Questions

(Continued from previous question...)

What is a recovery log?

A recovery log is a collection of records that describes the sequence of events that occur in DB2. The information is needed for recovery in the event of a failure during execution.

(Continued on next question...)

Other Interview Questions

• What is a lock?
• What are the functions of Bind?
• What are the Maximum and minimum, number of partitions allowed in a partition tablesspace?
• What is JOIN and different types of JOIN ?
• What is lock escalation?
• Can I use LOCK TABLE on a view?
• Can DASD types assigned to storage groups be intermixed ?
• What will the FREE command do to a plan?
• What is a view ? Why use it
• What is a page?
• More...