Event monitor that gives more lock info?

shorti

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

Jun 25 '07 #1

Kiran Nair

Probably you should try creating event monitor for deadlocks with
details.

shorti wrote:

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

Jun 26 '07 #2

shorti

On Jun 25, 8:06 pm, Kiran Nair <kiranhariha...@gmail.comwrote:

Probably you should try creating event monitor for deadlocks with
details.

/sigh

Thank you..I missed that in my haste!

Jun 26 '07 #3

Ian

shorti wrote:

On Jun 25, 8:06 pm, Kiran Nair <kiranhariha...@gmail.comwrote:

>Probably you should try creating event monitor for deadlocks with
details.

/sigh

Thank you..I missed that in my haste!

This won't provide you any information -- you're getting lock waits (and
perhaps lock timeouts (SQL0911N rc=68).

The deadlock event monitor will only help if you're getting deadlocks
(SQL0911N rc=2).

Jun 26 '07 #4