Arun Srinivasan wrote:
> Please correct me if I am wrong
> 1. no 2 processes can have exclusive lock on same object (by object,
> same row or same table)
> 2. on deadlock incident between 2 processes only one of them will be
> cancelled by db2 to let the other finish.
>
> Now, can there be an instance where 2 processes have 'EXCLUSIVE LOCK'
> on same table, and are waiting on the same 'EXCLUSIVE LOCK' held by
> the other agent to be relinquished. They both are cancelled by db2
> using the 911 sqlstate.
> It has been continuously happening to me, and it perplexes me.
>
> This happenes because I use the 'lock table <table_name> in exclusive
> mode' statement in a stored procedure, and I call that SP in three
> applications at the same instance. Can this happen? I also got event
> monitor output, and am analysing the same.
From this brief description we should be able to answer your question?
--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany
|
