System Output › Audit Report › Program Summary/Totals › Program Summary/Totals Report Fields

Program Summary/Totals Report Fields

The following is a description of the various fields which make up the Program Summary/Totals Report.

SUMMARY—Application program name and processing type.

Start and stop date/time interval of report.

RUN UNITS

• SUCCESSFUL (ENDJ)—Number of recovery units activated within the reported time interval which terminated successfully.
• ABORTED (ABRT)—Number of recovery units activated within the reported time interval which terminated abnormally.
• TOTAL (BGIN)—Total number of run units activated within the reported time interval.
• CHECKPOINT (COMT)—Number of recovery unit checkpoints issued within the reported time interval.

DURATION (SEC)

• LOWEST—Lowest run unit duration encountered.
• HIGHEST—Highest run unit duration encountered.
• MEAN—Average run unit duration encountered.
• MEDIAN—Median run unit duration encountered.

QUIESCE LEVEL

• MEAN—Average quiesce level encountered.
• HIGHEST—Highest quiesce level encountered.

COUNTS—The CA IDMS statistics (see the Program Details for definitions) are reported in three values.

• MEAN VALUE—Average value per run unit occurrence within the reported time interval.
• ACCUMULATED VALUE—Total value for all run unit occurrences within the reported time interval.
• PERCENT OF SYSTEM OCCURRENCES—Ratio of the accumulated value for this program against the accumulated value for all programs active within the reported time interval. Highlights the programs which consume the largest amount of system resources.

The following example shows the PROGRAM Report (Summary/Totals):

 ID                   RELEASE                         CA IDMS JOURNAL ANALYZER                 DATE             TIME         PAGE
                      Rnn.nn                                PROGRAM REPORT                    mm/dd/yy        hh:mm:ss        3

                                                        SUMMARY = IDMSDDDL  BTC
                                                    mm/dd/yy hh:mm - mm/dd/yy hh:mm

  RUN UNITS------SUCCESSFUL   (ENDJ)                                    8 1.00
                 ABORTED      (ABRT)                                    0 0.00
                 TOTAL        (BGIN)                                    8

  DURATION-------LOWEST                                              1.80
  (SEC)          HIGHEST                                            78.83
                 MEAN                                               61.43
                 MEDIAN                                             73.64

  QUIESCE LEVEL--MEAN                                                2.00
                 HIGHEST                                                2

                                                                     MEAN VALUE            ACCUMULATED             PERCENT OF
                                                                                              VALUE            SYSTEM OCCURRENCES

  COUNTS---------RECORDS UPDATED                                   15,726.75                 125,814                   1.00
                 PAGES READ                                         1,178.50                 9,428                     1.00
                 PAGES WRITTEN                                        764.50                 6,116                     1.00
                 PAGES REQUESTED                                   18,009.25               144,074                     1.00
                 CALC RCDS ON HOME PAGE                                 2.63                    21                     1.00
                 CALC RCDS OVERFLOW                                     6.13                    49                     1.00
                 VIA RCDS ON OWNER PAGE                               185.63                 1,485                     1.00
                 VIA RCDS OVERFLOW                                    468.25                 3,746                     1.00
                 RECORDS REQUESTED                                 19,974.50               159,796                     1.00
                 RECORDS BECOMING CURRENT                           6,687.63                53,501                     1.00
                 CALLS TO IDMSDBMS                                  8,672.63                69,381                     1.00
                 FRAGMENTS STORED                                      26.00                   208                     1.00
                 ROOTS OR RCS RELOCATED                                 0.00                     0                     0.00
                 LOCKS REQUESTED                                   24,781.75               198,254                     1.00
                 SELECT LOCKS HELD                                    184.63                 1,477                     1.00
                 UPDATE LOCKS HELD                                 11,542.25                92,338                     1.00

  RATIOS---------PAGES REQUESTED / PAGES READ                          15.28
                 RECORDS REQUESTED / PAGES READ                        16.95
                 RECORDS REQUESTED / RECORDS CURRENT                    2.99
                 CALC RCDS OVERFLOW / CALC RCDS HOME                    2.33
                 VIA RCDS OVERFLOW / VIA RCDS OWNER                     2.52

  AREAS----------SHR UPD DDLDML            LOW=       60,001 HIGH=          62,000 COUNT=        5
                 SHR UPD DDLDML            LOW=       60,001 HIGH=          62,000 COUNT=        1
                 SHR UPD DDLDML            LOW=       60,001 HIGH=          62,000 COUNT=        1
                 SHR UPD DDLDML            LOW=       60,001 HIGH=          62,000 COUNT=        1

RATIOS—The ratios are calculated from the accumulated values of the appropriate counts.

PAGES REQUESTED/PAGES READ—Measures the effectiveness of buffer pool size and allocation. Small ratios (less than 2.00) can indicate random processing, inadequate buffer pool size, or the need for additional buffer pools.

RECORDS REQUESTED/PAGES READ—Measures the overall effectiveness of space management, CALC synonym handling, VIA options, and buffer management. Large ratios (greater than 20) usually indicate effective buffering (the minimizing of database I/O).

RECORDS REQUESTED/RECORDS CURRENT—Measures the amount of processing transparency provided by the database management system. High ratios (greater than 20) indicate a large amount of database traversing is occurring before target records are retrieved. Close examination must be paid to sorted sets, sets without PRIOR or OWNER pointers, or improper program strategy which does not adequately capitalize on currency.

CALC RCDS OVERFLOW/CALC RCDS HOME—Measures the randomness of the CALC field values, or the fullness of database areas. Large ratios (greater than 1 or 2) or steadily increasing ratio values indicate a large number of CALC synonyms, or that space use is increasing and that an area needs reorganizing or enlarging.

VIA RCDS OVERFLOW/VIA RCDS OWNER —Measures the effectiveness of the storage of VIA records, or the fullness of database areas. Large ratios (greater than 1 or 2) or steadily increasing ratios can indicate very large clustering or packing of VIA records (near the associated OWNER records), or a lack of randomness of the OWNER record types or VIA member records. Space utilization may be getting high that may indicate that the area should be reorganized or enlarged.

AREAS—List of up to 8 areas opened by the program with the following information: usage mode, area name, page range, and ready count.