Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
Monitor Netezza database
0.1
2014-02-23
- Nagios 4.x
Other
23942
File | Description |
---|---|
check_nz_longqry.pl | Check for Queries that run longer than 300 seconds |
Nagios world Netezza monitor v3.pptx | 3rd edition of presentation |
Meet The New Nagios Core Services Platform
Built on over 25 years of monitoring experience, the Nagios Core Services Platform provides insightful monitoring dashboards, time-saving monitoring wizards, and unmatched ease of use. Use it for free indefinitely.
Monitoring Made Magically Better
- Nagios Core on Overdrive
- Powerful Monitoring Dashboards
- Time-Saving Configuration Wizards
- Open Source Powered Monitoring On Steroids
- And So Much More!
Netezza databases have become a industry standard for big data and VLDB. Many companies have purchased Netezza machines and migrated large projects from VSAM, DB2, or Sql Server. So now that is part of your company's server inventory what is the best way to keep tabs on it ? Is it constantly overloaded with one users queries ? Are you constantly running out of space ? What if you had away to keep up with all of those issues ? There are some other things that you must do in order for this to work.
NRPE must be installed and functioning on the Netezza database server. Once this is configured you must either use sudo or run NRPE as the nz user and group. Unfortunately this is a requirement of the SQL.pm perl module included by Netezza.
nrpe.cfg must have a entry added to run the perl script
command[check_nz_longqry]=/export/home/nz/scripts/check_nz_longqry.pl
Once these are satisfied the Netezza server must be added to your Nagios servers and finally an service to exercise the command
define service{
use generic-service
host_name proddb
service_description NZSQL Long query
check_command check_nrpe!check_nz_longqry!
notifications_enabled 0
}
NRPE must be installed and functioning on the Netezza database server. Once this is configured you must either use sudo or run NRPE as the nz user and group. Unfortunately this is a requirement of the SQL.pm perl module included by Netezza.
nrpe.cfg must have a entry added to run the perl script
command[check_nz_longqry]=/export/home/nz/scripts/check_nz_longqry.pl
Once these are satisfied the Netezza server must be added to your Nagios servers and finally an service to exercise the command
define service{
use generic-service
host_name proddb
service_description NZSQL Long query
check_command check_nrpe!check_nz_longqry!
notifications_enabled 0
}
Reviews (0)
Be the first to review this listing!