4. EXCEPTIONS › 4.3 Detailed Exception Descriptions › 04008: CICS DB2 Pool Overflow

04008: CICS DB2 Pool Overflow

FILE:             CICS Incident File
SAS FILE NAME:    DETAIL.CICCIN01
SOURCE LOCATION:  prefix.MICS.USER.SOURCE(DYCICEXC)

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

PURPOSE:  Identify an overutilized DB2 thread.

RATIONALE:  CICS transactions have a set number of DB2
threads assigned to them.  If all those threads are being
utilized at the time that the transaction requires an
thread, the transaction may get the thread from a pool of
threads that has been set aside for such instances.

DEFINITION:  This exception is noted when the DB2 pool
overflow indicator in any transaction record is set.

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.

***************************************************
**  04008
**  CICS DB2 POOL OVERFLOW
*;
IF CINCODE = 8
THEN DO;
EXCCODE='04008'; SEVERITY='W'; MGMTAREA='PERFORMANCE';
EXCDESC1 = CINTEXT;
EXCDESC2= 'TRAN=' || TRANCODE ||
        ' TERM=' || TERMINAL ||
        ' OPER=' || OPERID;
LINK HIT;
END;

THRESHOLD MODIFICATION:  None required