5.3.1 Which interface is better You can make the decision of whether to use the graphical log analysis tool or the command line db2la tool based on your personal preference. However, each interface has its advantages and disadvantages. The advantage of the graphical interface is that it is easy to use. However, its disadvantage is that you can only generate undo or redo SQL per transaction or unit of work and per table. The advantage of the command line interface is that if you create a general report based on a time period you can then produce undo or redo SQL for all transactions on one table, a list of tables, or one table space in that time period all in one file. With db2la, there is also the option of using LOCK TABLE when undoing SQL. 5.4 Performing remote log analysis With DB2 Recovery Expert V2, there is new functionality that allows you to perform log analysis remotely. Remote log analysis is very useful when your production database server is used heavily and when you do not wish to put more load on it by installing new tools and applications. You can run reports