Could you please provide detailed documentation for check_db2_health pre-requisites

lausser / check_db2_health

A plugin (monitoring-plugin, not nagios-plugin, see also http://is.gd/PP1330) which checks various parameters of DB2 database servers. This plugin is also part of OMD, go to https://labs.consol.de/repo/, install OMD and there you have check_db2_health.

https://omd.consol.de/docs/plugins/check_db2_health

GNU General Public License v2.0

8 stars 1 forks source link

Could you please provide detailed documentation for check_db2_health pre-requisites #5

Open ranjithkodumbu opened 4 years ago

ranjithkodumbu commented 4 years ago

When I tried to connect db2 database plugin from nagios, it is throwing perl module errors. Could you please list out the detailed pre-reqs for packages required as a dependent for this plugin.

e.g. DB2 client/driver etc.

angoca commented 4 years ago

Also, what kind to permissions does it need? for example, when a database is created as restricted, which grants or authorities should I grant?

angoca commented 4 years ago

For example:

grant select on SYSIBMADM.MON_CONNECTION_SUMMARY to user nagios

Because of:

SQL0551N The statement failed because the authorization ID does not have the required authorization or privilege to perform the operation. Authorization ID: "NAGIOS". Operation: "SELECT". Object: "SYSIBMADM.MON_CONNECTION_SUMMARY". SQLSTATE=42501

angoca commented 4 years ago

db2 grant select,update on SYSTOOLS.STMG_DBSIZE_INFO to nagios