Re: How to handle deadlocks ?

From: Jcf1111 <jcf1111_at_aol.com>
Date: 1996/06/11
Message-ID: <4plc8u$6kt_at_newsbf02.news.aol.com>#1/1


>Ordering access to the objects in your database is the best way
>to REDUCE dealock, keep transactions as short as possible too.
>To understand why you have a deadlock you can activate two traceflags,
>they will generate a stack in your errorlog with all the details
>(store proc, pages..) about your deadlock.
>Your applications must presume a deadlock can occurs anywhere, thus
>code deadlock processing.

you are right... REDUCE... the sybase manual says deadlocks can't be completely avoided.. so in our applications, we test for a deadlock return code after each call to sybase... then handle it appropriately...

james Received on Tue Jun 11 1996 - 00:00:00 CEST

Original text of this message