4. EXCEPTIONS › 4.3 Exception Descriptions › 10027 Unavailable Resource Failure

10027 Unavailable Resource Failure

FILE:  DB2 System Activity File
SAS FILE NAME:  DETAIL.DB2DSY01
SOURCE LOCATION:  sharedprefix.MICS.SOURCE(DB2DYEXC)

SEVERITY:  Warning              (Severity='W')
MANAGEMENT AREA:  Performance   (MGMTAREA='Performance')

PURPOSE:  This exception warns that a plan has been requested
but the plan is unavailable.  For example, it could have been
invalidated and an unsuccessful automatic bind has occurred.

RATIONALE:  An unavailable resource failure indicates a major
problem in accessing data.  Immediate steps should be taken
to determine why the bind could not complete successfully.

DEFINITION:   This exception is noted when the DSYUNAVL flag
is non-zero.

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:


/* ***************************************** */
/* EXCEPTION NUMBER:  10027                  */
/* TITLE:  UNAVAILABLE RESOURCE FAILURE      */
/* FILE:  DB2DSY01                           */
/* ***************************************** */

IF DSYUNAVL GT 0 THEN DO;
  EXCCODE='10027';
  SEVERITY='W';
  MGMTAREA='PERFORMANCE';
  EXCDESC1='UNAVAILABLE RESOURCE FAILURE';
  EXCDESC2='COUNT = '                  ||
            PUT(DSYUNAVL,6.)
            ;
  LINK HIT;
  END;