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.
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.