check_db2_health is a plugin for Nagios that allows you to monitor DB2 database servers. Itcan operate in several modes: measuring how long it takes to connect and log in; display the number of connected users; display percentage of synchronous reads (SRP); display the percentage of asynchronous writes; display hit ratio in Buffer Pools, or only in Data Pages or Index Pages; display the percentage of SELECT that use an index; display the number of deadlocks per second; display the number of lock requests per second that could not be satisfied; display the fraction of time which was spent waiting for locks; display used space in a database or tablespace; display free space in a tablespace (in contrast to the previous mode, you can use units (MB, GB) for the thresholds); or display used space in a database log.
|Tags||Nagios DB2 Plugin|
|Operating Systems||Unix Linux|
Release Notes: This release adds the modes report and dbthresholds. The mode SQL can now have non-numerical output. This release fixes a bug in connected-users.
Release Notes: This release added last-backup, sort-overflows, and sort-overflow-percentage modes. bufferpool-hitratio now uses hitratio_now to calculate the exit code when --lookback is used.
Release Notes: A bug was fixed for connected users in which only the CONNECTED status was counted, although there are more. An important update of the README file was done.