Optimizing responses for parallel statement alerts
Follow these steps to optimize the number of responses you see to parallel statement alerts.
About this task
When Db2 activates parallelism for certain SQL statements, several threads are started to evaluate the query results. Db2 Query Monitor monitors each of these thread as individual SQL statements and generates an alert on the message board for each thread that exceeds the alert threshold. As result, one parallel SQL statement might produce multiple alerts on the message board.
If you activate a response for such an SQL statement and select the option The repetition count of an event increments, then a response is triggered every time a thread exceeds the alert thresholds. To avoid too many responses being triggered, Db2 Query Monitor suppresses responses for most child threads. Db2 Query Monitor triggers responses only for parent threads and the first child threads.