467,170 Members | 1,106 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,170 developers. It's quick & easy.

Finding locks

Ok, why does the db2 diag log not reporting deadlocks and escalations
any longer? Something I am doing wrong here? Also in the db2diag.log
what is the difference between and TID and a PID. If I try and trace
the application id of process that locked I do not find it. My guess
is that since these programs make a connection and then disconnect
that it is no longer there. In previous versions I thought I remember
where the log actually showed the application name. This would be very
beneficial to have unless someone can tell me a better way of tracking
down a app that is locking by what was or is the PID/TID. Thanks for
any advice,
Mike

Win2k3
db2 8.1 fp 7a
Nov 12 '05 #1
  • viewed: 1757
Share:
1 Reply
PID/TID is process id/thread id. On windows all db2 edus run in a single
process (they're threads).

For deadlocks, have you looked at the deadlock event monitor? It will
report app, statement text, and lock list for each app involved in the
deadlock...you can use a write to table event monitor if you want to
access the data via SQL.

(I don't know the answer to why/what has changed that would cause you
not to see these in the diag.log).

Mike wrote:
Ok, why does the db2 diag log not reporting deadlocks and escalations
any longer? Something I am doing wrong here? Also in the db2diag.log
what is the difference between and TID and a PID. If I try and trace
the application id of process that locked I do not find it. My guess
is that since these programs make a connection and then disconnect
that it is no longer there. In previous versions I thought I remember
where the log actually showed the application name. This would be very
beneficial to have unless someone can tell me a better way of tracking
down a app that is locking by what was or is the PID/TID. Thanks for
any advice,
Mike

Win2k3
db2 8.1 fp 7a

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by aswinee | last post: by
17 posts views Thread by Dr NoName | last post: by
6 posts views Thread by John Carroll | last post: by
reply views Thread by Bruce Pullen | last post: by
1 post views Thread by Zri Man | last post: by
4 posts views Thread by Alex Callea | last post: by
7 posts views Thread by praveen | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.