Lock Status

Snapshot Information Level Lock	API Structure(s) sqlm_lock	Monitor Group Basic
Resettable	No
API Element Name Element Type	lock_status information

Description: Indicates the internal status of the lock.

Usage: This element can help explain what is happening when an application is waiting to obtain a lock on an object. While it may appear that the application already has a lock on the object it needs, it may have to wait to obtain a different type of lock on the same object.

The lock can be in one of the following statuses:

Granted state: indicates that the application has the lock in the state specified by "Lock Mode".
Converting state: indicates that the application is trying to change the lock held to a different type; for example, changing from a share lock to an exclusive lock.

Note:

API users should refer to the header file containing definitions of database system monitor constants.

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

[ DB2 List of Books | Search the DB2 Books ]