Topic
  • 1 reply
  • Latest Post - ‏2014-04-17T08:51:01Z by codefarmer
Andrew_McLauchlan
Andrew_McLauchlan
1 Post

Pinned topic 4499 error connecting to db using data studio 4.1.0.1

‏2014-04-14T01:07:29Z | sql4499

I'm getting an error when connecting to any of the databases defined in Data Studio. I had cataloged and connected successfully via the db2 command window but get errors across the board using Data Studio. The error info is below

Could not connect to DCAPPRDA.

Error creating SQL Model Connection connection to DCAPPRDA. (Error: [jcc][t4][2043][11550][3.67.28] Exception java.net.SocketException: Error opening socket to server Collins/172.24.10.26 on port 50,002 with message: Invalid argument: create. ERRORCODE=-4499, SQLSTATE=08001)

[jcc][t4][2043][11550][3.67.28] Exception java.net.SocketException: Error opening socket to server Collins/172.24.10.26 on port 50,002 with message: Invalid argument: create. ERRORCODE=-4499, SQLSTATE=08001

Error creating JDBC Connection connection to DCAPPRDA. (Error: [jcc][t4][2043][11550][3.67.28] Exception java.net.SocketException: Error opening socket to server Collins/172.24.10.26 on port 50,002 with message: Invalid argument: create. ERRORCODE=-4499, SQLSTATE=08001)

[jcc][t4][2043][11550][3.67.28] Exception java.net.SocketException: Error opening socket to server Collins/172.24.10.26 on port 50,002 with message: Invalid argument: create. ERRORCODE=-4499, SQLSTATE=08001

 

I have also attached the trace file.

Can someone explain why I can't connect?

 

 

Attachments

  • codefarmer
    codefarmer
    1 Post

    Re: 4499 error connecting to db using data studio 4.1.0.1

    ‏2014-04-17T08:51:01Z  

    1.  Check if 50002 is the right port number.

    2. Check if DB2COMM is set to TCPIP with command db2set. If not, try it with following commands:

    db2set DB2COMM=tcpip
    db2stop
    db2start