System Output › Audit Report › PROGRAM Reports

PROGRAM Reports

The PROGRAM Reports feature detailed and summarized statistics by application program within selected time intervals. There are three levels of reporting available:

• Program Details - presents run-time counts (CA IDMS statistics) for all run units ordered by the selected program names
• Program Summary - presents the sum of all run units for an application program
• System Summary - presents a sum of all program summaries within a time interval.

The level of reporting (Detail vs Summary), selection of the time interval length, and the programs to be analyzed are controlled by you. Each program's totals are also reflected as a ratio of the system totals (the percentage of all CA IDMS resources consumed that were accounted for by the program).

If Program Summary is the reporting level, you can optionally request program highlights which are statistics of the run units with lowest and highest duration (up to 10 each). A lower reporting level includes all higher summary reporting (e.g., Program Details are accompanied by Program and System Summaries). When only one time interval is reported, the System Summary is the total of all selected run units. Whenever multiple time intervals are reported, a Grand Summary is produced for all run units. The Grand Summary is simply a total of all the System Summaries.

Note: The most practical method of monitoring program activity periodically is to request program summary/highlights without a specific time interval (LEVEL=SUMMARY, HILITES=YES).

Program Details (LEVEL=DETAILS) should be reported on those occasions where there are more than 20 run unit occurrences for a program, when a strictly timewise sequence of all program activity is desired, or where it is necessary to view all occurrences of a program for detailed investigation.

Program highlights (HILITES=YES) represent those run units which are the lowest and the highest in duration for an application program. Up to ten (10) run units in each category are reported, and are sorted sequentially by length of duration.

When reviewing the Summaries (Program, System, or Grand) attention should be focused on the COUNTS and RATIOS. These statistics can reveal the trends which reflect upon the 'vitality' of the database environment.

In the Program Summary, attention should be paid to the highlighted run units with the longest duration. The cause of the lengthy duration could be:

• An extraordinary amount of processing was performed—check COUNTS
• High run unit activity occurred at the time of execution of the run units—check the ACTIVITY Report
• Inefficient database processing is indicated—check COUNTS and RATIOS
• Program was locked out or had some resource conflict with a concurrently executing program—check the CHRONOLOGICAL EVENT Report.

Note: If a more precise view of the suspected problem is needed, a PROGRAM Display can be requested using a narrow time interval. The run unit IDs and start date/time in the PROGRAM Reports can assist you in selecting the desired time interval.