Topic
  • 13 replies
  • Latest Post - ‏2012-09-29T17:01:13Z by CQN4_Andrey_Naminov
softgeek
softgeek
8 Posts

Pinned topic IBM data studio ping failed

‏2010-03-23T02:13:57Z |
org.eclipse.datatools.connectivity.exceptions.DBNotStartException: No start database command was issued. ErrorCode = -4499, SQLState = 08001.
at com.ibm.datatools.db2.JDBCDB2AliasJDBCConnection.getConnectException(JDBCDB2AliasJDBCConnection.java:74)
at org.eclipse.datatools.connectivity.ui.PingJob.getTestConnectionException(PingJob.java:81)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:63)
at org.eclipse.core.internal.jobs.Worker.run(Worker.java:55)
Caused by: com.ibm.db2.jcc.am.io: jcct4204311550http://3.58.81 Exception java.net.ConnectException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Connection refused: connect. ERRORCODE=-4499, SQLSTATE=08001
at com.ibm.db2.jcc.am.ed.a(ed.java:319)
at com.ibm.db2.jcc.am.ed.a(ed.java:337)
at com.ibm.db2.jcc.t4.zb.a(zb.java:378)
at com.ibm.db2.jcc.t4.zb.<init>(zb.java:76)
at com.ibm.db2.jcc.t4.a.y(a.java:306)
at com.ibm.db2.jcc.t4.b.a(b.java:1796)
at com.ibm.db2.jcc.am.jb.a(jb.java:573)
at com.ibm.db2.jcc.am.jb.<init>(jb.java:524)
at com.ibm.db2.jcc.t4.b.<init>(b.java:305)
at com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(DB2SimpleDataSource.java:214)
at com.ibm.db2.jcc.DB2Driver.connect(DB2Driver.java:456)
at org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(JDBCConnection.java:89)
at org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(DriverConnectionBase.java:104)
at org.eclipse.datatools.connectivity.DriverConnectionBase.open(DriverConnectionBase.java:53)
at com.ibm.datatools.db2.JDBCDB2AliasConnectionFactory.createConnection(JDBCDB2AliasConnectionFactory.java:25)
at org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(ConnectionFactoryProvider.java:83)
at org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(ConnectionProfile.java:355)
at org.eclipse.datatools.connectivity.ui.PingJob.createTestConnection(PingJob.java:76)
at org.eclipse.datatools.connectivity.ui.PingJob.run(PingJob.java:59)
... 1 more
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:352)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:214)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:201)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:377)
at java.net.Socket.connect(Socket.java:530)
at com.ibm.db2.jcc.t4.ab.run(ab.java:34)
at java.security.AccessController.doPrivileged(AccessController.java:251)
at com.ibm.db2.jcc.t4.zb.a(zb.java:372)
... 17 more
Updated on 2012-09-29T17:01:13Z at 2012-09-29T17:01:13Z by CQN4_Andrey_Naminov
  • gopalv
    gopalv
    25 Posts

    Re: IBM data studio ping failed

    ‏2010-03-23T02:53:37Z  
    Hi,

    Not sure what you are trying to say. If the instance is up (a start dbm command is issued), the ping succeeds.
    If the instance is down, then you get a "ping failed" display and the exception is shown in the details. Is this not an acceptable behavior?

    Venkatesh.
  • softgeek
    softgeek
    8 Posts

    Re: IBM data studio ping failed

    ‏2010-03-23T04:01:45Z  
    • gopalv
    • ‏2010-03-23T02:53:37Z
    Hi,

    Not sure what you are trying to say. If the instance is up (a start dbm command is issued), the ping succeeds.
    If the instance is down, then you get a "ping failed" display and the exception is shown in the details. Is this not an acceptable behavior?

    Venkatesh.
    yes i have issued the command it is giving the message like following


    Commands Entered
    start dbm;

    start dbm
    SQL1026N The database manager is already active.

    SQL1026N The database manager is already active.

    Explanation:

    The start command was not processed because the database manager is
    already started.

    User response:

    The database manager is started, so database applications can continue.
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: IBM data studio ping failed

    ‏2010-03-23T05:27:37Z  
    Hi,
    Can you give us a screen shot of your connection's driver properties? Or give us the values of:
    Location / Database, Host, Port and connection url. Include also the driver name. Thanks.
  • softgeek
    softgeek
    8 Posts

    Re: IBM data studio ping failed

    ‏2010-03-23T15:22:48Z  
    Hi,
    Can you give us a screen shot of your connection's driver properties? Or give us the values of:
    Location / Database, Host, Port and connection url. Include also the driver name. Thanks.
    Hi,

    I have attached the screen shot
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: IBM data studio ping failed

    ‏2010-03-23T15:42:31Z  
    • softgeek
    • ‏2010-03-23T15:22:48Z
    Hi,

    I have attached the screen shot
    I forgot to ask for this too.
    Please issue a "db2set -all" from a command window and cut and paste the info here. I'm just gathering info in order to isolate the problem. Thanks.
  • softgeek
    softgeek
    8 Posts

    Re: IBM data studio ping failed

    ‏2010-03-23T16:23:41Z  
    I forgot to ask for this too.
    Please issue a "db2set -all" from a command window and cut and paste the info here. I'm just gathering info in order to isolate the problem. Thanks.
    here the info
    Microsoft Windows XP http://Version 5.1.2600
    (C) Copyright 1985-2001 Microsoft Corp.

    D:\Documents and Settings\SRIKANTH>db2set -all
    [e] DB2PATH=D:\Program Files\IBM\SQLLIB
    [i] DB2PROCESSORS=0,1
    [i] DB2INSTPROF=D:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2
    COPY1
    [i] DB2COMM=TCPIP
    [g] DB2_EXTSECURITY=YES
    [g] DB2SYSTEM=VANAM-XP
    [g] DB2PATH=D:\Program Files\IBM\SQLLIB
    [g] DB2INSTDEF=DB2
    [g] DB2ADMINSERVER=DB2DAS00

    Thanks.
  • SM11_tabassum_m
    SM11_tabassum_m
    1 Post

    Re: IBM data studio ping failed

    ‏2011-04-22T05:57:18Z  
    • softgeek
    • ‏2010-03-23T16:23:41Z
    here the info
    Microsoft Windows XP http://Version 5.1.2600
    (C) Copyright 1985-2001 Microsoft Corp.

    D:\Documents and Settings\SRIKANTH>db2set -all
    [e] DB2PATH=D:\Program Files\IBM\SQLLIB
    [i] DB2PROCESSORS=0,1
    [i] DB2INSTPROF=D:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2
    COPY1
    [i] DB2COMM=TCPIP
    [g] DB2_EXTSECURITY=YES
    [g] DB2SYSTEM=VANAM-XP
    [g] DB2PATH=D:\Program Files\IBM\SQLLIB
    [g] DB2INSTDEF=DB2
    [g] DB2ADMINSERVER=DB2DAS00

    Thanks.
    I am also getting the same error while connecting a database.
    When i issue db2set -all command I got following message
    C:\Program Files\IBM\SQLLIB\BIN>db2set -all
    [e] DB2PATH=C:\Program Files\IBM\SQLLIB
    [i] DB2PROCESSORS=0
    [i] DB2INSTPROF=C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2
    COPY1
    [i] DB2COMM=TCPIP
    [g] DB2_COMPATIBILITY_VECTOR=MYS
    [g] DB2_EXTSECURITY=NO
    [g] DB2SYSTEM=ABC-3B85911925C
    [g] DB2PATH=C:\Program Files\IBM\SQLLIB
    [g] DB2INSTDEF=DB201
    [g] DB2CLIINIPATH=C:\Program Files\IBM\SQLLIB
    [g] DB2ADMINSERVER=DB2DAS00

    C:\Program Files\IBM\SQLLIB\BIN>

    How to solve this problem?
  • ledezma@us.ibm.com
    ledezma@us.ibm.com
    24 Posts

    Re: IBM data studio ping failed

    ‏2011-04-22T22:36:33Z  
    I am also getting the same error while connecting a database.
    When i issue db2set -all command I got following message
    C:\Program Files\IBM\SQLLIB\BIN>db2set -all
    [e] DB2PATH=C:\Program Files\IBM\SQLLIB
    [i] DB2PROCESSORS=0
    [i] DB2INSTPROF=C:\Documents and Settings\All Users\Application Data\IBM\DB2\DB2
    COPY1
    [i] DB2COMM=TCPIP
    [g] DB2_COMPATIBILITY_VECTOR=MYS
    [g] DB2_EXTSECURITY=NO
    [g] DB2SYSTEM=ABC-3B85911925C
    [g] DB2PATH=C:\Program Files\IBM\SQLLIB
    [g] DB2INSTDEF=DB201
    [g] DB2CLIINIPATH=C:\Program Files\IBM\SQLLIB
    [g] DB2ADMINSERVER=DB2DAS00

    C:\Program Files\IBM\SQLLIB\BIN>

    How to solve this problem?
    If the database manager has been started, it is possible that it is listening on a port different than the default 50000 and this may cause the error you are seeing. This may happen if there are multiple DB2 instances on the same machine or possibly if DB2 was uninstalled and reinstalled.

    To check the port, issue the following configuration command on the CLP:

    C:\Program Files\IBM\SQLLIB\BIN>db2 get dbm config

    Reference: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0001955.html

    In the output, look for the TCP/IP Service name. For example:

    TCP/IP Service name (SVCENAME) = db2c_DB2

    To determine what db2c_DB2 maps to, go to the file C:\WINDOWS\system32\drivers\etc\services.

    The mapping is defined, something like the following, indicating the port number that DB2 is listening on:

    db2c_DB2 50000/tcp

    In Data Studio, if the connection profile for the alias port number does not match this port, it is possible that the alias was created for another DB2 instance and it may no longer be valid.

    You can always create your own connection profile in Data Studio by using the New Connection Wizard. In the dialog, enter the updated port number along with the additional required properties. The New Connection Wizard can be invoked from the menu tool bar as shown in the attached snapshot.

    Thanks.
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: IBM data studio ping failed

    ‏2011-06-28T18:30:48Z  
    Are you still having issues with this? If not, can you please close this thread?

    -Vinod
  • SystemAdmin
    SystemAdmin
    1632 Posts

    Re: IBM data studio ping failed

    ‏2012-06-13T08:48:37Z  
    If the database manager has been started, it is possible that it is listening on a port different than the default 50000 and this may cause the error you are seeing. This may happen if there are multiple DB2 instances on the same machine or possibly if DB2 was uninstalled and reinstalled.

    To check the port, issue the following configuration command on the CLP:

    C:\Program Files\IBM\SQLLIB\BIN>db2 get dbm config

    Reference: http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp?topic=/com.ibm.db2.luw.admin.cmd.doc/doc/r0001955.html

    In the output, look for the TCP/IP Service name. For example:

    TCP/IP Service name (SVCENAME) = db2c_DB2

    To determine what db2c_DB2 maps to, go to the file C:\WINDOWS\system32\drivers\etc\services.

    The mapping is defined, something like the following, indicating the port number that DB2 is listening on:

    db2c_DB2 50000/tcp

    In Data Studio, if the connection profile for the alias port number does not match this port, it is possible that the alias was created for another DB2 instance and it may no longer be valid.

    You can always create your own connection profile in Data Studio by using the New Connection Wizard. In the dialog, enter the updated port number along with the additional required properties. The New Connection Wizard can be invoked from the menu tool bar as shown in the attached snapshot.

    Thanks.
    I have the same problem and when I used
    "db2 get dbm config"

    the TCP/IP Service name was empty

    what should I do ?
  • Ivan_CA
    Ivan_CA
    52 Posts

    Re: IBM data studio ping failed

    ‏2012-06-13T14:13:19Z  
    I have the same problem and when I used
    "db2 get dbm config"

    the TCP/IP Service name was empty

    what should I do ?
    One way of fixing this is:

    1.db2stop
    2.db2set (make sure you see DB2COMM=TCPIP)
    3.db2 update dbm cfg using SVCENAME 50000 (Assuming there are no instances in the same machine)
    4.db2start
    After this, you should be able to create a database and/or connect to any database in this instance using Data Studio.

    Thanks,
    Ivan
  • Ivan_CA
    Ivan_CA
    52 Posts

    Re: IBM data studio ping failed

    ‏2012-06-21T13:34:38Z  
    • Ivan_CA
    • ‏2012-06-13T14:13:19Z
    One way of fixing this is:

    1.db2stop
    2.db2set (make sure you see DB2COMM=TCPIP)
    3.db2 update dbm cfg using SVCENAME 50000 (Assuming there are no instances in the same machine)
    4.db2start
    After this, you should be able to create a database and/or connect to any database in this instance using Data Studio.

    Thanks,
    Ivan
    Did the last suggestion help? Please let us know if you still have any problems.

    Thanks,
    Ivan
  • CQN4_Andrey_Naminov
    CQN4_Andrey_Naminov
    1 Post

    Re: IBM data studio ping failed

    ‏2012-09-29T17:01:13Z  
    Are you still having issues with this? If not, can you please close this thread?

    -Vinod
    Hello,

    I've faced with the same problem:
    my instance had been started, but eclipse/data studio couldn't get connection with the same error message:
    "org.eclipse.datatools.connectivity.exceptions.DBNotStartException: No start database command was issued. ErrorCode = -4499, SQLState = 08001."

    I performed Ivan CA's way of fixing this:
    1.db2stop
    2.db2set (make sure you see DB2COMM=TCPIP)
    3.db2 update dbm cfg using SVCENAME 50000 (Assuming there are no instances in the same machine)
    4.db2start

    result:
    "connection succeeded"

    Thank you, Ivan CA!