> The snapshots that I've taken show both deadlocks and > rollbacks. Ouch!
Sounds like lock order. "Player 1: grab lock A then lock B." "Player 2: grap lock B then lock A." Can you shorten up the timeout and deadlock detection intervals to make the race condition quicker to trigger? Let me guess, this is client/server with WinDos apps running directly against your production database? -HJC - ::: 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
