Professional Web Applications Themes

summary refresh & deadlock - IBM DB2

Whenever we try to do a summary table refresh, DBAgent.executeQuery(), REFRESH TABLE inst1.product COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "68". SQLSTATE=40001 This doesn't happen with other refreshes. -- Posted via [url]http://dbforums.com[/url]...

  1. #1

    Default summary refresh & deadlock


    Whenever we try to do a summary table refresh,

    DBAgent.executeQuery(), REFRESH TABLE inst1.product
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0911N The
    current transaction has been rolled back because of a deadlock or
    timeout. Reason code "68". SQLSTATE=40001

    This doesn't happen with other refreshes.

    --
    Posted via [url]http://dbforums.com[/url]
    Kota Guest

  2. #2

    Default Re: summary refresh & deadlock

    On Wed, 2 Jul 2003, Kota wrote:
    > Whenever we try to do a summary table refresh,
    >
    > DBAgent.executeQuery(), REFRESH TABLE inst1.product
    > COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL0911N The
    > current transaction has been rolled back because of a deadlock or
    > timeout. Reason code "68". SQLSTATE=40001
    This is a lock timeout, not a deadlock. This means that other
    applications are using your summary table, and thus you can't get the
    required exclusive lock on the table necessary to refresh.

    I would look to see who is causing the lock-wait if you are running in to
    it constantly (get snapshot for locks).


    Good luck,



    -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
    [url]http://www.newsfeeds.com[/url] - The #1 Newsgroup Service in the World!
    -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
    Ian D. Bjorhovde Guest

Similar Threads

  1. Problem with refresh button breaking automatic refresh
    By brian lanning in forum ASP.NET General
    Replies: 0
    Last Post: July 29th, 07:57 PM
  2. Summary fields or Summary table?
    By Scott in forum FileMaker
    Replies: 1
    Last Post: June 27th, 03:34 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139