IBM Books


Agents Waiting on Locks


Snapshot Information Level
Database
Application

API Structure(s)
sqlm_dbase
sqlm_appl

Monitor Group
Basic
Basic

Resettable

No

 

API Element Name
Element Type

agents_locks_waiting
gauge

 

Description:  The number of agents waiting on locks.

Usage:  You can use this field to obtain information on the overall lock contention in the database.

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

[ DB2 List of Books | Search the DB2 Books ]