Starting with Version 9.7 Fix Pack 1, the MON_GET_APPL_LOCKWAITS,
MON_GET_LOCKS, and MON_FORMAT_LOCK_NAME relational monitoring interfaces
can be used to collect locking event data to help you quickly identify
locking issues that might be causing problems.
The monitoring interfaces are more efficient and have
a lower impact on the system than existing snapshot interfaces. These
new interfaces report monitoring elements related to locking events.
Use the following routines to collect information about locks:
- MON_GET_APPL_LOCKWAITS
- Returns information about the locks that all the applications
are waiting to acquire on the currently connected database.
- MON_GET_LOCKS
- Returns a list of all locks on the currently connected database.
- MON_FORMAT_LOCK_NAME
- Formats the internal lock name and returns details about the lock
in a row-based format. Each row consists of a key-value pair pertaining
to a particular lock.
Use the following administrative view to collect lock wait information:
- MON_LOCKWAITS
- Returns information about agents working on behalf
of applications that are waiting to obtain locks in the currently
connected database. It is a useful query for identifying locking problems.
The new lock-related monitoring interfaces replace the
following deprecated administrative views and table functions:
- SNAPLOCK administrative view and SNAP_GET_LOCK table function
- SNAPLOCKWAIT administrative view and SNAP_GET_LOCKWAIT table function
- LOCKS_HELD administrative view
- LOCKWAITS administrative view
DB2 Version 9.7 for Linux, UNIX, and Windows