What is the role of transaction logs in database recovery?

To facilitate point-in-time recovery by replaying transactions
To provide a historical record of all transactions for regulatory compliance
To store a copy of the entire database for backup
To track changes made to the database for auditing purposes

Transaction logs in DB2 play a crucial role in database recovery by recording all changes made to the database. These logs enable point-in-time recovery by allowing the replay of transactions up to a specific moment. In case of a database failure or corruption, transaction logs can be used to restore the database to a consistent state by applying the logged transactions.

Add your answer