Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2008
    Posts
    14

    Unanswered: Db2 Hangs after timeout and other errors

    Hi,
    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.
    TIA
    Kartik

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    What do you mean by "DB2 seems to hang"? Can you take snapshots of the system when this occurs? Is DB2 the only application on the server?

    Andy

  3. #3
    Join Date
    Jun 2008
    Posts
    14
    Thanks for the response :-).
    "Db2 hangs" - stops responding to Client Requests.
    How do I take snapshots of the system?
    Db2 is not the only app on the server, there are a few other workloads.

  4. #4
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Can users connect to the database when it "hangs"?

    Read the manual for taking snapshots, also search this forum in "useful stuff" for a graphical monitor.

    If other applications are using the server, maybe they are having an impact.

    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
  •