Build precise queries to find exactly what you need
Press ESC to close
@angoca
Favorites2
Views3299
Projects2
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
Reviewed 12 years ago
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.
Reviewed 5 years ago
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.
Reviewed 13 years ago
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.
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.
Reviewed 11 years ago