4. EXCEPTIONS › 4.3 Detailed Exception Descriptions › 02805: Transaction Wait for Service Time Exceeds Max

02805: Transaction Wait for 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 workloads with excessive amounts of time
spent waiting for service.

    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 02804 reports excessive
service times.

    DEFINITION:  This exception is detected when the average
wait for 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:

  /* *******************************************************
  **  02805 TRANSACTION WAIT FOR SERVICE TIME EXCEEDS MAX **
  ******************************************************* */
IF (PERFGRP=perfgrp1 AND PGAAVWTM > time1) OR
   (PERFGRP=perfgrp2 AND PGAAVWTM > time2)
 THEN DO;
  EXCCODE='02805'; SEVERITY='I'; MGMTAREA='PERFORMANCE';
  EXCDESC1='TRANSACTION WAIT FOR SERVICE TIME EXCEEDS MAX';
  EXCDESC2='TIME=' || PUT(PGAAVWTM,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 wait-for-service time in excess of 1 second
for performance group 6 would appear as:

    (PERFGRP=6 AND PGAAVWTM > 1)