check_db2_health
Posted: Tue Oct 31, 2017 12:44 pm
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
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