cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Level 8

monitor SQL avg exe time & send alert

Hello,

Want to setup an auto alert job to monitor a particular SQL statement (in DB2 LUW environment) for average execution time & send email alert when average execution time exceeds a specific duration (for example, average execution time for this SQL statement exceeds 5 sec). How can this be done?

I checked out Custom alert - it doesn't look like I can use it for my situation.

Any help is appreciated.

Thanks.

Labels (2)
3 Replies
Level 14

There should be a built in alert for this. If you go to alerts -> manage alerts, under "Wait Time" select the dropdown and select "Average Wait time for a single SQL".

See if that is what you were thinking of.

Thanks. Could you please send me link or direct me to help page/documentation page?

Another question, if I want to find trend of a particular SQL, how do I get it? Under "Trends", I am given with predefined list of SQLs (Top SQL Statements) & I am not finding option to search SQL.

Thanks again.

0 Kudos

Not really any documentation on the wait alerts, but it's pretty intuitive. If you still have questions, I'd recommend opening a support case and then we can show it to you in a GTM.

Regarding the trending for a specific SQL, the best chart in DPA IMO is the historical chart. On the trend view, select the historical chart dropdown and select the hash in question. It will bring up a page that shows how much wait that SQL has experienced over the past 30 days in correlation with what might be driving the waits (executions, disk reads, etc.). Always start with the wait states though!

0 Kudos