4. EXCEPTIONS › 4.3 Exception Descriptions › 10093 NO. Times WPHFWT Threshold Reached Buffer 3

10093 NO. Times WPHFWT Threshold Reached Buffer 3

FILE:  DB2 Database 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 that a
WPHFWT threshold was reached for buffer pool 3.

RATIONALE:  This exception tracks the WPHFWT threshold for
buffer pool 3.

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

EXCEPTION STATEMENTS:  The SAS statements that identify the
exception situation and describe the condition are stored in
the source member named in SOURCE LOCATION and are described
below:

/* *********************************************************/
/* EXCEPTION NUMBER:  10093                                */
/* TITLE:  NO. TIMES WPHFWT THRESHOLD REACHED              */
/* FILE:  DB2DSD01                                         */
/* *********************************************************/

IF DSDDMCT3 GT 0 THEN DO;
 EXCCODE='10093';
 SEVERITY='W';
 MGMTAREA='PERFORMANCE';
 EXCDESC1='NO. TIMES WPHFWT THRESHOLD REACHED';
 EXCDESC2='BUFFER 3 '                 ||
          '   '                       ||
          'COUNT = '                  ||
           PUT(DSDDMCT3,6.)
           ;
 LINK HIT;
 END;