I was wondering if there is any negative impact on the DB if we are running the eventmonitors continuously.
We have setup the eventmonitors to run everyhour during peak business hours which collects all the sqls that were being processed by the DB. The idea had been to collect top rated sqls.
Till now we didn't encounter any problems. But now we have a new database on the same server under the same instance and I have to enable the eventmonitors for collecting sql statements. I was worried about any negative impacts because of this. We are using "NONBLOCKED" evmon type and collects the information into a file.
As you have now experienced, yes... In general, event monitors should only be run on a production systems as a last resort. An exception can be made for the deadlock monitor on V8. There are other exceptions, but they are on a case by case basis.
This is one selling point that Oracle people love to bring up. The event monitor is one of the weak points of DB2 in my opinion. I've had it slow my dev and QA systems to a crawl during tests. You have to be very careful what you monitor, how much you monitor, and when.
Unless you really need all SQL, a snapshot is usually enough for a decent picture of what is going on.