DB2 Monitoring

[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

[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?

[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.

[rkennedy]

What is the specific error message you are receiving?

[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

[rkennedy]

Thanks for posting that, just to confirm as well - what OS are you running?

[haile711]

here is the OS version rkenney

Code: Select all

cat /etc/redhat-release
Red Hat Enterprise Linlease 6.6 (Santiago)

[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