Regresar
-
Título
How to monitor the Stat Agents Status 'Responding/Not Responding' from the backend? -
Descripción
It would be nice to know how to monitor Stat Agents Status 'Responding' / 'Not Responding' by the back end.The purpose of this is to implement a script or procedure which will notify the users when the Agent is under maintenance. -
Resolución
Solution:Keep in mind that the agents themselves can't send emails if they are not responding. The Stat Central Agent and the Oracle Agent update the MERC_WAKE table approximately every 30 seconds.There is an agent_type field on the table which is 'S' for the Central Agent and 'O' for the Oracle agent.Mainly, those Status description are decoded by the diff time calculation. When it is greater than 30 seconds it is decoded as 'Not Responding' but in this status the agent cannot send any email.The select statements executed during this time are below:SELECT SD_CD, UPDATE_DT, AGENT_MODE, AGENT_MODE_UI,SYSDATE, ( (SYSDATE - UPDATE_DT) * 24 * 60 * 60) AS SECONDS_DIFFROM stat.MERC_WAKEWHERE AGENT_TYPE = 'S' <---- Central AgentORDER BY SD_CD;SELECT M.SD_CD, M.UPDATE_DT, M.AGENT_MODE, O.DB_CD,O.SERVER_NAME, O.MERC_WAKE_MULTI,SYSDATE, ( (SYSDATE - M.UPDATE_DT) * 24 * 60 * 60) AS SECONDS_DIFFROM stat.MERC_WAKE M, stat.STAT_OAENV_DETAILS OWHERE M.SD_CD = TO_CHAR (O.AGENT_ID)AND M.AGENT_TYPE = 'O' <---- Oracle AgentORDER BY SD_CD;Those Statements above are captured by dbtrace.log- run editi.ini and check the trace flag then run Stat client and go toTools | Stat Central Agent Status (first time) / Oracle Agent Status (second time)OR- if Toad is used, activate Database | Monitor | SQL Tracker and do the same operation above from the Stat client.