By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,004 Members | 1,253 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,004 IT Pros & Developers. It's quick & easy.

online monitoring of sql statements

P: n/a
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
Share this Question
Share on Google+
7 Replies


P: n/a

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

P: n/a
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

P: n/a
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

P: n/a
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

P: n/a
You should read this article:
http://www-128.ibm.com/developerwork...03kolluru.html

-Michel

Feb 24 '06 #6

P: n/a

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

P: n/a
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.