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

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
    ACCEPTED ANSWER

    Re: IBM data studio ping failed

    ‏2010-03-23T02:53:37Z  in response to softgeek
    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
      ACCEPTED ANSWER

      Re: IBM data studio ping failed

      ‏2010-03-23T04:01:45Z  in response to gopalv
      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
    ACCEPTED ANSWER

    Re: IBM data studio ping failed

    ‏2010-03-23T05:27:37Z  in response to softgeek
    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
      ACCEPTED ANSWER

      Re: IBM data studio ping failed

      ‏2010-03-23T15:22:48Z  in response to SystemAdmin
      Hi,

      I have attached the screen shot
      • SystemAdmin
        SystemAdmin
        1632 Posts
        ACCEPTED ANSWER

        Re: IBM data studio ping failed

        ‏2010-03-23T15:42:31Z  in response to softgeek
        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
          ACCEPTED ANSWER

          Re: IBM data studio ping failed

          ‏2010-03-23T16:23:41Z  in response to SystemAdmin
          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
            ACCEPTED ANSWER

            Re: IBM data studio ping failed

            ‏2011-04-22T05:57:18Z  in response to softgeek
            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
              23 Posts
              ACCEPTED ANSWER

              Re: IBM data studio ping failed

              ‏2011-04-22T22:36:33Z  in response to SM11_tabassum_m
              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
                ACCEPTED ANSWER

                Re: IBM data studio ping failed

                ‏2012-06-13T08:48:37Z  in response to ledezma@us.ibm.com
                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
                  ACCEPTED ANSWER

                  Re: IBM data studio ping failed

                  ‏2012-06-13T14:13:19Z  in response to SystemAdmin
                  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
                    ACCEPTED ANSWER

                    Re: IBM data studio ping failed

                    ‏2012-06-21T13:34:38Z  in response to Ivan_CA
                    Did the last suggestion help? Please let us know if you still have any problems.

                    Thanks,
                    Ivan
  • SystemAdmin
    SystemAdmin
    1632 Posts
    ACCEPTED ANSWER

    Re: IBM data studio ping failed

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

    -Vinod
    • CQN4_Andrey_Naminov
      CQN4_Andrey_Naminov
      1 Post
      ACCEPTED ANSWER

      Re: IBM data studio ping failed

      ‏2012-09-29T17:01:13Z  in response to SystemAdmin
      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!