ULT4DB2   3.1

ULT4DB2 is a powerful log analysis and propagation tool that aids in auditing data changes, recovering data, migrating changes and backing out errant updates.

ULT4DB2 also makes data propagation affordable. The immense costs in CPU consumption on the production DB2 that other propagator programs require are significantly decreased by ULT.

ULT4DB2 quickly isolates the undesired changes to database tables and provides easy to use UNDO SQL statements to revoke wrong updates. It also provides REDO statements to apply a set of changes to other tables. It enables DBAs  to quickly recover mission-critical DB2 data. This capability to prevent prolonged unavailability of vital applications can translate into a large sum of money for the different businesses involved. Some features and functions:

• Let DBAs quickly and easily identify, isolate and restore unwanted changes
• Identifies quiet points
• Provides efficient data propagation
• Help auditors locate updates to sensitive data, provide information about those updates including who made them and when.
• Identifies log records by various attributes as table, database, plan, user, group, job
• Presents DB2 log data decompressed and in every conceivable format
• Reports data changes, long running transactions, rollbacks
• Generates Undo and Redo SQL
• Flexible templates allow for easy adaptation.

Show all   |   Hide all

Show all   |   Hide all

• Functional details

  ULT4DB2 is a powerful log analysis tool that

  • Identifies log records by various attributes as table, database, plan, user, group, job
  • Presents DB2 log data decompressed and in every conceivable format
  • Reports data changes, long running transactions, rollbacks
  • Generates Undo and Redo SQL
  • Flexible templates allow for easy adaptation to naming standards
  • Let DBAs quickly and easily identify, isolate and restore unwanted changes
  • Identifies quiet points
  • Provides efficient data propagation
  • Helps auditors to locate updates to sensitive data, provides information about those updates including who made them and when.

• Business problem

  Error Correction: Most application systems are inter-linked. It is nearly impossible to apply traditional recovers. ULT allows specific repairs.

  Auditing: Businesses want to keep track of changes to sensitive information - who changed a table, what was changed and when?.

  Quiet Points: In busy environments it is normally not possible to create preventively quiet points. ULT detects quiet points.

  QA: Long Runner, Rollback Reports.

• Business opportunity

  Error Correction: Most application systems are inter-linked - soon after updates are completed the records are forwarded to other systems and again updated. It is nearly impossible to apply traditional recover methods across these systems. Instead, specific repairs of the changed records are required for this correcting of 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 that 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: Businesses want to keep track of changes to sensitive information - who made  change to a table, when was it made, and what exactly was changed. With ULT4DB2 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.

  Quiet Points: You can use ULT4DB2 to scan for quiet points on unit of recovery (UR) or logical unit of work (LUW) level, whichever is more appropriate for your needs. You can easily recover to a quiet point that ULT4DB2 detected and then reset the CHECK-pending status using the REPAIR utility.

• Return on investment

  ULT4DB2 can scan for quiet points on unit of recovery (UR) or logical unit of work (LUW) level, whichever is more appropriate. To recover to a quiet point that ULT4DB2 detected is easy. Time saved in critical situation!

  The ULT4DB2 Rollback Report lists all rollbacks that occurred within the observation period, sorted by number of UNDO compensation records and lists the percentage of Undos. The Long Running Job Report identifies potentially broken jobs and those transactions with low commit frequency. Filters are available for number of log records, execution time, number of DB2 checkpoints, and number of updated rows. Quality Assurance pays off.

  Undo and Redo functions will pay off.

• Competitive advantage

  • ULT 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).
  • The output for different tables, or different sets of tables, can be written using templates to separate data sets. With ULT4DB2 you can optionally generate SQL statements ready for execution if your target database system is DB2 for z/OS.
  • ULT4DB2 quickly isolates the undesired changes to database tables and provides easy to use UNDO SQL statements to revoke wrong updates. It also provides REDO statements to apply a set of changes to other tables.

• Industries

  Aerospace & Defense Industry
  Automotive Industry
  Banking Industry
  Chemicals & Petroleum Industry
  Computer Services Industry
  Education Industry
  Electronics Industry
  Energy & Utilities Industry
  Government Central/Federal industry
  Government, State/Provincial/Local Industry
  Healthcare Industry
  Industrial Products Industry
  Insurance Industry
  Media & Entertainment Industry
  Professional Services Industry
  Retail Industry
  Telecommunications Industry
  Travel & Transportation Industry
  Wholesale Distribution & Services Industry
  

• Solution areas

  Aerospace & Defense
  Automotive
  Chemicals and Petroleum
  Education
  Electronics
  Energy and Utilities
  Financial Services/Banking
  Government
  Healthcare and Pharmaceutical
  Insurance
  Media and Entertainment
  Retail
  Telecommunications
  Travel and Transportation
  Wholesale Distribution
  

• Customer size

  Midmarket Business (500 to 1000 employees)
  Large Business (greater than 1000 employees)
  

• Languages supported

  English
  

• Countries/regions available for distribution

  Africa

  Americas

  Asia Pacific

  Europe

  Middle East

  Other

• Solution collateral

  Name	Date	Categories
  ULT4DB2 Presentation (587KB)	Nov 11, 2020	Education Products

Show all   |   Hide all

Show all   |   Hide all

• Hardware/OS platforms

  z/OS 1.9
     IBM Systems: z Systems
  z/OS 1.10
     IBM Systems: z Systems
  z/OS 1.11
     IBM Systems: z Systems
  z/OS 1.12
     IBM Systems: z Systems
  z/OS 1.13
     IBM Systems: z Systems
  z/OS 2.1
     IBM Systems: z Systems
  z/OS 2.2
     IBM Systems: z Systems
  

• Services

  Business Recovery Services
  Consulting
  Professional Services
  Total Systems Management Services