IBM DB2

Instructions are also in the tarball README:

• Copy the *.pl scripts to your Cacti /scripts/ directory

• Create /scripts/data directory, writable by apache user

• Edit the 3 scripts to change paths, usernames, passwords, and select the tables you want to graph.

 (These should probably be done with a data query, but I only monitor
 a few important tables so it wasn't worth the effort)

The activity tables are not as detailed for 8.1. Upgrade to 9.5 if you can! The tables-81.pl script needs ssh keys setup as the apache user → [email protected] The db2 user is whatever user has the catalogs setup (IE: has ~/sqllib/db2profile)

If anyone would like to setup an SNMPd script for this instead of ssh keys, I'll add it to the forum. I personally think this is a cleaner approach when dealing with a lot of servers.

• $ su - apache

edit /etc/passwd and change the shell to /bin/bash if the account is disabled

• -bash-3.2$ ssh2keysetup.sh db2_username host.mydomain.com

DO NOT type in a password when generating a private key. Just press ENTER. After that, type in your db2 password a few times. After it's finished, try to ssh to the machine, it should allow you in with no password

• run tables-81.pl host.mydomain.com as apache. It should return some debug info.

• Setup a DB2 user on the Cacti server, and add the appropriate

catalogs to the machine.

• Check out the top of the tables-95.pl file. If you have a catalog named HOST and add the device

“host.mydomain.com” then change the domain name in the Perl script.

• Import the template XML files

• ENJOY!

If you have problems, please post to the forum page here: http://forums.cacti.net/about32169.html.

Table activity for the table PREFS