Lock Mode

Snapshot Information Level
Application
Lock

API Structure(s)
sqlm_appl
sqlm_lock
sqlm_lock_wait

Monitor Group
Lock
Lock
Lock

Resettable

No

Event Information Level
Deadlock

API Structure(s)
sqlm_dlconn_event

API Element Name
Element Type

lock_mode
information

Description:  The type of lock being held.

Usage:  This mode can help you determine the source of contention for resources.

This element indicates one of the following, depending on the type of monitor information being examined:

• The type of lock another application holds on the object that this application is waiting to lock (for application-monitoring and deadlock-monitoring levels)
• The type of lock held on the object by this application (for object-lock levels).

The values for this field are:

Mode	Type of Lock	API Constant
	No Lock	SQLM_LNON
IS	Intention Share Lock	SQLM_LOIS
IX	Intention Exclusive Lock	SQLM_LOIX
S	Share Lock	SQLM_LOOS
SIX	Share with Intention Exclusive Lock	SQLM_LSIX
X	Exclusive Lock	SQLM_LOOX
IN	Intent None	SQLM_LOIN
Z	Super Exclusive Lock	SQLM_LOOZ
U	Update Lock	SQLM_LOOU

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]