David,
Use db2 event monitor for deadlocks. This will give you more information about
deadlocks.
Regards,
Ajith
-----Original Message-----
From: David Hayes [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 08, 2001 6:48 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: Deadlocking
Hi listers
One of our developers has a problem with deadlocking in a UDB V6.1
Solaris environment. There are 2 processes accessing a 400K row table.
One process just inserts one row, the other process just updates one row
(not the same row). There is row level locking on the table.
Occasionally the processes deadlock and I'm curious why. There are
several indexes on the table, some of which contain many duplicate
entries. For example, one index contains a Status Indicator that only
has 4 different values. The updating process will update this Status
field. The only predicate specified on the update SQL is on a column
which is used as a unique index. There is no lock escalation.
My suspicion is that the deadlocking must be caused by index maintenance
when the indexed fields are updated but I'm not sure how much is locked
when the index keys are moved. I'd be grateful if anyone could confirm
(or otherwise) my suspicions.
Thanks
Dave Hayes
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
