Hello all,

I am running with DB2 UDB V8 on AIX.

I am trying to track down what appears to be a lock issue.  I turned
EVENT MONITOR on with all the options.  It doesnt give me the detailed
information I need for tracking who is holding the lock.  Here is what
I get in the event monitor:

------------------------------------------------------------------------

55768) Transaction Event ...
 Appl Handle: 399

 Record is the result of a flush: FALSE
 Appl Id: *LOCAL.xxxuser.070622225720
 Appl Seq number: 5259
 Completion Status: Committed
 Start time: 06/25/2007 17:29:02.291770
 Stop time:  06/25/2007 17:29:13.209640
 Exec Time:  10.917870 seconds
 Previous transaction stop time: 06/25/2007 17:29:02.175785
 User CPU: 0.032198 seconds
 System CPU: 0.007544 seconds
 Lock wait time: 7003
 Maximum number of locks held: 14
 Lock escalations: 0
 X lock escalations: 0
 Rows Read: 3
 Rows Written: 0
 Log space used: 0

------------------------------------------------------------------------------------------

 Lock wait time: 7003  Is this Seconds??  I couldnt find that
information..Info Center only says that it the time the app waited for
the lock and doesnt say if it means milleseconds or seconds

Anyway, back to the subject.  Doing the lock snapshot gets me some
good information but I really need the info in a monitor.  Does anyone
know of a monitor that will give lock information on who is holding
the lock?

Thanks much