Check DB instance

[donnyforbes]

We have an informix db cluster setup here on our network. How do I setup nagios XI to check to see if the instance is up / down? This is a major factor in purchasing XI version of nagios.
Please get back to me ASAP as we are in the process and ready to purchase.

Thanks

[mcapra]

Looks like you can enable SNMP in Informix:
https://www.ibm.com/support/knowledgece ... fmx1000615

That's probably the way to go. Then you could use one of the various SNMP configuration wizards available in Nagios XI.

[donnyforbes]

I will look into this. I need to get this to work on one server so I can purchase this is what management is wanting me to do.

[donnyforbes]

Looks like you can enable SNMP in Informix:
https://www.ibm.com/support/knowledgece ... fmx1000615

That's probably the way to go. Then you could use one of the various SNMP configuration wizards available in Nagios XI

I have enabled the SNMP on the informix. I am not in the process of setting up the SNMP through the wizard. What I need to know is what
value do I used in order to know up / down this is very important that when this "Informix" instance goes down we are notified. I have attached
what a config to see. Please let me know .

[mcapra]

Here's the general information about what the Informix specific OIDs represent:
https://www.ibm.com/support/knowledgece ... mp_050.htm

I don't know what it means for Informix to be "up" or "down" relative to your organization's business process. Are you relying on specific databases? A parent Linux/Windows process that Informix lives under? The information given so far about the use case is rather thin.

[donnyforbes]

I don't know what it means for Informix to be "up" or "down" relative to your organization's business process. Are you relying on specific databases? A parent Linux/Windows process that Informix lives under? The information given so far about the use case is rather thin.

yes informix rely's on the "sysmaster database" and the informix process is "rmcaaixscc, rmcascc, rmcacmhqscc, rmcacmaixscc, rmcacmyardscc, and http."

[donnyforbes]

i was able to clarity in regards to the informix stuff. The sysmaster db does not mean anything there is no process for it. What I need to have checked to see up / down are the following process.

oninit, CMSM, and httpd...

Can you please tell me how I can go about doing this?

[donnyforbes]

Here is what I did. I copy the the localhost config for httpd and then renamed it for my servers. Here is the config file when I go to configure -> Core config manager -> services

Code: Select all

###############################################################################
#
# Service configuration file
#
# Created by: Nagios Core Config Manager 2.6.7
# Date:	      2017-06-28 14:25:26
# Version:    Nagios 3.x config file
#
# --- DO NOT EDIT THIS FILE BY HAND --- 
# Nagios CCM will overwrite all manual settings during the next update if you 
# would like to edit files manually, place them in the 'static' directory or 
# import your configs into the CCM by placing them in the 'import' directory.
#
###############################################################################

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		/ Disk Usage
	use				xiwizard_nrpe_service
	check_command			check_nrpe!check_disk!-a '-w 20% -c 10% -p /'
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			linux-server
	register			1
	}	

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		CPU Stats
	use				xiwizard_nrpe_service
	check_command			check_nrpe!check_cpu_stats!-a '-w 85 -c 95'
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			linux-server
	register			1
	}	

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		Load
	use				xiwizard_nrpe_service
	check_command			check_nrpe!check_load!-a '-w 15,10,5 -c 30,20,10'
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			linux-server
	register			1
	}	

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		Memory Usage
	use				xiwizard_nrpe_service
	check_command			check_nrpe!check_mem!-a '-w 20 -c 10'
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			linux-server
	register			1
	}	

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		Ping
	use				xiwizard_linuxserver_ping_service
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			linux-server
	register			1
	}	

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		Service Status - httpd - Infx_OAT
	use				local-service
	display_name			Infx
	check_command			check_xi_service_status!httpd!!!!!!!
	register			1
	}	

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		Swap Usage
	use				xiwizard_nrpe_service
	check_command			check_nrpe!check_swap!-a '-w 50% -c 20%'
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			linux-server
	register			1
	}	

define service {
	host_name			duey.sg1.allamericanasphalt.com
	service_description		Users
	use				xiwizard_nrpe_service
	check_command			check_nrpe!check_users!-a '-w 5 -c 10'
	max_check_attempts		5
	check_interval			5
	retry_interval			1
	check_period			xi_timeperiod_24x7
	notification_interval		60
	notification_period		xi_timeperiod_24x7
	contacts			nagiosadmin
	_xiwizard			linux-server
	register			1
	}	

###############################################################################
#
# Service configuration file
#
# END OF FILE
#
###############################################################################

What I need to know is when this service is not available or goes down for some reason I am notified. How can I make sure I will be notified?

[donnyforbes]

Can someone tell me if "Manage Templates" have set things in it. I am asking because I have a service called service - status - httpd - Infx_OAT in which I copied from the localhost httpd config.
I went to the server and stop httpd service, however never got an email . I verified the server was stop by doing a ps -ef |grep httpd as well. I am attaching pics of the config. Please can someone
assist me with this. I need to get this working before we make the purchases.

[donnyforbes]

I don't know what it means for Informix to be "up" or "down" relative to your organization's business process. Are you relying on specific databases? A parent Linux/Windows process that Informix lives under? The information given so far about the use case is rather thin.

Yes I need httpd, CMSM (informix) , and a service called oninit (informix)


Thanks