467,209 Members | 1,324 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,209 developers. It's quick & easy.

online monitoring of sql statements

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

--
I prefer non-proprietary document-exchange.
http://sector7g.wurzel6.de/pdfcreator/
http://www.prooo-box.org/
Feb 23 '06 #1
  • viewed: 1295
Share:
7 Replies

Marc Schoechlin wrote:
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

--
I prefer non-proprietary document-exchange.
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/developerwork...dm-0505melnyk/
3) db2pd command options
4) Monitor Tool.....
http://chuzhoi_files.tripod.com/

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

Feb 23 '06 #2
In article <11**********************@e56g2000cwe.googlegroups .com>,
graham_martin (gr***********@uk.ibm.com) says...

Marc Schoechlin wrote:
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

--
I prefer non-proprietary document-exchange.
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/developerwork...dm-0505melnyk/
3) db2pd command options
4) Monitor Tool.....
http://chuzhoi_files.tripod.com/

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
Feb 23 '06 #3
Udo
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

Feb 24 '06 #4
In article <11**********************@p10g2000cwp.googlegroups .com>,
Udo (ud*******@gmail.com) says...
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


Your website shows the menu option:
Technical Deteails / Architecture

Deteails ???
Feb 24 '06 #5
You should read this article:
http://www-128.ibm.com/developerwork...03kolluru.html

-Michel

Feb 24 '06 #6

Michel Esber wrote:
You should read this article:
http://www-128.ibm.com/developerwork...03kolluru.html

-Michel


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

Feb 24 '06 #7
Hi !

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

Best regards

Marc Schoechlin
--
I prefer non-proprietary document-exchange.
http://sector7g.wurzel6.de/pdfcreator/
http://www.prooo-box.org/
Contact me via jabber: ms@256bit.org
Feb 25 '06 #8

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Sven Dzepina | last post: by
6 posts views Thread by Randal | last post: by
4 posts views Thread by Raj | last post: by
9 posts views Thread by colin.mcnulty@yourcommunications.co.uk | last post: by
5 posts views Thread by Ben | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.