Monitor Netezza database

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 }

You must be logged in to submit a review.

Your review has been submitted and is pending approval.

Your recommendation has been sent.

Project Overview Project Files Project Notes Reviews