Unanswered: Db2 Hangs after timeout and other errors
Have a Winforms App (.net 2.0 on WinXP or Vista)
that talks to a .net Webservice (on IIS6/Win2003R2 SP2 )
that in turn connects to Db2 9.5 on Win2003R2 SP2
using IBM's Data Server Provider 9.5 for .Net
I call stored procs from the Web Service for client Updates. I also have a system task for post-update jobs. This task polls a table that Client Updates, and then runs post update tasks on data. I have some data analysis and cleansing tasks that can run for 5-10 mins and these are called from the same Winforms client by an Admin User.
I find that whenever the client disconnects abruptly, the database seems to hang. E.g. If User closes Winform when time taken is very long, or when a TimeOut occurs.
After the DB hangs, almost nothing can get it right again. I tried shutting the Webserver, the DB2 Instance etc. after hours of trying, it usually starts to work normally again, though I dont have a clue why. Have tried diagnosing in Control Center but not much luck.
Am a Db2 Newbie, and am really foxed by this.
Request help on how to debug this.