Long Running Updaters

Identifying programs committing infrequently is an important task because these programs are impacting the recoverability and the availability of tables. Overlooking these programs may cause delays in recovery if a considerable log range must be read to reapply log changes. Also it can impact the Db2 restart time. ULT4DB2’s LONGRUNNERS report can help you identify these programs. You can then consider changing the programs and add logic to commit the changes more frequently. It might be needed to execute this report continuously on your critical tables to ensure that the recoverability and availability is not at risk.