Print Page - Is there any generic way to monitor databases??

Title: Is there any generic way to monitor databases??
Post by: venkee8787 on January 06, 2015, 09:21:17 AM

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

Title: Re: Is there any generic way to monitor databases??
Post by: Victor Kirhenshtein on January 07, 2015, 12:28:30 AM

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

Title: Re: Is there any generic way to monitor databases??
Post by: venkee8787 on January 19, 2015, 10:08:19 AM

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

Title: Re: Is there any generic way to monitor databases??
Post by: Alex Kirhenshtein on January 19, 2015, 11:34:32 PM

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

NetXMS Support Forum

English Support => General Support => Topic started by: venkee8787 on January 06, 2015, 09:21:17 AM