Results 1 to 2 of 2

Thread: Timeout problem

  1. #1
    Join Date
    Nov 2009
    Location
    Dusseldorf, Germany
    Posts
    3

    Unanswered: Timeout problem

    Hallo everybody,

    we are using DB2 for LUW V9.1.8.

    We have some trouble with timeout situations like this:

    an application program (using static sql) terminated because of a DB2 timeout (SQLCODE -911, reason code 68) when trying to open this cursor:

    DECLARE WHTR016T-CUR CURSOR WITH HOLD FOR
    SELECT ...
    FROM WHTR016T
    WHERE ...
    ORDER BY BUCHG_ID,
    KURS_ART,
    MASS_ID,
    INSERT_TS
    WITH UR

    When this error occured, no other process accessed the table.

    Does anybody have an idea, why timeouts like this occur?
    Are there other resources (apart from the table) which could have been locked, so that this timeout occured?
    For future timeouts: how do we collect some detailed information about these situations?

    Edit 29.06.2010, 15.09h: I just found out that an automatic rebind of the package took place right after we (successfully) restarted the process. If this rebind was also tried after we started the program the first time, could a non-successful rebind be the reason for this error?

    Thanks in advance and kind regards!


    Frank
    Last edited by stratmf; 06-29-10 at 10:14.

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    You have to figure out who is holding the lock that is causing you timeout. You can use the DB2 monitor program located here: IBM DB2 UDB Performance monitor

    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
  •