online monitoring of sql statements

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marc Schoechlin - 23 Feb 2006 20:40 GMT

Hi !

I'm searching for way for to trace currently processed
sql-queries on a db2 instance/database.

I`m searching for a tool which has the following capabilities:

- show a list of all executed queries in the last <n> minutes
- this list should be sortable
- by frequency of occurrence
- by average over execution time
- by absolute execution time
- log these statements to a logfile

Where can i find such a tool ?

If such a tool doesn`t exist - which resources are available to
implement such a tool in java or perl-DBI ?

Best regards

Marc Schöchlin

Signature

I prefer non-proprietary document-exchange.
http://sector7g.wurzel6.de/pdfcreator/
http://www.prooo-box.org/

Reply to this Message

graham_martin - 23 Feb 2006 21:44 GMT

> Hi !
>
[quoted text clipped - 23 lines]
> http://sector7g.wurzel6.de/pdfcreator/
> http://www.prooo-box.org/

There are a few options......

1) Activity Monitor from within Control Centre (right-click on
Database)
2) Table Functions......as best described in
http://www-128.ibm.com/developerworks/db2/library/techarticle/dm-0505melnyk/
3) db2pd command options
4) Monitor Tool.....
http://chuzhoi_files.tripod.com/

Graham Martin
http://www.ibm.com/software/data/db2/migration/

Reply to this Message

Gert van der Kooij - 23 Feb 2006 23:19 GMT

> > Hi !
> >
[quoted text clipped - 36 lines]
> Graham Martin
> http://www.ibm.com/software/data/db2/migration/

Don't forget the event monitors. They are described in the online
docs at http://tinyurl.com/l2kz3

Reply to this Message

Udo - 24 Feb 2006 12:24 GMT

> I'm searching for way for to trace currently processed
> sql-queries on a db2 instance/database.

Our "Speedgain for DB2" provide this feature.

http://www.itgain.de/en/speedgain.html

Regards,
Udo

Reply to this Message

Gert van der Kooij - 24 Feb 2006 12:50 GMT

> > I'm searching for way for to trace currently processed
> > sql-queries on a db2 instance/database.
[quoted text clipped - 5 lines]
> Regards,
> Udo

Your website shows the menu option:
Technical Deteails / Architecture

Deteails ???

Reply to this Message

Marc Schoechlin - 25 Feb 2006 07:45 GMT

Hi !

Thank you for helpful answers - i will evaluate the
different possibilities now :-))

Best regards

Marc Schoechlin

Signature

I prefer non-proprietary document-exchange.
http://sector7g.wurzel6.de/pdfcreator/
http://www.prooo-box.org/
Contact me via jabber: ms@256bit.org

Reply to this Message

Michel Esber - 24 Feb 2006 14:08 GMT

You should read this article:
http://www-128.ibm.com/developerworks/db2/library/techarticle/0303kolluru/0303ko
lluru.html

-Michel

Reply to this Message

jacques - 24 Feb 2006 20:24 GMT

> You should read this article:
> http://www-128.ibm.com/developerworks/db2/library/techarticle/0303kolluru/0303ko
lluru.html
>
> -Michel

Try db2top http://www.alphaworks.ibm.com/tech/db2top : you can save
queries to file (from the sessions and dynamic SQL screens).

Reply to this Message