check_maxdb_health is a Nagios plugin to check various parameters of a MaxDB database.

• –hostname The database server which should be monitored. In case of “localhost” this parameter can be omitted.
• –username The database user.
• –password Password of the database user.
• –mode With the mode-parameter you tell the plugin what it should do. See the list of possible values further down.
• –name Here the check can be limited to a single object. (Momentarily this parameter is only used for mode=sql)
• –name2 If you use –mode=sql, then the SQL-Statement appears in the output and performance values. With the parameter name2 you’re able to specify a string for this..
• –warning Determined values outside of this range trigger a WARNING.
• –critical Determined values outside of this range trigger a CRITICAL.
• –environment = With this you can pass environment variables to the script. Multiple declarations are possible.
• –method With this parameter you tell the plugin how it should connect to the database. (dbi for using DBD::MaxDB (default), maxdb for MaxDB CLI).
• –units <%|KB|MB|GB> The declaration from units serves the “beautification” of the output from mode=sql

Use the option –mode with various mode keywords to tell the Plugin which values it should determine and check.

Mode	Description	Range
connection-time	Determines how long connection establishment and login take	0..n Seconds (1, 5)
uptime	Time since start of the database server (recognizes DB-Crash+Restart)	0..n Seconds (10:, 5: Minutes)
data-total-size
data-size
data-perm-used
data-perm-percent-used
data-perm-free
data-temp-size
data-temp-used
data-temp-percent-used
data-temp-free
data-dev-spaces
list-data-dev-spaces
log-size
log-used
log-percent-used
logs-not-saved
logs-percent-not-saved
logs-since-last-backup
reserved-redo
log-segement-size
savepoints
checkpoints