IBM DB2 ODBC驱动包安装步骤(适用于zabbix环境调用)

下载监控驱动包

下载ibm_data_server_driver_for_odbc_cli.tar.gz(10.5版本),解压到zabbix_proxy目录:

# tar -xvf ibm_data_server_driver_for_odbc_cli.tar.gz -C /opt/itump/zabbix_proxy

修改目录权限

# chmod -R 775 clidriver/

# chown -R zabbix:zabbix clidriver/

修改odbc配置,

# vim /etc/odbcinst.ini

增加如下内容:

# Driver from the DB2-odbc package

# Setup from the unixODBC package

[DB2]

Description     = ODBC for DB2

Driver          = /opt/itump/zabbix_proxy/clidriver/lib/libdb2o.so

DriverUnicodeType=1

改配置文件以注册驱动:

# vim /etc/ld.so.conf.d/db2-clidriver.conf

增加如下内容:

/opt/itump/zabbix_proxy/clidriver/lib

之后把配置文件放到统一的位置便于管理:

# cd /opt/itump/zabbix_proxy/clidriver/cfg

# cp -a db2cli.ini.sample /opt/itump/zabbix_proxy/etc/db2cli.ini

# ln -s /opt/itump/zabbix_proxy/etc/db2cli.ini ./

# chown -R zabbix:zabbix /opt/itump/zabbix_proxy

验证:检查配置结果,是否有新增的配置项

# ldconfig -p | grep /opt/itump/zabbix_proxy/clidriver/lib

libdb2o.so.1 (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libdb2o.so.1

        libdb2o.so (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libdb2o.so

        libdb2clixml4c.so.1 (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libdb2clixml4c.so.1

        libdb2clixml4c.so (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libdb2clixml4c.so

        libdb2.so.1 (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libdb2.so.1

        libdb2.so (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libdb2.so

        libDB2xml4c.so.58 (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libDB2xml4c.so.58

        libDB2xml4c.so (libc6,x86-64) => /opt/itump/zabbix_proxy/clidriver/lib/libDB2xml4c.so