Topic
3 replies Latest Post - ‏2012-12-04T06:46:44Z by IrisWang
SystemAdmin
SystemAdmin
1632 Posts
ACCEPTED ANSWER

Pinned topic Data Studio showing localhost with port -1

‏2012-12-03T18:26:42Z |
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.
Updated on 2012-12-04T06:46:44Z at 2012-12-04T06:46:44Z by IrisWang
  • loicjulien
    loicjulien
    96 Posts
    ACCEPTED ANSWER

    Re: Data Studio showing localhost with port -1

    ‏2012-12-03T18:32:15Z  in response to SystemAdmin
    Hi,

    Please take a look at this thread as this may help you: http://www.ibm.com/developerworks/forums/thread.jspa?threadID=453678&tstart=75

    ~Loic
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: Data Studio showing localhost with port -1

    ‏2012-12-03T18:33:48Z  in response to SystemAdmin
    BTW, 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
    IrisWang
    5 Posts
    ACCEPTED ANSWER

    Re: Data Studio showing localhost with port -1

    ‏2012-12-04T06:46:44Z  in response to SystemAdmin
    Hello,

    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.
    http://www.ibm.com/developerworks/forums/thread.jspa?threadID=453678&tstart=75

    When all of configuration can be set correctly, please launch Data Studio with new workspace.

    Hope that it can help you!

    Iris