NetXMS Support Forum

Hi All,
        I'm a newbie to netxms. I have a task to monitor different types of databases and trigger an email whenever a particular database is down?So can somebody let me know the process in achieveing this task??I have db2,teradata,msql,oracle database to monitor..

Hi,

there are no uniform way to monitor databases, as they all are quite different. Some common approaches (relevant for almost any application) includes monitoring presence of specific processes (using Process.Count parameter) and network port availability. For some databases (Oracle, Informix, DB/2) there are monitoring agents that can provide some additional performance and status data. You can also try DBQuery subagent which is capable of running specific queries in database and provide results (or errors if query execution failed).

Best regards,
Victor

Hi Victor,
            I have read that DB.query in DCI collections is generic way to monitor databases.I have seen my server regarding the DCI collection but unable to see it..Can you let me know how to get that property??



Regards,
Grandhi Venkatesh

Check this section of the guide: https://www.netxms.org/documentation/adminguide/subagents.html#dbquery