IBM数据工作室未连接到本地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管理员工具，它可以处理所有这些任务以及备份/恢复，导入/导出等。

我已经为IBM Data Studio听了很多用于DB2的事实上的工具。所以我安装了安装完成后，我无法连接到我的DB2数据库/模式。这是惊喜，因为我很容易通过squirrel-sql& Db-Visualizer，但IBM Data Studio拒绝连接。它在尝试期间给出以下错误。

 完整的消息内容：[jcc] [t4] [2043] [11550] [4.17。 30]异常java.net.SocketException：打开套接字到服务器本地主机/ 127.0.0.1端口50,000与消息：从SOCKS服务器的格式错误的答复。 
 
尝试访问未找到，尚未启动或不支持事务的数据库。 
 
确保系统数据库目录中存在指定的数据库名称。如果数据库名称不存在于系统数据库目录中，则数据库不存在或数据库名称尚未编目。如果需要，请发出db2start命令，然后重新提交当前命令。 SQL4499N发生致命的错误，导致与数据源断开连接。 SQLSTATE：08004 
  

我指定了

 本地：Db2 for Linux，Unix& Windows 
数据库：< mydbname> 
主机：localhost 
端口号：50000 
用户名：db2inst1 
密码：XXXXXX 
默认模式：db2inst1 
  pre> 
 
 
任何人都可以建议连接需要额外的步骤。 
 
 
 
更新：堆栈跟踪的Pastebin链接： http：// pastebin。 com / ySmrFKNV  
 
 
 
更新1：在线搜索DB2论坛的相同问题，有人建议检查系统代理设置。所以是的，我的系统启用了代理设置。但是即使在Ubuntu的Netwrok设置中将代理设置为NONE，问题仍然存在。 
 
 
 
更新2：重新安装Data Studio后问题已解决。不知道什么问题来了，但现在它使用相同的设置。
解决方案
不是一个真正的答案。但是在重新安装Data Studio后问题解决了。不知道有什么问题来了，但现在它使用相同的设置。 
 
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. 

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   
I have specified,
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. 

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

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.  

UPDATE 2 : Issue resolved after reinstallation of Data Studio. No idea what problem came, But now it working with same settings.
解决方案
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数据工作室未连接到本地DB2数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！