ULT is a powerful log analysis tool that makes it easy to observe changes to DB2 tables. Whether you want to propagate data to different tables, undo faulty changes that were made to a production table, or populate an auditing table with a detailed list of changes that have been made, ULT makes it easy for you to make the most of your DB2 log.

Repair

Correcting a faulty change to a table can be a tricky subject. Recovering the affected table to a point in time before the update may not be feasible because it would undo all subsequent changes as well.

ULT can create SQL statements that revert a specific change that happened at a given point in time. Filtering by different criteria helps you isolate the original operation that was executed against a single table or a set of tables.

Auditing

Businesses want to keep track about who made a change to a table, when it was made, and what exactly was changed. The DB2 log contains all this data in different places.

ULT helps you to put these pieces together and populate your auditing tables with the information you need. You can analyze all changes over a given period of time, or filter by user name, plan, column contents or other criteria. If you already have auditing tables in place, ULT can adapt its output to match your existing table structures.

Data propagation

Keep tables synchronized with ULT’s data propagation feature. Continuous monitoring allows for seamless log examination. ULT can directly execute the same INSERTs, UPDATES and DELETEs to different tables. Alternatively, you can have ULT generate SQL statements for examination or later execution. If your target tables in a different database system like Oracle, you can change the syntax of the generated statements to suit your needs.