Showing posts with label db2pd. Show all posts
Showing posts with label db2pd. Show all posts

Friday, October 17, 2014

db2pd and Lock Wait

db2pd has got to be one of my all time favourite tool. It is like the swiss knife of troubleshooting :)  But recently I found out that there is *one* thing that it can't do:

----> It can't display lock wait chain that is triggered  by a lock conversion <----

That is very surprising. Is it a bug? Given that the same lock chain can be displayed by db2top, so, it is really weird that db2pd has no visibility of such lock blocking.

Beware!