check_db2_health

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.