API tools faq
paste
Advertisement
Guest User

DB2 connect trace

a guest
Aug 12th, 2014
756
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 9.07 KB | None | 0 0
raw download clone embed print report
  1. <pre>A connection attempt was unsuccessful.
  2.  
  3. Summary
  4.  
  5. SQL4499N  A fatal error occurred that resulted in a disconnect from the data source.
  6.  
  7. Try the following suggestions to help solve the problem:
  8.  
  9. Ensure that the data server has been started.
  10. Check that the database name used is the actual database name and not an alias name.
  11. Check that the host is a valid name or IP address, and that the port number is valid for communication with the data server.
  12. To further diagnose the problem, return to the Properties section and use the Tracing page to enable tracing. Contact the database administrator and provide the trace and other support information available.
  13. Full message content: [jcc][t4][2043][11550][4.17.30] Exception java.net.SocketException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Malformed reply from SOCKS server.
  14.  
  15. Explanation
  16.  
  17. <b>Explanation:</b><br/><br/>An attempt was made to access a database that was not found, has not been started, or does not support transactions.
  18. <br/><b>User response:</b><br/><br/>Ensure that the specified database name exists in the system database directory. If the database name does not exist in the system database directory, either the database does not exist or the database name has not been cataloged. If needed, issue a db2start command and then resubmit the current command.
  19. SQLSSTATE: 08004
  20.  
  21. Support
  22.  
  23. Connection Properties
  24.  
  25. Database : missio
  26. URL :  jdbc:db2://localhost:50000/missio:retrieveMessagesFromServerOnGetMessage=true;
  27. User name : db2inst1
  28. Password : (Not Shown)
  29.  
  30. Environment
  31.  
  32. Driver class name = com.ibm.db2.jcc.DB2Driver
  33. Driver version = 4.17.30
  34. Driver JAR file path = /home/kuldeep/IBM/SDPShared/plugins/com.ibm.datatools.db2_2.2.0.v20131115_1748/driver/db2jcc4.jar:/home/kuldeep/IBM/SDPShared/plugins/com.ibm.datatools.db2_2.2.0.v20131115_1748/driver/db2jcc_license_cisuz.jar
  35. Operating system name = Linux
  36. Operating system architecture = amd64
  37. Operating system version = 3.2.0-67-generic
  38. JVM implementation vendor = IBM Corporation
  39. JVM runtime = Java(TM) SE Runtime Environment
  40. Java version = JRE 1.7.0 IBM J9 2.6 Linux amd64-64 Compressed References 20130617_152572 (JIT enabled, AOT enabled)
  41. J9VM - R26_Java726_SR5_20130617_1436_B152572
  42. JIT  - r11.b04_20130528_38954ifx1
  43. GC   - R26_Java726_SR5_20130617_1436_B152572_CMPRSS
  44. J9CL - 20130617_152572
  45. Launcher = /home/kuldeep/IBM/DS4.1.0.1/eclipse
  46.  
  47. Stack Trace
  48.  
  49. com.ibm.db2.jcc.am.DisconnectNonTransientConnectionException: [jcc][t4][2043][11550][4.17.30] Exception java.net.SocketException: Error opening socket to server localhost/127.0.0.1 on port 50,000 with message: Malformed reply from SOCKS server. ERRORCODE=-4499, SQLSTATE=08001com.ibm.db2.jcc.am.hd.a(Unknown Source)
  50. com.ibm.db2.jcc.am.hd.a(Unknown Source)
  51. com.ibm.db2.jcc.t4.yb.a(Unknown Source)
  52. com.ibm.db2.jcc.t4.yb.<init>(Unknown Source)
  53. com.ibm.db2.jcc.t4.a.b(Unknown Source)
  54. com.ibm.db2.jcc.t4.b.newAgent_(Unknown Source)
  55. com.ibm.db2.jcc.am.Connection.initConnection(Unknown Source)
  56. com.ibm.db2.jcc.am.Connection.<init>(Unknown Source)
  57. com.ibm.db2.jcc.t4.b.<init>(Unknown Source)
  58. com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(Unknown Source)
  59. com.ibm.db2.jcc.DB2SimpleDataSource.getConnection(Unknown Source)
  60. com.ibm.db2.jcc.DB2Driver.connect(Unknown Source)
  61. com.ibm.db2.jcc.DB2Driver.connect(Unknown Source)
  62. org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.createConnection(Unknown Source)
  63. org.eclipse.datatools.connectivity.DriverConnectionBase.internalCreateConnection(Unknown Source)
  64. org.eclipse.datatools.connectivity.DriverConnectionBase.open(Unknown Source)
  65. org.eclipse.datatools.connectivity.drivers.jdbc.JDBCConnection.open(Unknown Source)
  66. org.eclipse.datatools.enablement.ibm.db2.internal.luw.JDBCLUWConnectionFactory.createConnection(Unknown Source)
  67. org.eclipse.datatools.connectivity.internal.ConnectionFactoryProvider.createConnection(Unknown Source)
  68. org.eclipse.datatools.connectivity.internal.ConnectionProfile.createConnection(Unknown Source)
  69. com.ibm.datatools.connection.internal.ui.databases.NewDatabaseConnnectionWizardPage.handleTestConnection(Unknown Source)
  70. com.ibm.datatools.connection.internal.ui.databases.NewDatabaseConnnectionWizardPage.getNextPage(Unknown Source)
  71. org.eclipse.jface.wizard.WizardDialog.nextPressed(Unknown Source)
  72. org.eclipse.jface.wizard.WizardDialog.buttonPressed(Unknown Source)
  73. org.eclipse.jface.dialogs.Dialog$2.widgetSelected(Unknown Source)
  74. org.eclipse.swt.widgets.TypedListener.handleEvent(Unknown Source)
  75. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
  76. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
  77. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
  78. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
  79. org.eclipse.jface.window.Window.runEventLoop(Unknown Source)
  80. org.eclipse.jface.window.Window.open(Unknown Source)
  81. com.ibm.datatools.connection.internal.ui.databases.actions.NewDBConnectionHandler.execute(Unknown Source)
  82. com.ibm.datatools.common.ui.dialogs.ExistingJDBCConnectionsWizardPage$ExistingJDBCConnectionProfilesDialogPage.newConnection(Unknown Source)
  83. org.eclipse.datatools.connectivity.ui.dse.dialogs.ExistingConnectionProfilesDialogPage.handleEvent(Unknown Source)
  84. com.ibm.datatools.common.ui.dialogs.ExistingJDBCConnectionsWizardPage$ExistingJDBCConnectionProfilesDialogPage.handleEvent(Unknown Source)
  85. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
  86. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
  87. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
  88. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
  89. org.eclipse.jface.window.Window.runEventLoop(Unknown Source)
  90. org.eclipse.jface.window.Window.open(Unknown Source)
  91. com.ibm.datatools.quick.launch.ui.adm.handler.LaunchDBConnection.execute(Unknown Source)
  92. org.eclipse.ui.internal.handlers.HandlerProxy.execute(Unknown Source)
  93. org.eclipse.ui.internal.handlers.E4HandlerProxy.execute(Unknown Source)
  94. sun.reflect.GeneratedMethodAccessor37.invoke(Unknown Source)
  95. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  96. java.lang.reflect.Method.invoke(Unknown Source)
  97. org.eclipse.e4.core.internal.di.MethodRequestor.execute(Unknown Source)
  98. org.eclipse.e4.core.internal.di.InjectorImpl.invokeUsingClass(Unknown Source)
  99. org.eclipse.e4.core.internal.di.InjectorImpl.invoke(Unknown Source)
  100. org.eclipse.e4.core.contexts.ContextInjectionFactory.invoke(Unknown Source)
  101. org.eclipse.e4.core.commands.internal.HandlerServiceImpl.executeHandler(Unknown Source)
  102. org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(Unknown Source)
  103. org.eclipse.ui.internal.handlers.LegacyHandlerService.executeCommand(Unknown Source)
  104. com.ibm.datatools.quick.launch.ui.actions.GenericCommandAction.execute(Unknown Source)
  105. com.ibm.datatools.quick.launch.ui.actions.AbstractCommandHandlerAction.run(Unknown Source)
  106. com.ibm.datatools.quick.launch.ui.internal.core.QuickLaunchSolutionManager$UseCase$1.run(Unknown Source)
  107. com.ibm.datatools.quick.launch.ui.internal.editor.QuickLaunchEditor$SolutionsPage$3.linkActivated(Unknown Source)
  108. org.eclipse.ui.forms.widgets.AbstractHyperlink.handleActivate(Unknown Source)
  109. org.eclipse.ui.forms.widgets.AbstractHyperlink.handleMouseUp(Unknown Source)
  110. org.eclipse.ui.forms.widgets.AbstractHyperlink.access$2(Unknown Source)
  111. org.eclipse.ui.forms.widgets.AbstractHyperlink$4.handleEvent(Unknown Source)
  112. org.eclipse.swt.widgets.EventTable.sendEvent(Unknown Source)
  113. org.eclipse.swt.widgets.Widget.sendEvent(Unknown Source)
  114. org.eclipse.swt.widgets.Display.runDeferredEvents(Unknown Source)
  115. org.eclipse.swt.widgets.Display.readAndDispatch(Unknown Source)
  116. org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine$9.run(Unknown Source)
  117. org.eclipse.core.databinding.observable.Realm.runWithDefault(Unknown Source)
  118. org.eclipse.e4.ui.internal.workbench.swt.PartRenderingEngine.run(Unknown Source)
  119. org.eclipse.e4.ui.internal.workbench.E4Workbench.createAndRunUI(Unknown Source)
  120. org.eclipse.ui.internal.Workbench$5.run(Unknown Source)
  121. org.eclipse.core.databinding.observable.Realm.runWithDefault(Unknown Source)
  122. org.eclipse.ui.internal.Workbench.createAndRunWorkbench(Unknown Source)
  123. org.eclipse.ui.PlatformUI.createAndRunWorkbench(Unknown Source)
  124. org.eclipse.ui.internal.ide.application.IDEApplication.start(Unknown Source)
  125. org.eclipse.equinox.internal.app.EclipseAppHandle.run(Unknown Source)
  126. org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.runApplication(Unknown Source)
  127. org.eclipse.core.runtime.internal.adaptor.EclipseAppLauncher.start(Unknown Source)
  128. org.eclipse.core.runtime.adaptor.EclipseStarter.run(Unknown Source)
  129. org.eclipse.core.runtime.adaptor.EclipseStarter.run(Unknown Source)
  130. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  131. sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
  132. sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
  133. java.lang.reflect.Method.invoke(Unknown Source)
  134. org.eclipse.equinox.launcher.Main.invokeFramework(Unknown Source)
  135. org.eclipse.equinox.launcher.Main.basicRun(Unknown Source)
  136. org.eclipse.equinox.launcher.Main.run(Unknown Source)
  137. org.eclipse.equinox.launcher.Main.main(Unknown Source)
  138. </pre>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!