This is a discussion on Lock-waits don't get logged ... but within the DB2 forums, part of the Database Server Software category; --> what commands can I use to find out what connection is causing a lock? where can i change the ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |