db2pd locking

[interz12]

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

[Jan M. Nelken]

interz12 wrote:

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

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

[=?iso-8859-1?Q?Joachim_M=FCller?=]

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

"interz12" <in******@yahoo.comschrieb im Newsbeitrag
news:11*********************@w5g2000hsg.googlegrou ps.com...

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