Monitoring locking using table functions

You can retrieve information about locks using table functions. Unlike request, activity or data object monitor elements, information about locks is always available from the database manager. You do not need to enable the collection of this information.

Use the following monitor table functions to access current information for locks in the system:
  • MON_GET_LOCKS
  • MON_GET_APPL_LOCKWAIT

Both table functions return data in relational form.