4. EXCEPTIONS › 4.3 Detailed Exception Descriptions › 03053: Program EXCP/CPU-Second Ratio Exceeds Limit

03053: Program EXCP/CPU-Second Ratio Exceeds Limit

FILE:             Batch User Program Activity
SAS FILE NAME:    DETAIL.BATPGM01
SOURCE LOCATION:  prefix.MICS.USER.SOURCE.(DYSMFEXC)

SEVERITY:  Warning              (SEVERITY='W')
MANAGEMENT AREA:  Workload      (MGMTAREA='WORKLOAD')

PURPOSE:  Identifies programs which incurred a high ratio of
EXCP/CPU-Second.

RATIONALE:  Programs which have a high EXCP to CPU-Second
ratio are I/O bound and are good candidates for improvement
through data set reblocking.

DEFINITION:  This exception is detected when a program's EXCP
per CPU-Second ratio exceeds the installation-defined values.
In addition, the step's CPU time and total EXCPS must exceed
the installation-defined values.

EXCEPTION STATEMENTS:  The SAS statements identifying the
exception situation and describing the condition are stored
in the source member named in SOURCE LOCATION and are
described below.

*
** 03053
** PROGRAM EXCP/CPU-SECOND RATIO EXCEEDS LIMIT
*;
RATIO=0;
IF PGMCPUTM > 0 THEN RATIO=PGMEXCPS/PGMCPUTM;
IF RATIO > excp/cpu-second AND PGMCPUTM > cputime
 AND PGMEXCPS > excps
 THEN DO;
  MGMTAREA='WORKLOAD'; EXCCODE='03053'; SEVERITY='W';
  EXCDESC1=
     'PROGRAM EXCP/CPU-SECOND RATIO EXCEEDS LIMIT';
  EXCDESC2='EXCPS/CPU-SEC=' || PUT(RATIO,5.)
           || ' EXCPS=' || PUT(PGMEXCPS,6.)
           || ' CPU TIME=' || PUT(PGMCPUTM,TIME.);
  LINK HIT;
END;

THRESHOLD MODIFICATION:     Modify the values used for
excp/cpu-sec, cputime, and excps as follows:

    excp/cpu-sec - The ratio of exceptions per CPU second.  A
       ratio of 10 appears as:

          RATIO > 10

    cputime  -  The amount of CPU time, described as hours,
       minutes, and seconds.  A threshold of 5 minutes
       appears as:

          PGMCPUTM > HMS(0,05,00)

    excps  -  The number of exceptions.  A threshold of 1000
       excps appears as:

          PGMEXCPS > 1000