DeadLock

[balachandar]

Hi All,
I would like to know more in detail about dead locks in DB2.
I am looking for
1. Which Process have together caused the deadlock ?
2. How to kill the deadlock?

Also I want to know where I can get literature for IBM DB2 tables while some of them are self explanatory, We want to know more in detail about information stored in system tables.

Thanks
Balachandar Ganesan.

 

[pkganapathi]

HI,
You can find info about deadlocks in the DB2 Master Log on SDSF. You can look for errors 00C9008E which indicate deadlock.

How to kill threads? You may need to access to monitoring tools and kill the thread that you want.

Hope this helps.
-PK

I.T.Analyst
Tata Consultancy Services

 

[db2sachin]

to know abt deadlocks u can use foll command on db2cmd
db2 get snapshot for locks on <Data Base name>
& to kill all applications u can either use
db2stop force or

db2 force application all &
db2stop togather.
after doing this u'll have to restrat u'r database using
db2start.

For information on table u can see SYSCAT 's TABLE .
Let me know if u got what u wanted.