4. EXCEPTIONS › 4.3 Exception Descriptions › 10072 NO. Lock Escalations to Exclusive Mode

Previous Topic: 10071 Write Pagefixed Without Real Storage - Pool 3

Next Topic: 10073 Maximum Number of Page Locks Held

10072 NO. Lock Escalations to Exclusive Mode


FILE:  DB2 Data Base 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
DB2 automatically changed from page locking to table space
locking.

RATIONALE:  Locking determines the level of concurrency which
can be maintained for a transaction.  Since DB2 can change
the locking level specified by an application developer, it
is important to know how DB2 controls this capability.

DEFINITION:  This exception is noted when the DSDLEEM 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:  10072                       */
/* TITLE:  NO. LOCK ESCALATIONS TO EXCLUSIVE MODE */
/* FILE:  DB2DSD01                                */
/* ************************************************/

IF DSDLEEM GT 0 THEN DO;
 EXCCODE='10072';
 SEVERITY='W';
 MGMTAREA='PERFORMANCE';
 EXCDESC1='LOCKS ESCALATED TO EXCLUSIVE MODE ' ||
          'COUNT = '                  ||
           PUT(DSDLEEM,6.)
           ;
 LINK HIT;
 END;