BigInsights Netezza联合会

Question

当尝试将BigInsights联邦设置为Netezza时，遵循http://www.ibm.com/developerworks/library/ba-federation-biginsights/index.html准则

在设置了所有env之后，当尝试为Netezza创建一个包装器时，我会得到以下错误：

创建包装器NETZ库‘OPTIONS(MODULE'/opt/ibm/home/bigsql/resources/lib64/libnzodbc.so')；’libdb2rcodbc.so SQL异常: State: 42724:无法加载指定的库"/opt/ibm/home/bigsql/resources/lib64/libnzodbc.so“。SQLCODE=-10013，SQLSTATE=42724，DRIVER=3.67.33

有没有人遇到过这种情况。我也遵循了链接http://www-01.ibm.com/support/docview.wss?uid=swg21154462中的建议。

而且仍然有同样的问题。

Answer 1

通常，您需要检查以下内容以确保安装工作正常(这也适用于任何数据源使用ODBC包装)：

1.设置环境变量

经验法则是，您希望将Netezza驱动程序放在每个环境变量的开头：

DJX_ODBC_LIBRARY_PATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/opt/oemclient/odbc60/64/lib

DB2LIBPATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib

LIBPATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib:/opt/oemclient/odbc60/64/lib

ODBCINI=/home/iidev20/bin/odbc.ini

DB2LIBPATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib:/opt/csdlclient/oracle/lib:/opt/oemclient/odbc60/64/lib:/opt/csdlclient/informix/64/lib

LD_LIBRARY_PATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib:/opt/oemclient/odbc60/64/lib

2.建立相应的odbc.ini网络。

[ODBC]
IANAAppCodePage=4
InstallDir=/opt/ibm/home/bigsql/resources/lib64/
TraceDll=
TraceFile=odbctrace.out
UseCursorLib=0

3.运行db2set

db2set DB2_DJ_INI=/home/iidev20/sqllib/cfg/db2dj.ini
db2set DB2LIBPATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/opt/oemclient/odbc71/64/

4.修改db2dj.ini

  DJX_ODBC_LIBRARY_PATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc 71/64/lib/:/opt/oemclient/odbc60/64/lib

DB2LIBPATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib

LIBPATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib:/opt/oemclient/odbc60/64/lib

ODBCINI=/home/iidev20/bin/odbc.ini

DB2LIBPATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib:/opt/csdlclient/oracle/lib:/opt/oemclient/odbc60/64/lib:/opt/csdlclient/informix/64/lib

LD_LIBRARY_PATH=/opt/ibm/home/bigsql/resources/lib64/:/opt/oemclient/odbc71/64/lib/:/home/iidev20/sqllib/lib:/opt/oemclient/odbc60/64/lib

5.重新启动以使配置有效

Answer 2

不如用流体查询代替？我一直在使用VM的POC上使用它，它工作得很好。它将允许您连接到BI、DB2、Oracle和其他NZ服务器。