The high watermark for the actual rows returned of DML activities at all nesting levels in a service class or work class. For service classes, this monitor element returns -1 when COLLECT AGGREGATE ACTIVITY DATA for the service class is set to NONE. For work classes, this monitor element returns -1 if no COLLECT AGGREGATE ACTIVITY DATA work action is specified for the work class. For workloads, this monitor element returns -1 when COLLECT AGGREGATE ACTIVITY DATA for the workload is set to NONE.
For service classes, when you remap activities between service subclasses with a REMAP ACTIVITY action, only the rows_returned_top high watermark of the service subclass where an activity completes is updated. High watermarks of service subclasses an activity is mapped to but does not complete in are unaffected.
Event Type | Logical Data Grouping | Monitor Switch |
---|---|---|
Statistics | event_scstats | - |
Statistics | event_wcstats | - |
Statistics | event_wlstats | - |
Use this element to know the highest DML activity actual rows returned reached on a partition for a service class, workload, or work class in the time interval collected.