Monitor table functions overview
Starting with DB2® Version
9.7,
you can access monitor data through a light-weight alternative to
the traditional system monitor. Use monitor table functions to collect
and view data for systems, activities, or data objects.
Event monitors
Event monitors return information for the event types specified
in the CREATE EVENT MONITOR statement. For each event type, monitoring
information is collected at a certain point in time.
Determining the date a database object was last used
The last date that an object was used is indicated by the
last referenced date (also referred to as the last used date). The
last referenced date is available for indexes, packages, tables, table
data partitions, and materialized query tables (MQTs). You can use
the last referenced date to identify objects which have not been used
for an extended period of time and which might be considered as candidates
for removal.
Time-spent monitor elements
Time-spent monitor elements track how time is spent in
the system. You can query them to see where time is spent waiting,
or performing different types of processing. You can also view the
elapsed time spent in a particular system component.