
82 DB2 Recovery Expert for Multiplatforms
The advantage of the graphical interface is its ease of use. However, its
disadvantage is that you can only generate Undo/Redo SQL per transaction or
unit of work (UOW) and per table. The advantage of the command line interface
(db2la) is that, if you create a general report based on a time period, you can
then produce Undo/Redo SQL for all transactions on one table, a list of tables or
one table space in that time period, all in one file.
5.6.2 Can you find all changes made by one application?
No. The application ID is not included in the log records for transactions, and
therefore cannot be seen by the ...