I have 64 bit DB2 Express installed on my machine running Win7.
When I try to browse the db instances, in Data Studio, in the explorer pane, I see:
All Databases -> localhost -> -1
Where -1 appears to be the port.
When I try to connect to any db on this port there is an error saying the port is out of range.
I created the Sample db on DB2 installation and specified port 50000.
When I try to create a new db connection to this db on this port I get the following error:
Full message content: jcct4204311550http://4.13.111 Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect.
It seems either something is not correct with the installation of db2 or datastudio has trouble connecting to it even when it's running and a db exists.
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
3 replies Latest Post - 2012-12-04T06:46:44Z by IrisWang
Pinned topic Data Studio showing localhost with port -1
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-04T06:46:44Z at 2012-12-04T06:46:44Z by IrisWang
loicjulien 2700007DEB96 Posts
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: Data Studio showing localhost with port -12012-12-03T18:33:48Z in response to SystemAdminBTW, I was reviewing the user guide someone posted earlier and clearly when Data Studio starts up, the default port is 50000, so I'm trying to understand why mine shows -1. Also, I try uninstalling and resinstalling, thinking I might have missed a step somewhere, but the same issues keeps occurring.
IrisWang 270000QH765 PostsACCEPTED ANSWER
Re: Data Studio showing localhost with port -12012-12-04T06:46:44Z in response to SystemAdminHello,
I have hit same problems on two machines before and the root cause was incorrect configuration of TCP/IP or SVCENAME of DB2 server on the machine.
So please follow Loic guide to configure your TCP/IP or SVCENAME of your DB2 environment.
When all of configuration can be set correctly, please launch Data Studio with new workspace.
Hope that it can help you!