Search Exchange
Search All Sites
Nagios Live Webinars
Let our experts show you how Nagios can help your organization.Login
Directory Tree
Directory
angoca
byangoca, July 14, 2020
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.
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.
byangoca, November 19, 2014
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.
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.
byangoca, July 3, 2013
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
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
byangoca, August 15, 2012
byangoca, August 15, 2012
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.
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.