Team,

We have about to monitor daily running sql's (SAME 60 sql's) -AUTOMATED
And store the Starting time, End time, Rows read, Timerons in a table.

What approach is the best one?
Is there any third party utility solve this idea.
Unix shell scripting will solve this?

Any idea is appreciated.

Thanks,
R

you can start a statement event monitor and write the output to table

CREATE EVENT MONITOR abc FOR STATEMENTS WRITE TO TABLE BUFFERSIZE 4 BLOCKED MANUALSTART ;

this will cause stmt_abc table which will have all the details for the period for which event monitor is on

--Rahul Singh

BY this approach I am not getting

END EXECUTION TIME.

Sql statement is LOB and fills up the table quickly.

Is there any way I tell event monitor to monitor only few queries?

thanks,
-R

Team..

Any takers...

Any guidelines appreciated.

Thanks,
R

You may 'filter' the event monitor capture by specifying authid, applname etc.
Have a look at the create event monitor stmt ..

I would recommend capturing the information to a file and using awk or perl to parse them ... Write to table is a big overhead (beware - the overhead will not be captured by snapshot or event monitors - except the TABLE ones) especially for a OLTP system

HTH
Sathyaram

IIRC, last year there was an article in developerworks by someone in IBM canada who provided scripts for analysis ... Can't seem to find it now ..

Sathyaram