Directory

It checks some aspects of Db2, from a primitive perspective.
This script was not written by a dba, and it does not have the view from the administrative aspect of db2.
The code still have parts from Oracle, so this is not focused in Db2, but like porting.
The script does not support HADR, a minimum for a production environment.
It does not reuses connection, and it can be aggressive when monitoring multiple aspects.
The documentation does not include what grants or permissions are necessary to make it work.
It has a SQL replication part, that could be handy, it is not widely used. Instead, the script lacks mechanism to monitor other elements of Db2.

I have developed a new set of plugins to monitor DB2 via JNRPE, thanks to the possibility to keep the connection active between several checks, and also keep values of the previous checks, in order to compare the evolution of the database (for example, bufferpool hit ratio).

JNRPE is very easy to install, with a high level of commitment from the maintainers. The project releases new version frequently, keeping the project alive and free of bugs.

I have seen the code, and it is very interesting, because it captures information from many different DB2 aspects at the same time.

However, it uses root in order to be executed, and it is not always possible. DB2 relies in OS security, and there can be other ways to get the information. No need to do 'su - instUser'

Very interesting queries, however, you need at least DB2 9.7 FP 6

This is a simple plugin to monitor the tablespaces. It provides a simple command line to report the usage of a tablespace. Easy to configure for a person that use Java, if not, the compilation, the classpath and other stuff could complicate the process.

The links direct to another DB2 plugin.
The correct one for the documentation is: http://nagios.frank4dd.com/plugins/manual/check_dbversion_db2.htm
For the sources:
http://nagios.frank4dd.com/plugins/manual/check_dbversion_db2.java

Also, the db-instance mean the database name, not the instance in DB2.