60 DB2 Recovery Expert for Multiplatforms
5.1 Introduction to log analysis
This section provides an introduction to the log analysis concept and describes
how to access log analysis in DB2 Recovery Expert.
5.1.1 What is log analysis?
For every change that occurs in a DB2 database, a record is written to the DB2
logs describing how to redo or undo the change. In the absence of DB2
Recovery Expert, this information is used in three situations:
Crash recovery
Roll forward
Data capture for DB2 Replication
DB2 Recovery Expert’s log analysis function can be used to analyze or “mine”
the DB2 log files to produce reports describing the changes made to a database
during a specified time period. The reports optionally include SQL to undo or
redo the ...