By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,559 Members | 1,180 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,559 IT Pros & Developers. It's quick & easy.

db2pd locking

P: n/a
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

May 15 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
May 15 '07 #2

P: n/a
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
May 15 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.