4. EXCEPTIONS › 4.3 Exception Descriptions › 10090 Prefetch Disabled No Read Engine Buffer 3

10090 Prefetch Disabled No Read Engine Buffer 3

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 sequential
prefetch requests disabled because of an unavailable read
engine.  In this case, buffer pool 3 could not get a read
engine.

RATIONALE:  Because prefetch provides for improved
performance for those situations requiring large amounts of
sequential processing, it is important to know when and why
this function could not be performed.

DEFINITION:  This exception is noted when the DSDREEP3 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:  10090                          */
/* TITLE:  PREFETCH REQUEST DISABLED DUE NO READ ENGINE*/
/* FILE:  DB2DSD01                                   */
/* ***************************************************/

IF DSDREEP3 GT 0 THEN DO;
 EXCCODE='10090';
 SEVERITY='W';
 MGMTAREA='PERFORMANCE';
 EXCDESC1='PREFETCH REQUEST DISABLED NO READ ENGINES';
 EXCDESC2='BUFFER 3 '                 ||
          '   '                       ||
          'COUNT = '                  ||
           PUT(DSDREEP3,6.)
           ;
 LINK HIT;
 END;