The information in the DB2 log can help you identify recovery issues. ULT™ log analysis can report log events, long running updaters, programs rolling back updates, activity for user, plan or object and point of no activity. TUC allows you to automate the execution of the reports. In addition, activity data is stored in a repository to allow you to query the data, investigate changes and identify log points for recovery.
Changes are backed out if programs abend or issue explicit rollbacks. ULT allows you to analyze the logs and identify stability issues in your applications. If programs are issuing too many rollbacks, it might be related to an application failure that can be resolved by fixing the program logic.