4. EXCEPTIONS › 4.3 Detailed Exception Descriptions › 04009: CICS DB2 Wait Without Thread

04009: CICS DB2 Wait Without Thread

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 a transaction has gone into a
wait state after requesting I/O from DB2 and if the
transaction has not been assigned a thread, the transaction
may be waiting for a thread.

DEFINITION:  This exception is noted when the DB2 wait
without thread indicator is set for any transaction.

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.

***************************************************
**  04009
**  CICS DB2 WAIT WITHOUT THREAD
*;
IF CINCODE = 9
THEN DO;
EXCCODE='04009'; SEVERITY='W'; MGMTAREA='PERFORMANCE';
EXCDESC1 = CINTEXT;
EXCDESC2= 'TRAN=' || TRANCODE ||
        ' TERM=' || TERMINAL ||
        ' OPER=' || OPERID;
LINK HIT;
END;

THRESHOLD MODIFICATION:  None required