Is there any generic way to monitor databases??
-
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
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login