I am trying to decipher deadlock events in a event monitor. I am
trying to determine what type of lock was held. If I look at the data
elements it shows LOCK MODE 5
LOCK MODE REQUESTED 3

I can not seem to find any docs which shows what type of lock a LOCK
MODE of 5 or any other number is. Can anyone please point me in the
right direction?
Specs:
Win2k3
Db2 ver 8.2

Something has changed with locking in Db2 8.2 but I can not seem to
figure out what it is. I have read all of the new docs on locking and
have tried all suggestions and just can not put my finger on it.
Programs are not reacting to deadlocks the way they used to. I know it
is hard to explain what it is but I basically have 2 apps that are
deadlocking each other I just can't seem to figure out why. Which
itself is ok, but it is almost like the apps are not always seeing the
-911 codes being returned. Was there a new code added or some other
code I may be getting that would result in a deadlock? Any info would
be much appreciated!!

Thanks,
Mike
Thanks,
Mike

Correct me here if need be, but I thought that lock modes were in
ALPHABETS rather than digits. Example X for and Exclusive Lock, IX for
Intent Exclusive and S for Share. I have being seeing this in UDB 6.1
till 8.1, has it changed in UDB 8.2?

thanks,
dotyet

mike.mcneer@thomson.net (Mike) wrote in message news:<a3ab20a1.0411090848.458cae43@posting.google. com>...
> I am trying to decipher deadlock events in a event monitor. I am
> trying to determine what type of lock was held. If I look at the data
> elements it shows LOCK MODE 5
> LOCK MODE REQUESTED 3
>
> I can not seem to find any docs which shows what type of lock a LOCK
> MODE of 5 or any other number is. Can anyone please point me in the
> right direction?
> Specs:
> Win2k3
> Db2 ver 8.2
>
> Something has changed with locking in Db2 8.2 but I can not seem to
> figure out what it is. I have read all of the new docs on locking and
> have tried all suggestions and just can not put my finger on it.
> Programs are not reacting to deadlocks the way they used to. I know it
> is hard to explain what it is but I basically have 2 apps that are
> deadlocking each other I just can't seem to figure out why. Which
> itself is ok, but it is almost like the apps are not always seeing the
> -911 codes being returned. Was there a new code added or some other
> code I may be getting that would result in a deadlock? Any info would
> be much appreciated!!
>
> Thanks,
> Mike
> Thanks,
> Mike

If you are doing a get snapshot for locks on database you will get the
info in Alpha form. I am looking at the data element information from
event analyzer it is a Integar. Can you compare this?











dotyet@yahoo.com (dotyet) wrote in message news:<6c6dc4d2.0411091537.5eb43b8@posting.google.c om>...
> Correct me here if need be, but I thought that lock modes were in
> ALPHABETS rather than digits. Example X for and Exclusive Lock, IX for
> Intent Exclusive and S for Share. I have being seeing this in UDB 6.1
> till 8.1, has it changed in UDB 8.2?
>
> thanks,
> dotyet
>
> mike.mcneer@thomson.net (Mike) wrote in message news:<a3ab20a1.0411090848.458cae43@posting.google. com>...
> > I am trying to decipher deadlock events in a event monitor. I am
> > trying to determine what type of lock was held. If I look at the data
> > elements it shows LOCK MODE 5
> > LOCK MODE REQUESTED 3
> >
> > I can not seem to find any docs which shows what type of lock a LOCK
> > MODE of 5 or any other number is. Can anyone please point me in the
> > right direction?
> > Specs:
> > Win2k3
> > Db2 ver 8.2
> >
> > Something has changed with locking in Db2 8.2 but I can not seem to
> > figure out what it is. I have read all of the new docs on locking and
> > have tried all suggestions and just can not put my finger on it.
> > Programs are not reacting to deadlocks the way they used to. I know it
> > is hard to explain what it is but I basically have 2 apps that are
> > deadlocking each other I just can't seem to figure out why. Which
> > itself is ok, but it is almost like the apps are not always seeing the
> > -911 codes being returned. Was there a new code added or some other
> > code I may be getting that would result in a deadlock? Any info would
> > be much appreciated!!
> >
> > Thanks,
> > Mike
> > Thanks,
> > Mike