online monitoring of sql statements

Marc Schoechlin

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

Subscribe Post Reply

1586

graham_martin

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

Gert van der Kooij

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

Gert van der Kooij

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

Michel Esber

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

-Michel

Feb 24 '06 #6

jacques

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

Marc Schoechlin

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

Similar topics

HostWatch * Monitoring

by: Sven Dzepina | last post by:

Hi All, how I can make a simply HostWatch - system which use a mysql DB and send me an e-Mail if the Server goes off and again on? I began to programm this last night, but the MySQL inquiry is...

PHP

TCP/IP Monitoring in .NET

by: Randal | last post by:

Does anyone have a code sample of how one would "listen" to a TCP/IP session between an application on the local machine and a remote host. I'm looking for code that would allow me to specify a...

.NET Framework

Error: Failed to start monitoring changes - Framework 1.1

by: Tim D | last post by:

Hi, I originally posted this as a reply to a rather old thread in dotnet.framework.general and didn't get any response. I thought it might be more relevant here; anyone got any ideas? My...

ASP.NET

Failed to start monitoring changes to 'e:\Default Web Site' because access is denied.

by: amit.vasu | last post by:

Hi I have created a web serivces using .net framework 2.0. When I try to execute the web service I get the following error. Failed to start monitoring changes to 'e:\Default Web Site' because...

.NET Framework

event monitor for statements

by: Raj | last post by:

Can we create an event monitor for statements in a partitioned environment? CREATE EVENT MONITOR stmt_event FOR STATEMENTS WRITE TO FILE '/home/rajm/event' ON PARTITION 0 GLOBAL DB21034E ...

DB2 Database

Need a 1 min run down of how to log executed SQL statements please

by: colin.mcnulty | last post by:

Hi, I'm a SQL Server DBA, but I guess that won't buy me any friends round here huh? ;-) I've been asked to look at the SQL that's being executed on a DB2 database from a web app, specifically...

DB2 Database

iFrame Monitoring on Server

by: Ben | last post by:

I am building a web app using ASP.NET 2.0. One of the requirements is that we link to a third party vendor's site, display their content. let the user make choices on the vendors site and then...

ASP.NET

Large number of INSERT statements - not all are executed

by: Dmitri | last post by:

Hello! I have a developer that is playing around with some SQL statements using VB.NET. He has a test table in a SQL 2000 database, and he has about 2000 generated INSERT statements. When the...

Microsoft SQL Server

Standby Database Monitoring & Protection Modes (9iR2)

by: Vinod Sadanandan | last post by:

STANDBY DATABASE MONITORING & PROTECION MODES (9iR2) This document is written for understanding and monitoring standby database configured with diffrent protection modes . MAXIMUM PROTECTION ...

Software Development

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA