Db2 Map model not working

[cnoffsin]

I have the Zenpack installed:

Zenoss 4.2.4-1859

I ran the modeler which told me to install:

https://code.google.com/p/ibm-db/

to get the DSN in there and connect to a remote DB.

I have the clidriver for db2 extracted and in the home variable for the zenoss user. Any tips you can give me with the configuration of the dbd api and clidriver to get it to interface with the zenpack?

[cnoffsin]

The ibm dbd driver looks like it needs a newer version of glibc that is available for el6:

ImportError: /lib64/libc.so.6: version `GLIBC_2.14' not found (required by /usr/lib/python2.6/site-packages/ibm_db-2.0.3-py2.7-linux-x86_64.egg/ibm_db.so)

It comes with 2.12

[cnoffsin]

I had to download the source build and install it as the zenoss user because the zenoss user uses a chrooted python 2.7 and the os is obviously 2.66.

This page here helped:

https://code.google.com/p/ibm-db/issues/detail?id=53

So:

wget https://pypi.python.org/packages/source/i/ibm_db/ibm_db-2.0.3.tar.gz#md5=a6a92055b629ecfecb739e822180dba3 --no-check-certificate

tar -xzvf ibm_db-2.0.3.tar.gz

python setup.py build

python setup.py install

Make sure that /etc/profile has:

export IBM_DB_HOME=/opt/ibm/DB2/dsdriver/odbc_cli_driver/linuxamd64/clidriver

Make sure /home/zenoss/.bashrc has:

export LD_LIBRARY_PATH="/opt/ibm/DB2/dsdriver/odbc_cli_driver/linuxamd64/clidriver/lib:$LD_LIBRARY_PATH" export IBM_DB_DIR=/opt/ibm/DB2/dsdriver/odbc_cli_driver/linuxamd64/clidriver export IBM_DB_LIB=/opt/ibm/DB2/dsdriver/odbc_cli_driver/linuxamd64/clidriver/lib export PATH="${ZENHOME}/bin:${PATH}:/opt/ibm/DB2/dsdriver/odbc_cli_driver/linuxamd64/clidriver/bin"

And the ldconfig as root:

[root@zenoss ~]# cat /etc/ld.so.conf.d/ibm.conf /opt/ibm/DB2/dsdriver/odbc_cli_driver/linuxamd64/clidriver/lib

run as root: ldconfig

And just for reference, I actually am using the 9.5 version of the db2 dsdriver so it doesnt matter what version of db2 it works.