The database can remain online during this procedure. Valid work is not lost. The second step to this procedure restores good transactions through the application of REDO SQL . To avoid the high cost in personnel, time and machine resources of a manual transaction recovery process, a robust transaction recovery solution is needed. Such a solution should address all of the problems associated with quickly analyzing problem transactions, determining the scope of recovery, getting information to determine the best recovery method and managing recovery resources that result in optimal recovery performance.
Users also can specify any combination of fields to identify transactions of interest.
Statistics about the number and types of SQL transactions are gathered and reflected in automatically generated Workload Estimates and Transaction Analysis reporting. These features support customers in choosing the optimal transaction recovery method for the defined set of transactions. Workload Estimates and Transaction Analysis reporting support optimal recovery method selection. Automated JCL job generation reduces programming errors and streamlines the recovery process. Customers can apply very large volumes of corrections with superior speed and without the outage associated with copy processing.