"db2 get snapshot for applications on <db>" will tell you which applications have had "Deadlocks detected" > 0.
db2 get snapshot for locks on <db> should do identify the deadlocs. It shows all the locks held on which table and by which application. Just search through it for applications which have a large "total wait time (ms)". James -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: 29 July 2003 17:39 To: [EMAIL PROTECTED] Subject: [DB2EUG] Identify row by RID Hi, the deadlock monitor will identify the lock object name of a deadlocked row. The systems monitor guide and reference says: For row-level locks, the object name is the row ID (RID). Without using DB2DART on the production system, is there any way I can establish which rows are the subject of the deadlock? Thanks, Graham Parish - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc - ::: When replying to the list, please use 'Reply-All' and make sure ::: a copy goes to the list ([EMAIL PROTECTED]). *** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] *** For more information, check http://www.db2eug.uni.cc
