DEADLOCK

Is there any possibility to force a deadlock priority
higher than normal? what I want is to keep my process
running and not to be chosen as deadlock victim, no matter
what. Put different, I want to know if there is a way to
overwrite the default deadlock-handling method.
Set DEADLOCK_PRIORITY is not to clearly explained in Books
Online from this point of view.
thank youGabriela,
Sorry, there is not. (Have you emailed sqlwish?)
DEADLOCK_PRIORITY is used to make a process _more_ likely to be the victim.
You can use that on other processes to try to preserve your process, but it
is (IMHO) a bit of a Red Queen's Race to try to make every other transaction
have a lower priority than yours.
When this has been a serious problem, we have had to write the code in a
process to be restartable. E.g. Keep state information in a table, in case
of a being victimized by a deadlock, the client restarts the process which
reads the state and skips to that point to continue processing.
Russell Fields
"Gabriela" <gnanau@.cstonecanada.com> wrote in message
news:0d3201c394b9$76e81e10$a301280a@.phx.gbl...
> Is there any possibility to force a deadlock priority
> higher than normal? what I want is to keep my process
> running and not to be chosen as deadlock victim, no matter
> what. Put different, I want to know if there is a way to
> overwrite the default deadlock-handling method.
> Set DEADLOCK_PRIORITY is not to clearly explained in Books
> Online from this point of view.
> thank you|||I was affraid that this would be the answer.Thank you
anyway
>--Original Message--
>Gabriela,
>Sorry, there is not. (Have you emailed sqlwish?)
>DEADLOCK_PRIORITY is used to make a process _more_ likely
to be the victim.
>You can use that on other processes to try to preserve
your process, but it
>is (IMHO) a bit of a Red Queen's Race to try to make
every other transaction
>have a lower priority than yours.
>When this has been a serious problem, we have had to
write the code in a
>process to be restartable. E.g. Keep state information in
a table, in case
>of a being victimized by a deadlock, the client restarts
the process which
>reads the state and skips to that point to continue
processing.
>Russell Fields
>"Gabriela" <gnanau@.cstonecanada.com> wrote in message
>news:0d3201c394b9$76e81e10$a301280a@.phx.gbl...
>> Is there any possibility to force a deadlock priority
>> higher than normal? what I want is to keep my process
>> running and not to be chosen as deadlock victim, no
matter
>> what. Put different, I want to know if there is a way to
>> overwrite the default deadlock-handling method.
>> Set DEADLOCK_PRIORITY is not to clearly explained in
Books
>> Online from this point of view.
>> thank you
>
>.
>