4. EXCEPTIONS › 4.3 Exception Descriptions › 10094 NO. Failures Due to Full EDM Pool

10094 NO. Failures Due to Full EDM Pool

FILE:  DB2 Data Base Activity File
SAS FILE NAME:  DETAIL.DB2DSD01
SOURCE LOCATION:  prefix.MICS.SOURCE(DB2DYEXC)

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

PURPOSE:  This exception provides the transaction failures
due to the Environmental Descriptor Manager Pool being full.
There was not enough space in the pool to support the number
of transaction executions.

RATIONALE:   This exceptions helps to track the problem
caused by an EDM pool which is not large enough for the
amount of work to be performed on the DB2 system.

DEFINITION:  This exception is noted when the DSDEFAL 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:  10094                                */
/* TITLE:  NO. OF FAILURES DUE TO FULL EDM POOL            */
/* FILE:  DB2DSD01                                         */
/* *********************************************************/

IF DSDEFAL GT 0 THEN DO;
  EXCCODE='10094';
  SEVERITY='W';
  MGMTAREA='PERFORMANCE';
  EXCDESC1='NO.  OF FAILURES DUE TO FULL EDM POOL ' ||
          'COUNT = '                  ||
           PUT(DSDEFAL,6.)
           ;
  LINK HIT;
  END;