With DB2 V9.7, there is an alternative to the traditional system monitor. You can use table functions for systems, activities, or objects. Data for these elements are collected and stored in memory.
System monitoring: The server operations as a whole can be monitored through request monitor elements, grouped in the following hierarchical fashion:
Service class: You can group workloads into a service class; for example, marketing
Workload: We can define a workload named reporting, which will belong to the service class—marketing
Unit of work: Users connected to the application accounts will be assigned to the reporting workload
Activity monitoring: Any DML or a DDL statement triggers activities on the data server, as well as calls and the load utility. An activity can have different states, such as
EXECUTING,IDLE, orQUEUED.Data objects monitoring: We can monitor a database object for performance indicators such as a buffer pool, table space, a table, or...