What is the best way to monitor for queries that run > xx seconds? I would love to have a table / file that I can look at each morning to see if there are any issues. I've read about event monitors but I did not see a way to restrict them to a certain time range and we have so many queries that run, I am afraid to capture ever SQL statement that runs. I think that would blow out my storage pretty quickly.
What is the most common way to do this with DB2?