Hi
We are trying to quantify the impact on the database performance due
to running queries that query the sysibmadm snapshot views and profile
whats running in the databse.

All we are trying to do is to collect info on what app is running, how
much i/o its using, how much bufferpool its using, cost (if its SP
this is also tough to get), etc for a week in our prod and store it in
a central table. We'll then group them and try to find the application
profiles on our database.
We now are debating if this should be run every 5 mins since it would
impact the performance.
Database gurus and experts, please help me quantify how much impact
this would have on my database.

Thanks

not that easy w/o any useful information... :-)

which version of db2? db2level output would be great.
which monitor switches do you want to turn on?

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/

On Oct 6, 11:33*am, Arun Srini <arunro... (AT) gmail (DOT) com> wrote:
I don't think there would be severe impact on performance if you are
just monitoring what you're talking here. I ever have a set of scripts
doing the same things as you want and then generately report in HTML
format with JPEG chart in a hourly,dayly, weekly or monthly manner.
If you do have enough system resource, IMO, just run it. Take care if
you want collect statement level information though.