Previous Topic: CHRONOLOGICAL EVENT Report FieldsNext Topic: ABORT COINCIDENCE Report Fields (Part 1)


ABORT COINCIDENCE Report

The ABORT COINCIDENCE Report provides a daily analysis of all aborted recovery units. The report is in two parts. In the first part, the report is ordered by aborted program name. You should be alerted to programs that were concurrently executing when a program aborted, especially when the coincidence ratio exceeds 50%. The excessive consumption of database resources by one run unit can cause other run units to prematurely terminate with resource acquisition delays or deadly embraces.

The second part of the ABORT COINCIDENCE Report, that is only produced when at least one program was executing when another program aborted, is ordered by coincident program name. The associated aborted programs are ranked by their coincidence ratios. A high ratio may reveal resource contention between program types, or possibly between run units of the same program.

The instances of program aborts are recorded in the PROGRAM Reports and the CHRONOLOGICAL EVENT Report, if available. The CHRONOLOGICAL EVENT Report explicitly lists the concurrent programs. This may reveal a pattern such as excessive contention at certain periods of the day.