
214 DB2 Recovery Expert for Multiplatforms
Reports for the EMPLOYEE table
This section contains log analysis reports for the EMPLOYEE table, from
Scenario 1 (see 5.2, “Scenario A: Recovery using log analysis” on page 60). The
reports were created using the following commands:
To create a general report:
db2la -d SAMPLE -b "2002/10/08 11:44:00" -e "2002/10/08 11:45:00" -n
EMPLOYEE
And then to create a detailed report and Undo SQL:
db2la -d SAMPLE -D -q u -f undo_employee.sql
Example B-1 shows the detailed log analysis report for the EMPLOYEE table and
Example B-2 shows the Undo SQL.
Example: B-1 Detailed log analysis report for EMPLOYEE table
******* ...