Home Directory Plugins Databases Monitor Netezza database

Search Exchange

Search All Sites

Nagios Live Webinars

Let our experts show you how Nagios can help your organization.

Contact Us

Phone: 1-888-NAGIOS-1
Email: sales@nagios.com

Login

Remember Me

Directory Tree

Monitor Netezza database

Rating
0 votes
Favoured:
0
Current Version
0.1
Last Release Date
2014-02-23
Compatible With
  • Nagios 4.x
License
Other
Hits
22131
Files:
FileDescription
check_nz_longqry.plCheck for Queries that run longer than 300 seconds
Nagios world Netezza monitor v3.pptx3rd edition of presentation
Network Monitoring Software - Download Nagios XI
Log Management Software - Nagios Log Server - Download
Netflow Analysis Software - Nagios Network Analyzer - Download
Do you have Netezza database in your infrastructure. Would you like to be able to monitor it under Nagios ? I have away to do it. It is extensible and requires no ODBC, no username, and no password. There is a perl module that Netezza includes on the database server called SQL.pm is in delivered in /nz/kit/share/perl. I am including a sample of how to use it to monitor.
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
}