Monitor views are an ideal place to start when interested
in basic monitoring.
These
views provide a condensed representation of monitoring information,
displaying the highlights, as well as providing some of the standard
calculations of most interest, such as buffer pool hit ratio.
Views are very similar to table functions; they return data in
table format, but unlike table functions, they do not require any
input parameters.
The monitor views return metrics on various database activities,
for example:
- MON_BP_UTILIZATION
returns key monitoring metrics, including hit ratios and average read
and write times, for all buffer pools and all database partitions
in the currently connected database.
- MON_CURRENT_SQL returns metrics for all activities that were submitted
on all members of the database and have not yet been completed, including
a point-in-time view of currently executing SQL statements.
- MON_DB_SUMMARY returns metrics aggregated over all service classes.
- MON_LOCKWAITS returns information about agents working on behalf
of applications that are waiting to obtain locks in the currently
connected database.
- MON_SERVICE_SUBCLASS_SUMMARY returns metrics for all service subclasses,
showing work executed per service class.
- MON_CURRENT_UOW returns metrics for all units of work.
- MON_WORKLOAD_SUMMARY returns metrics for all workloads, showing
incoming work per workload.
DB2 10.5 for Linux, UNIX, and Windows