ULT4Db2 is a powerful log analyzer for auditing data changes, propagating changes to another system, backing out errant updates and generating reports. ULT4Db2 simplifies most tasks associated with the Db2 Log. Its user-friendly ISPF interface and comprehensive automation features mean that you will be ready to go in minutes and it does most of the heavy lifting for you.
Data Propagation
Keep tables synchronized with the ULT4Db2 data pro-pagation feature. It can directly execute the same INSERT, UPDATE and DELETE statements against different target tables. Alternatively, you can have ULT4Db2 write those statements into external data sets. If your target tables are in a different database system or a platform like Oracle, Microsoft SQL Server, or other DBMS, then you can change the syntax of the generated statements to suit your needs. ULT4Db2 is different from other propagation tools in that it does not increase the load in the source Db2 subsystem because it does not use log capture exits. Instead, it reads the archive and active log datasets directly, which results in significant savings in CPU time. Furthermore, you control exactly when ULT4Db2 runs, so you can schedule it for non-peak times to keep your four-hour rolling average low. Even though ULT4Db2 does not run continuously, it can still provide seamless data propagation. At the end of each execution, it keeps track of how far the log was read and which transactions were still open. You can run the jobs of a propagation task periodically. Depending on your requirements, you may run ULT4Db2 once per day, or every couple of minutes for near real time propagation.