check_db2_health

Description

check_db2_health is a plugin which checks the most common metrics of a DB2 database. $ check_db2_health Please select a mode Copyright (c) Gerhard Lausser Check various parameters of DB2 databases Usage: check_db2_health [-v] [-t ] --hostname --port --username= --password= --mode= --database= check_db2_health [-h | --help] check_db2_health [-V | --version] Options: --connect the connect string --username the db2 user --password the db2 user's password --database the database you want to check --warning the warning range --critical the critical range --mode the mode of the plugin. select one of the following keywords: connection-time (Time to connect to the database) connected-users (Number of currently connected users) sql (any sql command returning a single number) database-usage (Used space at the database level) synchronous-read-percentage (Percentage of synchronous reads) asynchronous-write-percentage (Percentage of asynchronous writes) tablespace-usage (Used space at the tablespace level) tablespace-free (Free space at the tablespace level) bufferpool-hitratio (Hit ratio of a buffer pool) bufferpool-data-hitratio (Hit ratio of a buffer pool (data pages only)) bufferpool-index-hitratio (Hit ratio of a buffer pool (indexes only)) index-usage (Percentage of selects that use an index) stale-table-runstats (Tables whose statistics haven't been updated for a while) deadlocks (Number of deadlocks per second) lock-waits (Number of lock waits per second) lock-waiting (Percentage of the time locks spend waiting) sort-overflows (Number of sort overflows per second (Sorts needing temporary tables on disk)) sort-overflow-percentage (Percentage of sorts which result in an overflow) log-utilization (Log utilization for a database) last-backup (Time (in days) since the database was last backupped) list-databases (convenience function which lists all databases) list-tablespaces (convenience function which lists all tablespaces) list-bufferpools (convenience function which lists all buffer pools) --name the name of the tablespace, datafile, wait event, latch, enqueue, or sql statement depending on the mode. --name2 if name is a sql statement, this statement would appear in the output and the performance data. This can be ugly, so name2 can be used to appear instead. --regexp if this parameter is used, name will be interpreted as a regular expression. --units one of %, KB, MB, GB. This is used for a better output of mode=sql You can use the plugin to execute arbitrary sql statements, like check_db2_health --mode sql --name "select whatever from whatever" --warning 10 --critical 20 You can also extend the plugin with small pieces of perl code if you have very specific requirements in your company or if you want to monitor a certain application.

Project Details