db2pd locking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

interz12 - 15 May 2007 16:46 GMT

Hi,
Does anyone know of a tool that gives a bit more readable info out of
the db2pd tool when executing Locktest? I'm thinking of something that
will show the type of lock and which tables by name rather than by ids
etc.

thanks!
A

Reply to this Message

Jan M. Nelken - 15 May 2007 16:56 GMT

> Hi,
> Does anyone know of a tool that gives a bit more readable info out of
[quoted text clipped - 4 lines]
> thanks!
> A

What you mean by locktest?

I have a script which shows application handle(s) and tables locked when
there is a lock wait situation.

Type of lock, page and row you can get by adding showlock to db2pd:

db2pd -lock wait showlock -db <alias>

Jan M. Nelken

Reply to this Message

Joachim Müller - 15 May 2007 17:31 GMT

Hi,

in DB2 9 there are a lot of SYSIBMADM views that you can use:

sysibmadm.locks_held
sysibmadm.lockwaits

best regards,
Joachim Müller

> Hi,
> Does anyone know of a tool that gives a bit more readable info out of
[quoted text clipped - 4 lines]
> thanks!
> A

Reply to this Message