IBM Data Studio 未连接到本地 DB2 数据库 [英] IBM data studio not connecting to local DB2 databases

问题描述

我在本地 Ubuntu 12.04 机器上安装了 DB2 10.5 版本.现在我需要一个 GUI.我已经尝试过 squirrel-sql &Db-Visualizer.虽然 Db-Visualizer 为我提供了仅查看的数据库结构，但 squirrel-sql 为我提供了更多管理选项.但现在我需要一个 DB2 管理员工具，它可以处理所有这些任务以及备份/恢复、导入/导出等.

I have installed DB2 10.5 version on my local Ubuntu 12.04 Machine. Now i need a GUI. I already tried squirrel-sql & Db-Visualizer. While Db-Visualizer give me the view-only database structure, squirrel-sql give me some more options to manage. But now I need a DB2 administrator tool, which can handle all this tasks plus backup/restore, import/export etc.

我听了很多关于 IBM Data Studio 作为 DB2 的事实上的工具.所以我安装了它.安装完成后，我无法连接到我的 DB2 数据库/模式.令人惊讶的是，我很容易通过 squirrel-sql & 连接我的数据库.Db-Visualizer 但 IBM Data Studio 拒绝连接.在尝试期间它会出现以下错误.

I have listen a lot for IBM Data Studio as de-facto tool for DB2. So I installed it. After install completion, I am unable connect to my DB2 databases/schemas. It is surprise As I am easily can connect my Dbs through squirrel-sql & Db-Visualizer but IBM Data Studio refuse to connect. It give following errors during try.

Full message content: [jcc][t4][2043][11550][4.17.30] Exception java.net.SocketException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Malformed reply from SOCKS server.

An attempt was made to access a database that was not found, has not been started, or does not support transactions.

Ensure that the specified database name exists in the system database directory. If the database name does not exist in the system database directory, either the database does not exist or the database name has not been cataloged. If needed, issue a db2start command and then resubmit the current command. SQL4499N A fatal error occurred that resulted in a disconnect from the data source. SQLSTATE: 08004   

我已经指定了，

Local : Db2 for Linux, Unix & Windows
Database : <mydbname>
Host : localhost
Port Number : 50000
UserName : db2inst1
Password : XXXXXX
Default Schema : db2inst1

任何人都可以建议是否需要额外的步骤来连接.

Anybody can suggest if extra steps needed to connect.

更新:堆栈跟踪的 Pastebin 链接:http://pastebin.com/ySmrFKNV

UPDATE : Pastebin Link for Stack Trace : http://pastebin.com/ySmrFKNV

更新 1:在线搜索 DB2 论坛是否存在相同问题，有人建议检查系统代理设置.所以是的，我的系统启用了代理设置.但即使在 Ubuntu 的网络设置中将代理设置为 NONE 后，问题仍然存在.

UPDATE 1 : Search online for DB2 forums for same problem, Somebody suggested to check system proxy settings. So yes, My system have proxy settings enabled. But even after set proxy to NONE in Netwrok Settings in Ubuntu, problem still persists.

更新 2:重新安装 Data Studio 后问题已解决.不知道出现了什么问题，但现在它可以使用相同的设置.

UPDATE 2 : Issue resolved after reinstallation of Data Studio. No idea what problem came, But now it working with same settings.

推荐答案

不是一个真正的答案.但重新安装 Data Studio 后问题解决.不知道出现了什么问题，但现在它使用相同的设置.

Not really a answer. But issue resolved after re-installation of Data Studio. No idea what problem came, But now it working with same settings.

这篇关于IBM Data Studio 未连接到本地 DB2 数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！