The activity monitoring elements are a subset of the request monitor elements. The elements focus on the activities related to the execution of SQL statements. For activities that are in progress, the metrics are accumulated in memory and for activities that are SQL statements, the metrics are accumulated in the package cache. In the package cache, the activity metrics are aggregated over all the executions of each SQL statement section.
The following table shows the table functions available in Db2 v11.1 for accessing current activity information:
|
Table Function |
Information Returned |
|
MON_GET_ACTIVITY_DETAILS |
Returns information about an activity, including the SQL statement text and set of activities |
