Notification facility
The notification facility sends a message to a designated VM user when an
SQL statement exceeds a resource consumption limit, defined as:
-
a maximum number of DB2 buffer lookups
-
a maximum number of I/O requests or dataspace page transfers
-
a maximum response time
-
a maximum idle time
-
a maximum lockwait time
All messages sent are also kept in a CMS file, that is sent to the same VM
user at the end of the day.