DB2 Version 8.1 (FP 4) on AIX 5.2.0.0
I am trying to find out the easiest way of calculating the usage and frequency of stored procedures.
I can take a snapshot of the Dynamic SQL and it will show the stored proc and the number of times it's been executed but this is all the while the call fits in the SQL cache.
Another method would be to capture the SQL through event monitors over a certain period, but this is tiresome and would take such a long time to pull out the information I need.
I was hoping there would be something in the catalog tables (last execution time) or some command I could use to make my life easier. Unfortunately, I haven't found anything like this.
Any ideas?
Many thanks.