Previous Topic: 10085 Prefetch Disabled No Read Engine Buffer 2

Next Topic: 10087 NO. Times Deferred Write Threshold Buffer 2

10086 NO. Times Write Engine Unavailable Buffer 2


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 number of times a write
engine was unavailable for I/O, in this case, for buffer pool
2.

RATIONALE:  This exception documents the situation of when
the write function could not be performed due to no write
engine being available to the buffer pool.

DEFINITION:  This exception is noted when the DSDWREE2 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:  10086                          */
/* TITLE:  NO. TIMES WRITE ENGINE UNAVAILABLE        */
/* FILE:  DB2DSD01                                   */
/* ***************************************************/

IF DSDWREE2 GT 0 THEN DO;
 EXCCODE='10086';
 SEVERITY='W';
 MGMTAREA='PERFORMANCE';
 EXCDESC1='NO.  TIMES WRITE ENGINE UNAVAILABLE';
 EXCDESC2='BUFFER 2 '                 ||
          '   '                       ||
          'COUNT = '                  ||
           PUT(DSDWREE2,6.)
           ;
 LINK HIT;
 END;