Lock Detail - Lock Escalatn

This section shows the event specific data for Lock Escalatn.

This trace shows details of a lock escalation. It is shown when data from IFCID 337 is present in the input data.

Format of the Lock Escalatn

This sample shows the format of the data specific to Lock Escalatn.

STATE   =IS         NUMLOCKS=       815 
STMTNO  =      4711                     
STMTINFO=XXXXXXXXXXXXXXXXXXX            
STMTID  =X'XXXXXXXXXXXXXXXX'            
COLLID  =COLLECTIONXXXXXXXXX2XXXXXXXXX3 
         XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6 
         XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9 
         XXXXXXXXX0XXXXXXXXX1XXXXXXXXX2 
         XXXXXXXZ                       
PACKAGE =PACKAGEXX1XXXXXXXXX2XXXXXXXXX3 
         XXXXXXXXX4XXXXXXXXX5XXXXXXXXX6 
         XXXXXXXXX7XXXXXXXXX8XXXXXXXXX9 
         XXXXXXXXX0XXXXXXXXX1XXXXXXXXX2 
         XXXXXXXZ

Field description

STATE

The state or mode of the lock applied to the resource. Valid values:

IS: Intent share
IX: Intent exclusive
S: Share
U: Update
SIX: Shared intent exclusive
X: Exclusive

NUMLOCKS

Number of held lower level locks that were released by escalation.

STMTNO

Statement number.

STMTINFO

The waiter statement information. Possible values are:

STATIC: The statement is of type static
DYNAMIC: The statement is of type dynamic.
NONE: No statement ID, no type.

STMTID

The waiter statement ID.

COLLID

Collection ID.

PACKAGE

Package name.