Page 1 of 1
DB2 Monitoring
Posted: Mon Nov 09, 2015 9:42 am
by haile711
Hey Guys,
I'm trying to setup a monitoring for my DB2 instant.
https://exchange.nagios.org/directory/P ... th/details
Do we have to installed the DB2 client on the Nagios Server? and the Driver?
Thanks
Re: DB2 Monitoring
Posted: Mon Nov 09, 2015 11:45 am
by lmiltchev
This is a 3rd party plugin. We are not familiar with it, but just by looking at the installation instructions, it seems like the only prerequisite is the DBD::DB2 perl module. Were you able to compile the plugin? Are you having any specific issues with using the "check_db2_health" plugin at the moment?
Re: DB2 Monitoring
Posted: Tue Nov 10, 2015 9:10 am
by haile711
Good morning lmiltchev,
Yea i've tried to installed the DBD::DB2 perl module, but seem like I have to have the client installed also. Im having a hard time installing this module, I just want to see if anyone have had any suggestion or solution that would be helpful for me too.
Re: DB2 Monitoring
Posted: Tue Nov 10, 2015 10:38 am
by rkennedy
What is the specific error message you are receiving?
Re: DB2 Monitoring
Posted: Tue Nov 10, 2015 11:20 am
by haile711
here is the output of the error
Code: Select all
make
make[1]: Entering directory `/tmp/DBD-DB2-1.85/Constants'
gcc -c -I"/home/inst1/sqllib/include" -D_REENTRANT -D_GNU_SOURCE -fno-strict-aliasing -pipe -fstack-protector -I/usr/local/include -D_LARGEFILE_SOURCE -D_FILE_OFFSET_BITS=64 -O2 -g -pipe -Wall -Wp,-D_FORTIFY_SOURCE=2 -fexceptions -fstack-protector --param=ssp-buffer-size=4 -m64 -mtune=generic -DVERSION=\"1.85\" -DXS_VERSION=\"1.85\" -fPIC "-I/usr/lib64/perl5/CORE" Constants.c
Constants.xs:16:20: error: sqlcli.h: No such file or directory
Constants.xs:18:21: error: sqlcli1.h: No such file or directory
Constants.xs:19:20: error: sqlext.h: No such file or directory
make[1]: *** [Constants.o] Error 1
make[1]: Leaving directory `/tmp/DBD-DB2-1.85/Constants'
make: *** [subdirs] Error 2
Re: DB2 Monitoring
Posted: Tue Nov 10, 2015 11:25 am
by rkennedy
Thanks for posting that, just to confirm as well - what OS are you running?
Re: DB2 Monitoring
Posted: Tue Nov 10, 2015 11:56 am
by haile711
here is the OS version rkenney
Code: Select all
cat /etc/redhat-release
Red Hat Enterprise Linlease 6.6 (Santiago)
Re: DB2 Monitoring
Posted: Tue Nov 10, 2015 12:16 pm
by rkennedy
I believe the header files aren't included by default. The article below is written by us, but it seems to be point on with what you're running into -
Look for this part -
While these files are included in the DB2 Server installation package, they are not installed by default. The example shows the features that are installed with DB2 when running db2setup.
https://www.toadworld.com/platforms/ibm ... rl-and-db2