
March 16th, 2008, 03:31 AM
|
|
Registered User
|
|
Join Date: Mar 2008
Posts: 1
Time spent in forums: 19 m 32 sec
Reputation Power: 0
|
|
|
Find Active Queries in real-time
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.

|