4. EXCEPTIONS › 4.3 Exception Descriptions › 10041 ICF Checkpoints Taken

10041 ICF Checkpoints Taken

FILE:  DB2 System Activity File
SAS FILE NAME:  DETAIL.DB2DSY01
SOURCE LOCATION:  sharedprefix.MICS.SOURCE(DB2DYEXC)

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

PURPOSE:  This exception tracks the number of checkpoints
taken by the DB2 system.

RATIONALE:  Because each checkpoint taken will correspond to
a system record write, it is important to keep track of the
number of checkpoints due to the resources required to write
system statistics.

DEFINITION:  This exception is noted when the DSYNCKPT 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:  10041                  */
/* TITLE:  IFC CHECKPOINTS TAKEN             */
/* FILE:  DB2DSY01                           */
/* ***************************************** */

IF DSYNCKPT GT 0 THEN DO;
 EXCCODE='10041';
 SEVERITY='W';
 MGMTAREA='PERFORMANCE';
 EXCDESC1='IFC CHECKPOINTS TAKEN';
 EXCDESC2='COUNT = '                  ||
           PUT(DSYNCKPT,6.)
           ;
 LINK HIT;
 END;