Page 1 of 1

check_db2_health

Posted: Tue Oct 31, 2017 12:44 pm
by ZahidQ
Hi Nagios team,
It looks like the perl plugin is using the db2 deprecated features, including the reference to snapshot_bp, snap_get_db_v91, and snap_get_db database objects.
Please provide the complete list of database objects needs to be granted, in order for the the check_db2_health plugin to work perfectly with the newer versions of IBM DB2.

Used the following configuration changes as per documentation:
update dbm cfg using dft_mon_bufpool on
update dbm cfg using dft_mon_lock on
update dbm cfg using dft_mon_timestamp on
db2inst1$ db2 update dbm cfg using sysmon_group nagios
db2inst1$ db2 grant select,update on table SYSTOOLS.STMG_DBSIZE_INFO to nagios
db2inst1$ db2 grant execute on function sysproc.MON_GET_DATABASE to nagios

Technical environment:
Nagios core v4.3.2, check_db2_health v 1.1.1.4, IBM DB2 UDB v11.1.2, RHEL 7.3

Thanks and regards,

ZahidQ

Re: check_db2_health

Posted: Tue Oct 31, 2017 2:53 pm
by dwhitfield
Can you provide a link to that check? I don't believe that is one of our plugins. Thanks for posting though, either way. I think that will be very helpful for other community members. Perhaps someone will want to fork the plugin with your suggested changes.

Re: check_db2_health

Posted: Wed Nov 01, 2017 12:59 pm
by ZahidQ
you are right, check_db2_health is not a nagios plugin, Thanks

Re: check_db2_health

Posted: Wed Nov 01, 2017 1:04 pm
by dwhitfield
Thanks again for posting the fix! I'm sure it will be useful for community members using that plugin.