For example, you can obtain a list of the locks held by applications connected to a database by taking a database lock snapshot. This is an example of an accumulating counter. The following table lists all the supported snapshot request types. See Chapter 3. Returns internal monitor switch settings.
Information is returned only if there is at least one application connected to the database.
The number of connections to each active database. Requires the table switch. Requires the lock switch. Requires the buffer pool switch. Requires the buffer pool switch.