reset monitor switches while capturing snapshots with sql functionsor views

[db2admin]

Hello,

I am interested in capturing snapshot information using SQL functions
or views but i can not reset monitor switches when i use following
command.

db2 "reset monitor for database <database name>"

I am running a loop in which i am trying to reset switches, capture
snapshot, make my script wait for 5 minutes and then go back to reset
switches, capture snapshots

Please help me fine out how can i achieve this.


regards,
db2admin

[w.l.fischer@googlemail.com]

Re: reset monitor switches while capturing snapshots with sqlfunctions or views

On Oct 16, 11:20 pm, db2admin <jag...@gmail.c omwrote:

Hello,
>
I am interested in capturing snapshot information using SQL functions
or views but i can not reset monitor switches when i use following
command.
>
db2 "reset monitor for database <database name>"
>
I am running a loop in which i am trying to reset switches, capture
snapshot, make my script wait for 5 minutes and then go back to reset
switches, capture snapshots
>
Please help me fine out how can i achieve this.
>
regards,
db2admin

I don't know if your question is just too simple (like forgetting to
switch the switches on with db2 update dbm cfg using dft_mon_stmt on
etc.) or too complicated (the command not working in your setup with
your fixpack). But did you consider using event monitors instead?