Features and benefits
IBM DB2 Log Analysis Tool helps you to ensure high availability and complete control over data integrity. It allows you to monitor data changes by automatically building reports of changes that are made to database tables. This robust tool also provides the following features that enable you to benefit from improved reporting, performance, and efficient processing:
Reporting:
Use the robust reporting capabilities, including reports on rollbacks, the ability to identify changes related to referential integrity, and expanded column data filtering. Specify which reports to generate when processing the log.
Select from many options when applying the results of analyses.
View current- and post-row image differences to let you easily identify changes that have occurred after the DML report was run.
Report on all log records that are associated with units of recovery as soon as the commit (or abort) point for the UR is found.
Track when data values have changed and be informed of who has made the changes. You can also build reports on change activity and see a history of changes by time, by user, and by application.
Use the "auto-continue" mode, enabling you to set report parameters once and then run any number of times with each subsequent run beginning in the log where the previous run stopped.
Performance:
Run log reading in parallel, even with non-data sharing groups.
Use a high-speed processing option to improve performance for sites using DATA CAPTURE CHANGES on tables.
Archive output by running a detail report without incurring the overhead of the original run.
Improve performance in an environment where large numbers of SQL statements are running by automatically binding SQL that is generated by DB2 Log Analysis Tool into static SQL.
Efficient Processing:
Exploit multi-level security that provides authorizations down to the row level within a table.
Store information on quiet times into DB2 tables for future reference.
Use the "automatic" mode for generating detail reports that automatically selects the most efficient way to run reports (forward or backward).
Automatically determine table space names.
Write data from the DB2 Log Analysis Tool Detail Report to a file in DB2 Load format, which can be loaded into a DB2 table where the data behind the Detail Report can be further analyzed using DB2 Web Query Tool.
Dynamically allocate many data sets that were previously hardcoded in the JCL.
