Connecting Tech Pros Worldwide Forums | Help | Site Map

Find Active Queries in real-time

Newbie
 
Join Date: Mar 2008
Posts: 1
#1: Mar 16 '08
Hi. I am writing a small monitoring tool for our operators that can monitor our DB2 databases in the organization. I know there are plenty of tools out there but I need something very customized that will be plugged into one of our main monitoring systems.

What I need is actually a query that returns all the active sessions, and for each of them I am mostly interested in :

* Agent id (to locate the process in the Os)
* sql statement
* Amount of io it is doing
* Amount of cpu it is doing
* The program that ran it
..

If not all information is available - I may settle for less.
Just to emphasize, I need this information in real-time. meaning that if it is running now, I need to see it now. I am going to poll that information every 5-10 seconds.

Please help me. I am out of ideas.

Reply