Previous Topic: 10055 Binds Without Plan ID

Next Topic: 10059 Storage Shortage Expansion Failure – Pool 1

10057 Storage Shortage Expansion Failure - Pool 0


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

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

PURPOSE:   This exception warns that a buffer pool expansion
was necessary but the pool could not be expanded because of a
shortage of virtual storage.  To correct this, check data
base services virtual storage for areas that can be reduced,
i.e.  other buffer pools.

RATIONALE:   This information can help to determine the
appropriate allocation of virtual storage to DB2 buffers.

DEFINITION:  This exception is noted when the DSDSSEF0 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:  10057                  */
/* TITLE:  STORAGE SHORTAGE EXPANSION FAILURE */
/* FILE:  DB2DSD01                           */
/* ***************************************** */

IF DSDSSEF0 GT 0 THEN DO;
  EXCCODE='10057';
  SEVERITY='W';
  MGMTAREA='PERFORMANCE';
  EXCDESC1='STORAGE SHORTAGE EXPANSION FAILURE';
  EXCDESC2='BUFFER 0 '                 ||
           '   '                       ||
           'COUNT = '                  ||
            PUT(DSDSSEF0,6.)
            ;
  LINK HIT;
  END;