468,257 Members | 1,419 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

Lock-waits don't get logged ... but

what commands can I use to find out what connection is causing a lock?

where can i change the verbosity level of db2 logfiles?
where are those logfiles?

Greetings & Thanks
Victor
Nov 12 '05 #1
1 1209
Snapshot for locks will show you what applications are in lock wait, and
the app holding the lock they need.

diag level is adjusted by the dbm cfg parm diaglevel, and the log file
goes in sqllib\db2dump by default (or DIAGPATH in the dbm cfg if that is
set).

news_account wrote:
what commands can I use to find out what connection is causing a lock?

where can i change the verbosity level of db2 logfiles?
where are those logfiles?

Greetings & Thanks
Victor

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by Christoph Zeltner | last post: by
7 posts views Thread by Sunny | last post: by
3 posts views Thread by Invalid | last post: by
14 posts views Thread by Sharon | last post: by
3 posts views Thread by Raj | last post: by
9 posts views Thread by kavallin | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.