4. EXCEPTIONS › 4.3 Exception Descriptions › 10018 Indoubt Thread

10018 Indoubt Thread

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

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

PURPOSE:  This exception warns that an application failure
has occurred after a successful prepare but before a
successful commit.  The failure can occur in the address
space of the application, the transaction manager, DB2, or
all of these.

RATIONALE:  It is important that application program failures
be noted because of the effect on application productivity.
It also may indicate an internal problem with DB2.

DEFINITION:  This exception is noted when the DSYINDBT 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:  10018                  */
/* TITLE:  INDOUBT THREAD                    */
/* FILE:  DB2DSY01                           */
/* ***************************************** */

IF DSYINDBT GT 0 THEN DO;
  EXCCODE='10018';
  SEVERITY='W';
  MGMTAREA='PRODUCTIVITY';
  EXCDESC1='INDOUBT THREAD';
  EXCDESC2='COUNT = '                  ||
            PUT(DSYINDBT,6.)
            ;
  LINK HIT;
  END;