What is a recovery log?

More DBA job interview questions and answers at http://dba.fyicenter.com/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 Job Interview Questions

• What is an inner join, and an outer join?
• What is a result table ?
• Why might full image copies be faster to implement than an incremental image copy?
• How do you define a correlated name ?
• What is COPY PENDING status ?
• What are the isolation levals possible ?
• The only place of VSAM KSDS in DB2 is
• What is a synonym ? How is it used ?
• What is the syntax of SELECT statement when embedded in a COBOL program ?
• Can you access the DB2 Directory table using SQL?
• More...