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.
ULT4DB2 supports all DB2  versions.


Business information

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

  • Solution collateral

Technical information

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


Date last modified:    Jul 9, 2021


ULT_feet_cmyk_name.gif

Contact information

Timo Schneider, Susanne Tursman
+49 6641 65510


Company

UBS Hainer Unternehmensberatung & Software Service GmbH
Am Zickmantel 16
Lauterbach 36341
Germany

+49 6641 65510


Contact PartnerWorld

Live Chat is currently unavailable


The live chat service is normally available weekdays 8am-8pm Eastern Time. Use the 'Contact us' link or one of the other links for help now.