Hi there, Does anybody know of a simple way to find out which table is causing a lock wait for a particular connection, or for that matter, which users / connections have locks on a particular table? I'm running DB2 UDB 7.1 FP2 on WinNT 4 SP6a. I know that there are tools that do this, but the problem doesn't occur often enough for it to be worthwhile spending $$$ - we use DB2 for data warehousing, so locking / deadlocks isn't a problem we face too often. TIA Howard Wright Cape Town, South Africa ===== To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED] For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
