4. EXCEPTIONS › 4.3 Detailed Exception Descriptions › 02804: Transaction Service Time Exceeds Max

02804: Transaction Service Time Exceeds Max

    FILE: Performance Group Activity File
    SAS FILE NAME: DAYS.SCPPGA01
    SOURCE LOCATION: prefix.MICS.USER.SOURCE(DYRMFEXC)

    SEVERITY: Impacting            (SEVERITY='I')
    MANAGEMENT AREA: Performance   (MGMTAREA='PERFORMANCE')

    PURPOSE:  Detect elongated transaction service time.

    RATIONALE:  The internal response time for a transaction
is the sum of the time spent waiting for service and the time
spent being serviced.  The failure to meet response time
objectives may be caused by spending an excessive amount of
time in either state.  Exception 02805 reports excessive
wait-for-service times.

    DEFINITION:  This exception is detected when the average
service time per transaction for selected performance groups
exceeds an installation-defined maximum.

    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:

  /* **********************************************
  **  02804 TRANSACTION SERVICE TIME EXCEEDS MAX **
  ********************************************** */
IF (PERFGRP=perfgrp1 AND PGAAVSTM > time1) OR
   (PERFGRP=perfgrp2 AND PGAAVSTM > time2)
 THEN DO;
  EXCCODE='02804';SEVERITY='I';MGMTAREA='PERFORMANCE';
  EXCDESC1='TRANSACTION SERVICE TIME EXCEEDS MAX';
  EXCDESC2='SERV TIME=' || PUT(PGAAVSTM,7.1) ||
             ', GROUP=' || PUT(PERFGRP,3.) ||
              ', NAME=' || PERFGRPN;
  LINK HIT;
END;

    THRESHOLD MODIFICATION:  The user should modify the
perfgrp and time values according to the following
conventions:

    perfgrp - The performance group number to be examined.

    time - Maximum performance group wait for service time.

    A test for a service time in excess of 1 second for
performance group 6 would appear as:

    (PERFGRP=6 AND PGAAVSTM > 1)

    A test for a service time in excess of 1 day for
performance group 9 would appear as:

    (PERFGRP=9 AND PGAAVSTM > 86400)