我正在ibmbluemix上使用最新版本的“apachehadoop分析”。我按照教程配置odbc驱动程序。http://www-01.ibm.com/support/knowledgecenter/sspt3x_4.0.0/com.ibm.swg.im.infosphere.biginsights.analyze.doc/doc/bsql_odbc_windows.html
我已经下载了10.5数据服务器驱动程序包并配置了db2dsdriver.cfg。
<configuration>
<dsncollection>
<dsn alias="bigsql" name="bigsql" host="bi-hadoop-prod-2208.services.dal.bluemix.net" port="51000"/>
</dsncollection>
<databases>
<database name="bigsql" host="bi-hadoop-prod-2208.services.dal.bluemix.net" port="51000">
</database>
</databases>
</configuration>这是我的服务器信息
"userid": "xxxxxx",
"password": "xxxxx",
"BigSqlUrl": "jdbc:db2://bi-hadoop-prod-2208.services.dal.bluemix.net:51000/bigsql;sslConnection=true",当我尝试使用db2cli验证连接时，得到：
[FAILED]: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/ IP". Communication API being used: "SOCKETS". Location where the error was detected:"169.54.58.208". Communication function detecting the error: "recv". Protocol specific error code(s): "10054", "*", "0". SQLSTATE=08001有人遇到同样的问题吗？
1条答案
按热度按时间1dkrff031#
您能简单地检查一下您是否能够访问服务器bi-hadoop-prod-2208.services.dal.bluemix.net上的端口51000吗？例如，您可以运行这样的telnet
telnet bi-hadoop-prod-2208.services.dal.bluemix.net 51000
这些错误似乎与连接错误有关，例如无法将服务器连接到防火墙、端口被阻止等等。