Results 1 to 6 of 6
  1. #1
    Join Date
    Mar 2012
    Posts
    9

    Unanswered: When the connection to db2 is open for 5 mins getting the SQL state = 08001 error

    Hi Guys...

    I have a problem.

    When my connection for the DB is idle and open for 5 minutes and in case after 5 minutes I try to perform some action, I get the below error:


    [jcc][t4] [time:2012-03-15-16:01:28.892][thread:main][tracepoint:202] closing non-pooled Transport:
    [jcc][Connection@bd4e3c] DB2 LUWID: GA840370.G82B.C9455606F63A.001A
    [jcc] BEGIN TRACE_DIAGNOSTICS
    [jcc][Thread:main][SQLException@1370ab] java.sql.SQLException
    [jcc][Thread:main][SQLException@1370ab] SQL state = 08001
    [jcc][Thread:main][SQLException@1370ab] Error code = -4499
    [jcc][Thread:main][SQLException@1370ab] Message = [jcc][t4][2030][11211][3.53.95] A communication error occurred during operations on the connection's underlying socket, socket input stream,
    or socket output stream. Error location: Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
    [jcc][Thread:main][SQLException@1370ab] Stack trace follows
    com.ibm.db2.jcc.b.un: [jcc][t4][2030][11211][3.53.95] A communication error occurred during operations on the connection's underlying socket, socket input stream,
    or socket output stream. Error location: Reply.fill(). Message: Insufficient data. ERRORCODE=-4499, SQLSTATE=08001
    at com.ibm.db2.jcc.b.bd.a(bd.java:319)
    at com.ibm.db2.jcc.t4.a.a(a.java:365)
    at com.ibm.db2.jcc.t4.a.a(a.java:360)
    at com.ibm.db2.jcc.t4.ab.b(ab.java:222)
    at com.ibm.db2.jcc.t4.ab.c(ab.java:243)
    at com.ibm.db2.jcc.t4.ab.c(ab.java:354)
    at com.ibm.db2.jcc.t4.ab.v(ab.java:1139)
    at com.ibm.db2.jcc.t4.db.a(db.java:37)
    at com.ibm.db2.jcc.t4.t.a(t.java:32)
    at com.ibm.db2.jcc.t4.sb.h(sb.java:141)
    at com.ibm.db2.jcc.b.gm.bb(gm.java:1933)
    at com.ibm.db2.jcc.b.gm.a(gm.java:2799)
    at com.ibm.db2.jcc.b.gm.a(gm.java:604)
    at com.ibm.db2.jcc.b.gm.executeQuery(gm.java:588)
    at org.eclipse.jface.viewers.EditingSupport.saveCellE ditorValue(EditingSupport.java:109)
    at org.eclipse.jface.viewers.ColumnViewerEditor.saveE ditorValue(ColumnViewerEditor.java:454)
    at org.eclipse.jface.viewers.ColumnViewerEditor.apply EditorValue(ColumnViewerEditor.java:311)
    at org.eclipse.jface.viewers.ColumnViewerEditor$2.app lyEditorValue(ColumnViewerEditor.java:153)
    at org.eclipse.jface.viewers.CellEditor$1****n(CellEd itor.java:333)
    at org.eclipse.core****ntime.SafeRunner****n(SafeRunn er.java:37)
    at org.eclipse.core****ntime.Platform****n(Platform.j ava:880)
    at org.eclipse.ui.internal.JFaceUtil$1****n(JFaceUtil .java:48)
    at org.eclipse.jface.util.SafeRunnable****n(SafeRunna ble.java:175)
    at org.eclipse.jface.viewers.CellEditor.fireApplyEdit orValue(CellEditor.java:331)
    at org.eclipse.jface.viewers.ComboBoxCellEditor.apply EditorValueAndDeactivate(ComboBoxCellEditor.java:2 73)
    at org.eclipse.jface.viewers.ComboBoxCellEditor.focus Lost(ComboBoxCellEditor.java:284)
    at org.eclipse.jface.viewers.ComboBoxCellEditor$4.foc usLost(ComboBoxCellEditor.java:170)
    at org.eclipse.swt.widgets.TypedListener.handleEvent( TypedListener.java:137)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Event Table.java:84)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:1003)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:1027)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:1012)
    at org.eclipse.swt.widgets.Widget.notifyListeners(Wid get.java:770)
    at org.eclipse.swt.custom.CCombo.handleFocus(CCombo.j ava:816)
    at org.eclipse.swt.custom.CCombo$3.handleEvent(CCombo .java:135)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Event Table.java:84)
    at org.eclipse.swt.widgets.Display.filterEvent(Displa y.java:1184)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:1002)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:1027)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:1008)
    at org.eclipse.swt.widgets.Control.sendFocusEvent(Con trol.java:2429)
    at org.eclipse.swt.widgets.Widget.wmSetFocus(Widget.j ava:2266)
    at org.eclipse.swt.widgets.Control.WM_SETFOCUS(Contro l.java:4414)
    at org.eclipse.swt.widgets.Canvas.WM_SETFOCUS(Canvas. java:443)
    at org.eclipse.swt.widgets.Control.windowProc(Control .java:3855)
    at org.eclipse.swt.widgets.Canvas.windowProc(Canvas.j ava:337)
    at org.eclipse.swt.widgets.Display.windowProc(Display .java:4528)
    at org.eclipse.swt.internal.win32.OS.SetFocus(Native Method)
    at org.eclipse.swt.widgets.Control.forceFocus(Control .java:974)
    at org.eclipse.nebula.widgets.grid.Grid.onMouseDown(G rid.java:6208)
    at org.eclipse.nebula.widgets.grid.Grid.access$6(Grid .java:6196)
    at org.eclipse.nebula.widgets.grid.Grid$10.mouseDown( Grid.java:6072)
    at org.eclipse.swt.widgets.TypedListener.handleEvent( TypedListener.java:179)
    at org.eclipse.swt.widgets.EventTable.sendEvent(Event Table.java:84)
    at org.eclipse.swt.widgets.Widget.sendEvent(Widget.ja va:1003)
    at org.eclipse.swt.widgets.Display****nDeferredEvents (Display.java:3823)
    at org.eclipse.swt.widgets.Display.readAndDispatch(Di splay.java:3422)
    at org.eclipse.ui.internal.Workbench****nEventLoop(Wo rkbench.java:2384)
    at org.eclipse.ui.internal.Workbench****nUI(Workbench .java:2348)
    at org.eclipse.ui.internal.Workbench.access$4(Workben ch.java:2200)
    at org.eclipse.ui.internal.Workbench$5****n(Workbench .java:495)
    at org.eclipse.core.databinding.observable.Realm****n WithDefault(Realm.java:288)
    at org.eclipse.ui.internal.Workbench.createAndRunWork bench(Workbench.java:490)
    at org.eclipse.ui.PlatformUI.createAndRunWorkbench(Pl atformUI.java:149)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Native MethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(De legatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.eclipse.equinox.launcher.Main.invokeFramework( Main.java:549)
    at org.eclipse.equinox.launcher.Main.basicRun(Main.ja va:504)
    at org.eclipse.equinox.launcher.Main****n(Main.java:1 236)
    [jcc] END TRACE_DIAGNOSTICS


    Any ideas how to get around this,

    Thanks in advance
    Last edited by ashryar; 03-15-12 at 07:55.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Your connection is getting terminated. You need to figure out how and go from there.

    Andy

  3. #3
    Join Date
    Mar 2012
    Posts
    9
    I would be great if you tell something which I dont know!

  4. #4
    Join Date
    Nov 2011
    Posts
    334
    I think db2 will not close the conneciton positively。。。
    maybe some guys stop the instance mannually。
    OR network was shutdown periodicaly by some settings.....

  5. #5
    Join Date
    Apr 2006
    Location
    Belgium
    Posts
    2,514
    Provided Answers: 11
    for was there are settings for transaction timeout interval - that will force idle connections
    Best Regards, Guy Przytula
    Database Software Consultant
    Good DBAs are not formed in a week or a month. They are created little by little, day by day. Protracted and patient effort is needed to develop good DBAs.
    Spoon feeding : To treat (another) in a way that discourages independent thought or action, as by overindulgence.
    DB2 UDB LUW Certified V7-V8-V9-V9.7-V10.1-V10.5 DB Admin - Advanced DBA -Dprop..
    Information Server Datastage Certified
    http://www.infocura.be

  6. #6
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Quote Originally Posted by ashryar View Post
    I would be great if you tell something which I dont know!
    There are numerous ways that a connection can be terminated. Not knowing your system at all, and not receiving any other information from you, it is impossible that anyone can give you a definitive answer.

    What you need to do is to determine what is causing the connections to be killed and then fix that. You need to look at DB2, OS, networking, client settings, etc. Any one or a combination of them could be causing this.

    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •