Under the activity menu, there is a 'Current' Agent dashboard. How are the tables and charts derived?
Specifically, the current agent list is a list of agents at what particular time?
Secondly, where can I find the agent information for the past, where is this data being stored and how can I get to it?
The current agents panel displays agent workload, agent activity, and CPU usage. The data for this area is only kept for 60 minutes.
On the Database Homepage toolbar, click Activity and select Current Agents.
The current agents list the current sessions in the database and this is updated in realtime, refreshed every 30 seconds. The other metrics (i.e. agents workload, CPU usage, etc). are updated in realtime while in the panel but reflect timeframe specified in the zonar at the top of the page.
Sessions in the "Current Agent List" can be killed by using clicking on the red icon in the first column. This will execute the following command
When a customer wants to kill a process, they can right click the row where the session he want to kill, click the kill session, this will trigger a connection to SQL Server monitored instance and execute "CALL SYSPROC.ADMIN_CMD( 'force application (quest_agent_id)'". Depending on the permissions set in the DB2 instance, a dialog box may be raised for the user to input a DB2 user and password with privileges to run this command.
The ability to kill a session is also available in the blocking locks (current) screen.
