ULT4DB2 is a powerful log analysis tool for viewing and extracting changes to DB2 tables. Database administration, application development and maintenance programmers use ULT4DB2 to repair the result of an incorrect program execution, a wrongly scheduled job or some user error. Auditors and administrators deploy ULT4DB2 to determine update sequences. Data centers replace expensive data propagator tools because ULT4DB2 offers reduced CPU consumption and reasonable license conditions. With ULT4DB2 the desired data can be generated in many preferred formats usable by z/OS and other platforms. It works in single and data-sharing modes and is easy to implement.
Repair Most application systems are interlinked. Soon after updates are completed the records are forwarded to other systems and again updated. It is nearly impossible to apply traditional recovery methods across these systems. Instead, specific repairs of the changed records are required to correct the flawed change. Recovering the affected table to a point-in-time before the update may not be practical because it would undo all subsequent changes as well. ULT4DB2 can create SQL statements that revert a specific change which happened at a given point-in-time. Filtering by various criteria helps you isolate the original operation that was executed against a single table or a set of tables.
Auditing Cooperations want to keep track of changes to sensitive information – who made a change to a table, when was it made, and what exactly was changed. The DB2 log contains all this data in assorted places. ULT4DB2 helps you to put the pieces together and populate your auditing tables with the information you require. You can analyze all the changes over a given period of time and filter by user name, plan, column contents or other criteria. If you already have auditing tables in place, ULT4DB2 can vary its output to match your existing table structures.
Data Propagation Keep tables synchronized with ULT4DB2’s data propagation feature. ULT4DB2 can directly execute the same INSERTs, UPDATES and DELETEs to different target tables. Alternatively, you can have ULT4DB2 generate SQL statements for examination or later execution. If your target tables are in a different database system or platform like Oracle, SQL Server or other DBMS, then you can change the syntax of the generated statements to suit your needs. ULT4DB2 forwards DB2 data in an efficient way. Different from other propagation tools, it does not increase the load on the source DB2 system as ULT4DB2 simply reads the log datasets. This results in significant savings in CPU time. Furthermore, the ULT runtime schedule can be controlled by the user to run at non-peak times and avoid higher cost levels (breach capping).
Versatility “History” documents any ULT4DB2 usage, including all options and files. “Undrop” allows to reestablish deleted tablespaces. “General Inquiry” finds modified data in a time frame.